I_CNSLDTNMDUPLDUNITWRKAREA

CDS View
22 Fields 2 CDS Views

Consolidation Unit Work Area

I_CNSLDTNMDUPLDUNITWRKAREA is a CDS View in S/4HANA. Consolidation Unit Work Area. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_CnsldtnMDUpldUnitWrkArea view from CONSUMPTION Consolidation Unit Work Area
P_CnsldtnMDUpldStatistics view from COMPOSITE

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CnsldtnMDUpldRecdUUID CnsldtnMDUpldRecdUUID 1
CnsldtnCrcyTranslationMethod CnsldtnCrcyTranslationMethod 1
CnsldtnDataTransferMethod CnsldtnDataTransferMethod 1
CnsldtnMDUpldRecdStatus CnsldtnMDUpldRecdStatus 1
CnsldtnMDUpldRecdStatusDetail CnsldtnMDUpldRecdStatusDetail 1
CnsldtnReadFrmUnivJrnlEffctvYr CnsldtnReadFrmUnivJrnlEffctvYr 1
CnsldtnUnitSndrCrcyForGrpCrcy CnsldtnUnitSndrCrcyForGrpCrcy 1
CnsldtnUnitSndrCrcyForLoclCrcy CnsldtnUnitSndrCrcyForLoclCrcy 1
CnsldtnUploadMethod CnsldtnUploadMethod 1
ConsolidationDimension ConsolidationDimension 1
ConsolidationLedger ConsolidationLedger 1
ConsolidationUnit ConsolidationUnit 1
ConsolidationUnitLocalCurrency ConsolidationUnitLocalCurrency 1
ConsolidationUnitMdmText ConsolidationUnitMdmText 1
ConsolidationUnitText ConsolidationUnitText 1
ConsolidationVersion ConsolidationVersion 1
Country Country 1
DocumentEntryIsInGroupCurrency DocumentEntryIsInGroupCurrency 1
FiscalYearPeriod FiscalYearPeriod 1
FiscalYearVariant FiscalYearVariant 1
Language Language 1
TaxRate TaxRate 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 Unit Work Area
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNMDUPLDUNITWRKAREA (
    CNSLDTNMDUPLDRECDUUID,
    CNSLDTNCRCYTRANSLATIONMETHOD,
    CNSLDTNDATATRANSFERMETHOD,
    CNSLDTNMDUPLDRECDSTATUS,
    CNSLDTNMDUPLDRECDSTATUSDETAIL,
    CNSLDTNREADFRMUNIVJRNLEFFCTVYR,
    CNSLDTNUNITSNDRCRCYFORGRPCRCY,
    CNSLDTNUNITSNDRCRCYFORLOCLCRCY,
    CNSLDTNUPLOADMETHOD,
    CONSOLIDATIONDIMENSION,
    CONSOLIDATIONLEDGER,
    CONSOLIDATIONUNIT,
    CONSOLIDATIONUNITLOCALCURRENCY,
    CONSOLIDATIONUNITMDMTEXT,
    CONSOLIDATIONUNITTEXT,
    CONSOLIDATIONVERSION,
    COUNTRY,
    DOCUMENTENTRYISINGROUPCURRENCY,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    LANGUAGE,
    TAXRATE,
    PRIMARY KEY (CNSLDTNMDUPLDRECDUUID)
);

Learn More