/DCO/I_ACCOUNTINGDOCUMENT
Accounting Document
/DCO/I_ACCOUNTINGDOCUMENT is a CDS View in S/4HANA. Accounting Document. It contains 46 fields. 12 CDS views read from this table.
CDS Views using this table (12)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /DCO/C_AcctgDocArrearsDays | view_entity | from | CONSUMPTION | Days in Arrears |
| /DCO/I_AccountingDocumentVH | view_entity | from | COMPOSITE | Accounting Document |
| /DCO/I_AcctAccountingDocument | view_entity | inner | COMPOSITE | Account Accounting Document |
| /DCO/I_AcctgDocRelatedDispute | view_entity | inner | COMPOSITE | Accounting Document Related Dispute |
| /DCO/I_AcctgDocRelatedPrms2P | view_entity | inner | COMPOSITE | Accounting Doc Promise to Pay |
| /DCO/I_AcctgDocRelatedTask | view_entity | inner | COMPOSITE | Related Tasks |
| /DCO/I_AcctgDocReltdCreditItem | view_entity | from | BASIC | Accounting Document Related Credit Item |
| /DCO/I_AcctgDocumentHierarchy | view_entity | from | COMPOSITE | Accounting Document Hierarchy |
| /DCO/I_DsputBizPrtnAcctgDoc | view_entity | inner | COMPOSITE | Business Partner Accounting Documents |
| /DCO/P_DsputAcctgDocHier | view_entity | inner | COMPOSITE | Disputed Acctg Doc Hierarchy |
| /DCO/P_DsputAcctgDocHierDrft | view_entity | inner | COMPOSITE | Disputed Acctg Doc Hierarchy |
| /DCO/R_AccountingDocumentTP | view_entity | from | TRANSACTIONAL | Accounting Document - TP |
Fields (46)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DCoAccountingDocumentUUID | DCoAccountingDocumentUUID | 7 |
| _AccountingDocumentCurrency | _AccountingDocumentCurrency | 1 | |
| _BranchAccount | _BranchAccount | 1 | |
| _BusinessPartner | _BusinessPartner | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| BusinessPartner | BusinessPartner | 2 | |
| CompanyCode | CompanyCode | 2 | |
| DCoAccountingDocumentBranch | DCoAccountingDocumentBranch | 2 | |
| DCoAccountingDocumentCurrency | DCoAccountingDocumentCurrency | 2 | |
| DCoAccountingDocumentDate | DCoAccountingDocumentDate | 2 | |
| DCoAccountingDocumentDueDate | DCoAccountingDocumentDueDate | 2 | |
| DCoAccountingDocumentID | DCoAccountingDocumentID | 2 | |
| DCoAccountingDocumentIsCleared | DCoAccountingDocumentIsCleared | 2 | |
| DCoAccountingDocumentNoteText | DCoAccountingDocumentNoteText | 2 | |
| DCoAccountingDocumentOrigin | DCoAccountingDocumentOrigin | 2 | |
| DCoAcctgDocCreationDateTime | DCoAcctgDocCreationDateTime | 1 | |
| DCoAcctgDocCshDiscUsedAmount | DCoAcctgDocCshDiscUsedAmount | 1 | |
| DCoAcctgDocHierarchyLevelValue | DCoAcctgDocHierarchyLevelValue | 2 | |
| DCoAcctgDocIsBlockedForPayment | DCoAcctgDocIsBlockedForPayment | 2 | |
| DCoAcctgDocLastChangeDateTime | DCoAcctgDocLastChangeDateTime | 1 | |
| DCoAcctgDocLastChangedByUser | DCoAcctgDocLastChangedByUser | 1 | |
| DCoAcctgDocLastPaymentDate | DCoAcctgDocLastPaymentDate | 2 | |
| DCoAcctgDocOriginalDueDate | DCoAcctgDocOriginalDueDate | 2 | |
| DCoAcctgDocumentCreationUser | DCoAcctgDocumentCreationUser | 1 | |
| DCoAcctgDocumentCreditedAmount | DCoAcctgDocumentCreditedAmount | 2 | |
| DCoAcctgDocumentIsReversed | DCoAcctgDocumentIsReversed | 1 | |
| DCoAcctgDocumentLogicalSystem | DCoAcctgDocumentLogicalSystem | 2 | |
| DCoAcctgDocumentOpenAmount | DCoAcctgDocumentOpenAmount | 2 | |
| DCoAcctgDocumentOriginalAmount | DCoAcctgDocumentOriginalAmount | 2 | |
| DCoAcctgDocumentPaidAmount | DCoAcctgDocumentPaidAmount | 2 | |
| DCoAcctgDocumentReference1ID | DCoAcctgDocumentReference1ID | 2 | |
| DCoAcctgDocumentReference2ID | DCoAcctgDocumentReference2ID | 2 | |
| DCoAcctgDocumentReference3ID | DCoAcctgDocumentReference3ID | 1 | |
| DCoAcctgDocWriteOffAmount | DCoAcctgDocWriteOffAmount | 2 | |
| DCoAltvDocumentReference | DCoAltvDocumentReference | 1 | |
| DCoDocumentReference | DCoDocumentReference | 2 | |
| DCoOriginalReferenceDocument | DCoOriginalReferenceDocument | 2 | |
| DCoOriglAccountingDocumentUUID | DCoOriglAccountingDocumentUUID | 2 | |
| DCoOriglRefDocLogicalSystem | DCoOriglRefDocLogicalSystem | 2 | |
| DCoOriglReferenceDocumentType | DCoOriglReferenceDocumentType | 2 | |
| DCoPaymentIsArranged | DCoPaymentIsArranged | 1 | |
| DCoPrdcssrAcctgDocumentUUID | DCoPrdcssrAcctgDocumentUUID | 2 | |
| DCoRefAccountingDocumentUUID | DCoRefAccountingDocumentUUID | 1 | |
| PaymentDifferenceReason | PaymentDifferenceReason | 1 | |
| PostingClassification | PostingClassification | 1 | |
| PostingSubclassification | PostingSubclassification | 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.
-- Accounting Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /DCO/I_ACCOUNTINGDOCUMENT (
DCOACCOUNTINGDOCUMENTUUID,
_ACCOUNTINGDOCUMENTCURRENCY,
_BRANCHACCOUNT,
_BUSINESSPARTNER,
_COMPANYCODE,
BUSINESSPARTNER,
COMPANYCODE,
DCOACCOUNTINGDOCUMENTBRANCH,
DCOACCOUNTINGDOCUMENTCURRENCY,
DCOACCOUNTINGDOCUMENTDATE,
DCOACCOUNTINGDOCUMENTDUEDATE,
DCOACCOUNTINGDOCUMENTID,
DCOACCOUNTINGDOCUMENTISCLEARED,
DCOACCOUNTINGDOCUMENTNOTETEXT,
DCOACCOUNTINGDOCUMENTORIGIN,
DCOACCTGDOCCREATIONDATETIME,
DCOACCTGDOCCSHDISCUSEDAMOUNT,
DCOACCTGDOCHIERARCHYLEVELVALUE,
DCOACCTGDOCISBLOCKEDFORPAYMENT,
DCOACCTGDOCLASTCHANGEDATETIME,
DCOACCTGDOCLASTCHANGEDBYUSER,
DCOACCTGDOCLASTPAYMENTDATE,
DCOACCTGDOCORIGINALDUEDATE,
DCOACCTGDOCUMENTCREATIONUSER,
DCOACCTGDOCUMENTCREDITEDAMOUNT,
DCOACCTGDOCUMENTISREVERSED,
DCOACCTGDOCUMENTLOGICALSYSTEM,
DCOACCTGDOCUMENTOPENAMOUNT,
DCOACCTGDOCUMENTORIGINALAMOUNT,
DCOACCTGDOCUMENTPAIDAMOUNT,
DCOACCTGDOCUMENTREFERENCE1ID,
DCOACCTGDOCUMENTREFERENCE2ID,
DCOACCTGDOCUMENTREFERENCE3ID,
DCOACCTGDOCWRITEOFFAMOUNT,
DCOALTVDOCUMENTREFERENCE,
DCODOCUMENTREFERENCE,
DCOORIGINALREFERENCEDOCUMENT,
DCOORIGLACCOUNTINGDOCUMENTUUID,
DCOORIGLREFDOCLOGICALSYSTEM,
DCOORIGLREFERENCEDOCUMENTTYPE,
DCOPAYMENTISARRANGED,
DCOPRDCSSRACCTGDOCUMENTUUID,
DCOREFACCOUNTINGDOCUMENTUUID,
PAYMENTDIFFERENCEREASON,
POSTINGCLASSIFICATION,
POSTINGSUBCLASSIFICATION,
PRIMARY KEY (DCOACCOUNTINGDOCUMENTUUID)
);
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