SAP BLOG 0CFM_DELTA_POSITIONS: Missing BW Fields for Customer Credit(KUNNR_C) and Customer Debit(KUNNR_D)

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,272
Tepki puanı
6
Puanları
6
Issue:

While using 0CFM_DELTA_POSITIONS data-source pertaining to Treasury and Risk Management, Customer Credit(KUNNR_C) and Customer Debit(KUNNR_D) fields are missing in standard data-source. There is field for customer in data source but there should be separate logic to differentiate the customer credit and debit fields.



Solution:

Manual Activity:

1) Use transaction SE11 to enhance the following structures:

  • FTI_BIW_ODS_0CFM_O01_ATTR

After the component ORIGIN_DATE, add the following two components:

KUNNR_D Types KUNNR

KUNNR_C Types KUNNR

  • TRLS_REPORT_MAP_FLOW_DATA

After the component TRLFLOWNUMBER, add the following two components:

KUNNR_D Types KUNNR

KUNNR_C Types KUNNR

  • Save and Activate the structures.

2) Add new fields in ROOSFIELD table for 0CFM_DELTA_POSITIONS datasource.

  • create following z program to add the fields in ROOSFIELD table.

TABLES: ROOSFIELD.

UPDATE ROOSFIELD CLIENT SPECIFIED SET SELECTION = ‘3’

WHERE OLTPSOURCE = ‘0CFM_DELTA_POSITIONS’ AND OBJVERS = ‘A’

AND FIELD = ‘KUNNR_C’.

WRITE SY-SUBRC.

Execute the program for each of the field and check the entries in RSA6/RSO2.

  • Un tick the Hide option from RSA6 for KUNNR_C and KUNNR_D fields for 0CFM_DELTA_POSITIONS data-source.

3) Replicate the data-source in BW and activate.

References:

2544160 – BW fields for customer and creditor in 0CFM_DELTA_POSITIONS

BW Tips and Tricks - SAP NetWeaver Business Warehouse - SCN Wiki

Okumaya devam et...
 
Üst