I_CN_CADEGENERALINFORMATION

CDS View
6 Fields 13 CDS Views

General Master Information for CADE

I_CN_CADEGENERALINFORMATION is a CDS View in S/4HANA. General Master Information for CADE. It contains 6 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_CN_CADEDepreciationKeyInfo view from CONSUMPTION Depreciation Key with Formula
I_CN_CADEFixedAssetValueCube view left_outer COMPOSITE Fixed Asset Balance Cube for CADE
I_CN_CADEReportSetWithPeriod view from COMPOSITE CADE - Report Set for Fiscal Period
P_CN_CADEAccountNumberingRule3 view from CONSUMPTION
P_CN_CADEAcctBalanceStructure view inner COMPOSITE
P_CN_CADEAssetAllChgDocWthPrd view inner COMPOSITE
P_CN_CADEAssetChangeLog view inner CONSUMPTION
P_CN_CADEAssetChgDoc view left_outer COMPOSITE
P_CN_CADEAssetRetirement view inner CONSUMPTION
P_CN_CADECalcExpiredPeriods view inner COMPOSITE
P_CN_CADECashFlowZeroBal view inner COMPOSITE
P_CN_CADECompanyCode view left_outer BASIC
P_CN_CADEFsclPerdForCmpnyCode view inner CONSUMPTION

Fields (6)

KeyField CDS FieldsUsed in Views
KEY CN_CADENatlStdRelVersion CN_CADENatlStdRelVersion 3
KEY CompanyCode CompanyCode 2
KEY Ledger Ledger 1
CN_CADEReportingEntity CN_CADEReportingEntity 1
CN_CADEReportStatus CN_CADEReportStatus 1
Currency Currency 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.

-- General Master Information for CADE
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CN_CADEGENERALINFORMATION (
    CN_CADENATLSTDRELVERSION,
    COMPANYCODE,
    LEDGER,
    CN_CADEREPORTINGENTITY,
    CN_CADEREPORTSTATUS,
    CURRENCY,
    PRIMARY KEY (CN_CADENATLSTDRELVERSION, COMPANYCODE, LEDGER)
);

Learn More