Standard CDS Views that helped me load Master Data for SAC Planning

Estimated read time 3 min read

Hi SAP Community,

With any SAC Planning implementation project, there is always a requirement to load the master data and Transaction Data before we begin with the input sheets, Data actions and so on. In most of the SAC Planning scenarios, the required dimensions would most likely remain the same. So why spend energy when SAP provides us with all the detailed high quality information we need.

Eg:-
For Sales –> Country, Profit Center, Product Group, Segment, Trading Partner, Company code.
For Opex –> Cost Center
For Capex –> Asset Class, Material Group, Transaction Type

In order to populate the master dimensions, we needn’t write any custom Views or logic to achieve it, that is where Standard CDS Views comes into the picture. The official SAP documentation provides many Standard CDS views for the individual LOBs.
https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/5418de55938d1d22e10000000a44147b.html

Some of these CDS views even come with a view that holds the text description data for that field.

Public Dimension

CDS View Name

Z_Country

A_Country

A_CountryText

Z_PROFIT_CENTER

A_Profitcenter

A_ProfitcenterText

Z_PRODUCTGROUP

I_ProductGroup2

Z_SEGMENT

A_Segment

A_SegmentText

Z_TRADING_PARTNER

I_PartnerCompany

Z_COMPANYCODE

A_CompanyCode

Z_COSTCENTER

A_Costcenter

A_CostcenterText

Z_TRANSACTION_TYPE

FinancialTransactionType

Z_ASSET_CLASS

I_AssetClassStdVH

Z_MATERIAL_GROUP

I_MaterialGroup

I hope this information helps you with your Project and makes your life easier. I will try sharing more tips and tricks which helped me through some of the projects I’ve faced. Feel free to share your opinion or doubts in the comment section below.

With regards,
Siva Prakash.

 

 

 

 

​ Hi SAP Community,With any SAC Planning implementation project, there is always a requirement to load the master data and Transaction Data before we begin with the input sheets, Data actions and so on. In most of the SAC Planning scenarios, the required dimensions would most likely remain the same. So why spend energy when SAP provides us with all the detailed high quality information we need.Eg:-For Sales –> Country, Profit Center, Product Group, Segment, Trading Partner, Company code.For Opex –> Cost CenterFor Capex –> Asset Class, Material Group, Transaction TypeIn order to populate the master dimensions, we needn’t write any custom Views or logic to achieve it, that is where Standard CDS Views comes into the picture. The official SAP documentation provides many Standard CDS views for the individual LOBs.https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/5418de55938d1d22e10000000a44147b.htmlSome of these CDS views even come with a view that holds the text description data for that field.Public DimensionCDS View NameZ_CountryA_CountryA_CountryTextZ_PROFIT_CENTERA_ProfitcenterA_ProfitcenterTextZ_PRODUCTGROUPI_ProductGroup2Z_SEGMENTA_SegmentA_SegmentTextZ_TRADING_PARTNERI_PartnerCompanyZ_COMPANYCODEA_CompanyCodeZ_COSTCENTERA_CostcenterA_CostcenterTextZ_TRANSACTION_TYPEFinancialTransactionTypeZ_ASSET_CLASSI_AssetClassStdVHZ_MATERIAL_GROUPI_MaterialGroupI hope this information helps you with your Project and makes your life easier. I will try sharing more tips and tricks which helped me through some of the projects I’ve faced. Feel free to share your opinion or doubts in the comment section below.With regards,Siva Prakash.       Read More Technology Blog Posts by Members articles 

#SAP

#SAPTechnologyblog

You May Also Like

More From Author