/DCO/I_ACCOUNTINGDOCUMENT

CDS View

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)

ViewTypeJoinVDMDescription
/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)

KeyField CDS FieldsUsed 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)
);