Sorun Cevaplayalım

İşinizle ilgili öngörüler edinin, gerçek zamanlı bilgilere göre karar alın.

SAP Eğitim ve Sertifika Dönemleri

Uzmanlığınızı ve deneyiminizi SAP çözümleri kullanarak tasdik edin.

Çözüm Ekibi Başvurusu

Kullanıcılara hızlı ve pratik çözümler üreterek görev almak isteyenler.

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,035
Tepki puanı
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