cancel
Showing results for 
Search instead for 
Did you mean: 

Plant - Company Code extraction

Expert
Active Contributor
0 Kudos

How can I extract Plant-Company Code from Hana on Cloud

Accepted Solutions (1)

Accepted Solutions (1)

Expert
Active Contributor
0 Kudos

Hello ‎@Deepak Kumar,

There is no direct CDS view which can provide you the plant - company code information, but I guess using combination of below CDS views you can built your own custom analytical query for deriving data;

I_CustomerCompanyByPlant (Which plant is assigned to which company code for a certain customer?)

I_Plant (What are the details of my plant?)

I_SupplierCompanyByPlant (Which plant is assigned to which company code for a certain supplier?)

Refer below link for more information on above CDS views;

https://help.sap.com/viewer/0f69f8fb28ac4bf48d2b57b9637e81fa/2005.500/en-US/e56a66802eb14b319c6836b5...

Best Regards,

Vijayendra

Answers (1)

Answers (1)

Expert
Active Contributor
0 Kudos

This is a re-posted Q&A of an earlier question on this community