Logic for SAKNR, LIFNR fields in ECC extractor 0CO_OM_CCA_40

[SreekanthSurampally]

Hi, we are recreating the extractor 0CO_OM_CCA_40 (Cost Center Actual Line items) logic in a HANA CV model. We could get the base tables and logic for all the fields except 3 and they are KUNNR, LIFNR and SAKNR.

In the help documentation, it is written as "Converted from COVP-GKONT" but couldn't find more details.

https://help.sap.com/docs/SAP_ERP/b42281c1645049a4b07c0ab25ec8b899/68d58853630b3d58e10000000a174cb4....

Can you please let me know how to achieve the logic for them?

Thanks

Sreekanth

[dushmanta_das8970]

Hi,

To recreate the logic for the fields SAKNR, LIFNR, and KUNNR in the ECC extractor 0CO_OM_CCA_40 (Cost Center Actual Line items) in your HANA CV model, you can follow the steps below:

Obtain the necessary data from the base tables of the extractor, such as COEP (CO Object: Line Item), COSP (CO Object: Cost Totals for External Postings), and COBK (CO Object: Document Header).

Extract the COVP-GKONT field from the base tables. COVP-GKONT represents the general ledger account number associated with the cost center.

Use the COVP-GKONT field as a key to join with the relevant tables or views in your HANA CV model. One table to consider is SKA1 (G/L Account Master), which contains information about general ledger accounts.

Join the COVP-GKONT field with the SKA1 table based on the account number. This will allow you to retrieve additional information related to the general ledger account.

From the SKA1 table, extract the necessary fields to populate the KUNNR (customer number), LIFNR (vendor number), and SAKNR (general ledger account number) in your HANA CV model. These fields may vary based on your specific requirements, but commonly used fields include KUNNR, LIFNR, and SAKNR.

Implement the appropriate mappings or transformations based on the extracted data and populate the KUNNR, LIFNR, and SAKNR fields in your HANA CV model accordingly.

By following these steps, you should be able to recreate the logic for the SAKNR, LIFNR, and KUNNR fields in the 0CO_OM_CCA_40 extractor in your HANA CV model. Try It.

[SreekanthSurampally]

Hi, I have debugged the extractor function module BWOMD_SREP_GET_CTRCSTA1 to get the logic for these fields. the logic is is based on GKOAR column in COEP and as shown in the screenshot below. It is fine now.

[SreekanthSurampally]

Hi, You said that

From the SKA1 table, extract the necessary fields to populate the KUNNR (customer number), LIFNR (vendor number), and SAKNR (general ledger account number) in your HANA CV model. These fields may vary based on your specific requirements, but commonly used fields include KUNNR, LIFNR, and SAKNR.

How do I get the KUNNR and LIFNR from SKA1?