_CNSLDTNUNITBYTIMEVERSION

_CNSLDTNUNITBYTIMEVERSION is an SAP database table in S/4HANA. It contains 18 fields.

Fields (18)

KeyField CDS FieldsUsed in Views
KEY ConsolidationUnit ConsolidationUnit 1
KEY ConsolidationVersion ConsolidationVersion 1
KEY FromFiscalYearPeriod FromFiscalYearPeriod 1
CnsldtnCrcyTranslationMethod CnsldtnCrcyTranslationMethod 1
CnsldtnDataTransferMethod CnsldtnDataTransferMethod 1
CnsldtnUnitDataCollection CnsldtnUnitDataCollection 1
CnsldtnUnitGroupCrcySource CnsldtnUnitGroupCrcySource 1
CnsldtnUnitLocalCrcySource CnsldtnUnitLocalCrcySource 1
CnsldtnUploadMethod CnsldtnUploadMethod 1
ConsolidationUnitIsPartnerOnly ConsolidationUnitIsPartnerOnly 1
ConsolidationUnitPartner ConsolidationUnitPartner 1
ConsolidationUnitPostingRule ConsolidationUnitPostingRule 1
ConsolidationUnitValidation ConsolidationUnitValidation 1
DocumentEntryIsInGroupCurrency DocumentEntryIsInGroupCurrency 1
ETag ETag 1
FiscalYearVariant FiscalYearVariant 1
TaxRate TaxRate 1
ToFiscalYearPeriod ToFiscalYearPeriod 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _CNSLDTNUNITBYTIMEVERSION (
    CONSOLIDATIONUNIT,
    CONSOLIDATIONVERSION,
    FROMFISCALYEARPERIOD,
    CNSLDTNCRCYTRANSLATIONMETHOD,
    CNSLDTNDATATRANSFERMETHOD,
    CNSLDTNUNITDATACOLLECTION,
    CNSLDTNUNITGROUPCRCYSOURCE,
    CNSLDTNUNITLOCALCRCYSOURCE,
    CNSLDTNUPLOADMETHOD,
    CONSOLIDATIONUNITISPARTNERONLY,
    CONSOLIDATIONUNITPARTNER,
    CONSOLIDATIONUNITPOSTINGRULE,
    CONSOLIDATIONUNITVALIDATION,
    DOCUMENTENTRYISINGROUPCURRENCY,
    ETAG,
    FISCALYEARVARIANT,
    TAXRATE,
    TOFISCALYEARPERIOD,
    PRIMARY KEY (CONSOLIDATIONUNIT, CONSOLIDATIONVERSION, FROMFISCALYEARPERIOD)
);