CDS VIEWS: PURCHASE ORDER ITEM AND ACCOUNTING DATA

[Anna_Rafter]

Hello,

We would like to find a CDS that provides at least some of the key fields of the EKKN table.

As the CDS that I have created is combinig various standard CDS, and the order position is selected as the main one, I need the following fields (I indicate the values ​​that these fields have in R3):

è Purchase Order (EBELN) and purchase order item (EBELP) -- to be able to link the CDS with my main CDS.

è GL Account (SAKTO), Cost Center (KOSTL), Fixed Asset (ANLN1), Cost Object (KSTRG), WBS Element (PS_PSP_PNR), Profit Center (PRCTR), Functional Area (FKBER), Activity Type (LSTAR), …

I was able to find fields specified in the second line (SAKTO, KOSTL, ANLN1,....) in the following CDS, however they do not have the purchase order or purchase order item which would allow us to retrieve needed information :

à I_SuplrInvcItmAcctAssgmtAPI01.

à I_PurReqnAcctAssgmt_Api01.

The problem is that none has the key fields that I want, therefore, if I add needed fields from these CDS views, these fields show no value. 

Could  you help us by providing any standard CDS with the needed information?

Thanks!

Best regards.

Carmen,

[former_member131691 · Accepted solution]

Hi Carmen

I was looking into this there have been a few customer requests along these lines.

I can see from our development team that we currently don't have a whitelisted CDS view for Accounting Information of the purchase order. Our Development team are aware of this and have taken it as a development request for consideration in a future release. This is the current position

Kind regards

Brian

[former_member691955 · Accepted solution]

Hi Brain,

How are you? any further update on the whitelisted CDS view for Accounting Information of the purchase order. I have a similar requirement.

Regards,

Shiv

[former_member131691]

Hi Shiv

CDS view I_PurOrdAccountAssignmentAPI01 should fit the bill now.

See the API Hub documentation here:
https://api.sap.com/cdsviews/I_PURORDACCOUNTASSIGNMENTAPI01

Kind regards
Brian

[Ashish_Shakya]

Thanks 🙂