I_CNSLDTNADDLMD

CDS View
2 Fields 77 CDS Views

Consolidation Additional Master Data

I_CNSLDTNADDLMD is a CDS View in S/4HANA. Consolidation Additional Master Data. It contains 2 fields. 77 CDS views read from this table.

CDS Views using this table (77)

ViewTypeJoinVDMDescription
I_CnsldtnMasterData view from COMPOSITE Consolidation - Combined Master Data
P_CnsldtnBillingDocumentType view union_all COMPOSITE Consolidation Combined Billing Document Type
P_CnsldtnBillingDocumentTypeT view union_all COMPOSITE Consolidation Combined Billing Document Type Text
P_CnsldtnBillingType view union_all BASIC Consolidation Combined Billing Type
P_CnsldtnBillingTypeT view union_all BASIC Consolidation Combined Billing Type Text
P_CnsldtnBusinessArea view union_all COMPOSITE Consolidation Combined Business Area
P_CnsldtnBusinessAreaT view union_all COMPOSITE Consolidation Combined Business Area Text
P_CnsldtnControllingArea view union_all COMPOSITE Consolidation Combined Controlling Area
P_CnsldtnControllingAreaT view union_all COMPOSITE Consolidation Combined Controlling Area Text
P_CnsldtnCostCenter view from COMPOSITE Consolidation Combined Cost Center
P_CnsldtnCostCenter view union_all COMPOSITE Consolidation Combined Cost Center
P_CnsldtnCostCenterT view from COMPOSITE Consolidation Combined Cost Center
P_CnsldtnCostCenterT view union_all COMPOSITE Consolidation Combined Cost Center
P_CnsldtnCountry view union_all COMPOSITE Consolidation Combined Country/Region
P_CnsldtnCountryT view union_all COMPOSITE Consolidation Combined Country/Region - Txt
P_CnsldtnCustomer view union_all COMPOSITE Consolidation Combined Customer
P_CnsldtnCustomerGroup view union_all COMPOSITE Consolidation Combined Customer Group
P_CnsldtnCustomerGroupT view union_all COMPOSITE Consolidation Combined Customer Group - Text
P_CnsldtnCustomerT view union_all COMPOSITE Consolidation Combined Customer Text
P_CnsldtnDistributionChannel view union_all COMPOSITE Consolidation Combined Distribution Channel
P_CnsldtnDistributionChannelT view union_all COMPOSITE Consolidation Combined Distribution Channel Text
P_CnsldtnDivision view union_all COMPOSITE Consolidation Combined Division
P_CnsldtnDivisionT view union_all COMPOSITE Consolidation Combined Division Text
P_CnsldtnFinancialDataSource view_entity union_all COMPOSITE Consolidation Financial Data Source
P_CnsldtnFinancialDataSourceT view_entity union_all COMPOSITE Consolidation Financial Data Source - Text
P_CnsldtnFinManagementArea view_entity union_all COMPOSITE Consolidation Financial Management Area
P_CnsldtnFinManagementAreaT view_entity union_all COMPOSITE Consolidation Public Sector Financial Management Area - Text
P_CnsldtnFinServicesBranch view_entity union_all COMPOSITE Consolidation Financial Services Branch
P_CnsldtnFinServicesBranchT view_entity union_all COMPOSITE Consolidation Financial Services Branch - Text
P_CnsldtnFinSrvcsProductGroup view_entity union_all COMPOSITE Consolidation Financial Services Product Group
P_CnsldtnFinSrvcsProductGroupT view_entity union_all COMPOSITE Consolidation Financial Services Product Group - Text
P_CnsldtnFinTransType view union_all COMPOSITE Consolidation Combined FinTransType
P_CnsldtnFinTransTypeT view union_all COMPOSITE Consolidation Combined FinTransType Text
P_CnsldtnFunctionalArea view union_all COMPOSITE Consolidation Combined Functional Area
P_CnsldtnFunctionalAreaT view union_all COMPOSITE Consolidation Combined Functional Area
P_CnsldtnFund view_entity union_all COMPOSITE Consolidation Fund
P_CnsldtnFundT view_entity union_all COMPOSITE Consolidation Fund - Text
P_CnsldtnGLAccount view union_all COMPOSITE Consolidation Combined G/L Account
P_CnsldtnGLAccountT view union_all COMPOSITE Consolidation Combined G/L Account Text
P_CnsldtnGLChartOfAccounts view union_all COMPOSITE Consolidation Combined G/L Chart Of Accounts
P_CnsldtnGLChartOfAccountsT view union_all COMPOSITE Consolidation Combined G/L Chart Of Accounts - Text
P_CnsldtnGrant view_entity union_all COMPOSITE Consolidation Grant
P_CnsldtnGrantT view_entity union_all COMPOSITE Consolidation Grant - Text
P_CnsldtnIndustry view union_all COMPOSITE Consolidation Combined Industry Key
P_CnsldtnIndustryT view union_all COMPOSITE Consolidation Combined Industry Key Text
P_CnsldtnMaterial view union_all COMPOSITE Consolidation Combined Material
P_CnsldtnMaterialGroup view union_all COMPOSITE Consolidation Combined Material Group
P_CnsldtnMaterialGroupT view union_all COMPOSITE Consolidation Combined Material Group Text
P_CnsldtnMaterialT view union_all COMPOSITE Consolidation Combined Material Text
P_CnsldtnOrder view union_all COMPOSITE Consolidation Combined Order
P_CnsldtnOrderT view union_all COMPOSITE Consolidation Combined Order - Text
P_CnsldtnPartnerCompany view union_all BASIC Consolidation Combined Company ID of Trading Partner
P_CnsldtnPartnerCompanyT view union_all BASIC Consolidation Combined Company ID of Trading Partner
P_CnsldtnPlant view union_all COMPOSITE Consolidation Combined Plant
P_CnsldtnPlantT view union_all COMPOSITE Consolidation Combined Plant - Text
P_CnsldtnProduct view union_all COMPOSITE Consolidation Combined Material
P_CnsldtnProductGroup view union_all COMPOSITE Consolidation Combined Product Group
P_CnsldtnProductGroupT view union_all COMPOSITE Consolidation Combined Product Group Text
P_CnsldtnProductT view union_all COMPOSITE Consolidation Combined Product Text
P_CnsldtnProfitCenter view from COMPOSITE Consolidation Combined Profit Center
P_CnsldtnProfitCenter view union_all COMPOSITE Consolidation Combined Profit Center
P_CnsldtnProfitCenterT view from COMPOSITE Consolidation Combined Profit Center Text
P_CnsldtnProfitCenterT view union_all COMPOSITE Consolidation Combined Profit Center Text
P_CnsldtnProject view union_all COMPOSITE Consolidation Combined Project
P_CnsldtnProjectT view union_all COMPOSITE Consolidation Combined Project Text
P_CnsldtnSalesDistrict view union_all COMPOSITE Consolidation Combined Sales District
P_CnsldtnSalesDistrictT view union_all COMPOSITE Consolidation Combined Sales District Text
P_CnsldtnSalesOrganization view union_all COMPOSITE Cnsldtn Combined Sales Organization
P_CnsldtnSalesOrganizationT view union_all COMPOSITE Cnsldtn Combined Sales Organization - Text
P_CnsldtnSegment view union_all COMPOSITE Consolidation Combined Segment
P_CnsldtnSegmentT view union_all COMPOSITE Consolidation Combined Segment - Text
P_CnsldtnSupplier view union_all COMPOSITE Consolidation Combined Supplier
P_CnsldtnSupplierT view union_all COMPOSITE Consolidation Combined Supplier Text
P_CnsldtnSustModeOfTransport view_entity union_all COMPOSITE Cnsldtn Sustainability Mode of Transport
P_CnsldtnSustModeOfTransportT view_entity union_all COMPOSITE Cnsldtn Sust Mode of Transport - Text
P_CnsldtnWBSElement view union_all COMPOSITE Consolidation Combined WBS Element
P_CnsldtnWBSElementT view union_all COMPOSITE Consolidation Combined WBS Element Text

Fields (2)

KeyField CDS FieldsUsed in Views
KEY AdditionalMasterDataCode BillingDocumentType,FinancialDataSource,FinancialManagementArea,FinancialServicesBranch,FinancialServicesProductGroup,Fund,GrantID,Material,SustainabilityModeOfTransport 9
KEY AdditionalMDSuprordFieldValue FinancialManagementArea 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Consolidation Additional Master Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNADDLMD (
    ADDITIONALMASTERDATACODE,
    ADDITIONALMDSUPRORDFIELDVALUE,
    PRIMARY KEY (ADDITIONALMASTERDATACODE, ADDITIONALMDSUPRORDFIELDVALUE)
);

Learn More