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

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

https://wiki.scn.sap.com/wiki/display/BI/BW+Tips+and+Tricks