I_CO_DIANGENERALLEDGERACCOUNT
DIAN General Ledger Account
I_CO_DIANGENERALLEDGERACCOUNT is a CDS View in S/4HANA. DIAN General Ledger Account. It contains 7 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_CO_DIANGeneralLedgerAccount | view | from | CONSUMPTION | |
| P_CO_DIANJrnlEntrInvcFinDocLog | view | inner | CONSUMPTION | |
| P_CO_DIANJrnlEntrWthInvcFinDoc | view | inner | CONSUMPTION | |
| P_CO_DIANStRpSuplrCustOplVw | view | inner | CONSUMPTION | |
| P_CO_DIANStRpSuplrCustOpnItmLg | view | inner | CONSUMPTION |
Fields (7)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CO_DIANReportFormat | CO_DIANReportFormat | 5 |
| KEY | CO_DIANReportItemType | CO_DIANReportItemType | 5 |
| KEY | LowerBoundaryAccount | LowerBoundaryAccount | 1 |
| KEY | ValidityStartDate | ValidityStartDate | 1 |
| CO_DIANAmountClassification | CO_DIANAmountClassification | 2 | |
| UpperBoundaryAccount | UpperBoundaryAccount | 1 | |
| ValidityEndDate | ValidityEndDate | 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.
-- DIAN General Ledger Account
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CO_DIANGENERALLEDGERACCOUNT (
CO_DIANREPORTFORMAT,
CO_DIANREPORTITEMTYPE,
LOWERBOUNDARYACCOUNT,
VALIDITYSTARTDATE,
CO_DIANAMOUNTCLASSIFICATION,
UPPERBOUNDARYACCOUNT,
VALIDITYENDDATE,
PRIMARY KEY (CO_DIANREPORTFORMAT, CO_DIANREPORTITEMTYPE, LOWERBOUNDARYACCOUNT, VALIDITYSTARTDATE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA