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:
After the component ORIGIN_DATE, add the following two components:
KUNNR_D Types KUNNR
KUNNR_C Types KUNNR
After the component TRLFLOWNUMBER, add the following two components:
KUNNR_D Types KUNNR
KUNNR_C Types KUNNR
2) Add new fields in ROOSFIELD table for 0CFM_DELTA_POSITIONS datasource.
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.
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...
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...