Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavinvyas
Active Contributor
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

 

 

 

 

 
Labels in this area