/DCO/C_AcctAcctgDocumentTP

DDL: /DCO/C_ACCTACCTGDOCUMENTTP Type: view_entity CONSUMPTION Package: /DCO/ODATA_COLL_ACCOUNT
65 Fields 1 Data Sources 2 OData Services

Account Accounting Document - TP

/DCO/C_AcctAcctgDocumentTP is a Consumption CDS View that provides data about "Account Accounting Document - TP" in SAP S/4HANA. It reads from 1 data source (/DCO/R_AcctAcctgDocumentTP) and exposes 65 fields with key fields DCoBusinessPartnerUUID, DCoAccountUUID, DCoAccountingDocumentUUID. It is exposed through 2 OData services (/DCO/UI_ACCOUNT_PROCESS, ASQL_F8607). Part of development package /DCO/ODATA_COLL_ACCOUNT.

Data Sources (1)

SourceAliasJoin Type
/DCO/R_AcctAcctgDocumentTP /DCO/R_AcctAcctgDocumentTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Account Accounting Document - TP view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey DCoAccountingDocumentUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
/DCO/UI_ACCOUNT_PROCESS /DCO/UI_ACCOUNT_PROCESS V4 C1 NOT_RELEASED
ASQL_F8607 ASQL_F8607 C2 NOT_RELEASED

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY DCoBusinessPartnerUUID DCoBusinessPartnerUUID
KEY DCoAccountUUID DCoAccountUUID
KEY DCoAccountingDocumentUUID DCoAccountingDocumentUUID
DebtCollectionsSegment DebtCollectionsSegment
DebtCollectionsCompanyCode DebtCollectionsCompanyCode
BusinessPartner BusinessPartner Issuing Authority
CompanyCode CompanyCode Receiver Company Code
DCoAccountingDocumentOrigin DCoAccountingDocumentOrigin
DCoAccountingDocumentID DCoAccountingDocumentID
PostingClassification _RblPyblTransactionItem PostingClassification
PostingSubclassification _RblPyblTransactionItem PostingSubclassification
RblPyblDocumentRelationType _RblPyblTransactionItem RblPyblDocumentRelationType
PaymentDifferenceReason _RblPyblTransactionItem PaymentDifferenceReason Reason Code
DCoAccountingDocumentDate DCoAccountingDocumentDate
DCoAcctgDocOriginalDueDate DCoAcctgDocOriginalDueDate
DCoAccountingDocumentDueDate DCoAccountingDocumentDueDate
DCoAcctgDocLastPaymentDate DCoAcctgDocLastPaymentDate
DCoAccountingDocumentCurrency DCoAccountingDocumentCurrency
DCoAcctgDocumentOriginalAmount DCoAcctgDocumentOriginalAmount
DCoAcctgDocumentOpenAmount DCoAcctgDocumentOpenAmount
DCoAcctgDocumentPaidAmount DCoAcctgDocumentPaidAmount
DCoAcctgDocumentCreditedAmount DCoAcctgDocumentCreditedAmount
DCoAcctgDocWriteOffAmount DCoAcctgDocWriteOffAmount
DCoAcctgDocCshDiscUsedAmount DCoAcctgDocCshDiscUsedAmount
DCoAccountingDocumentBranch DCoAccountingDocumentBranch
DCoDocumentReference DCoDocumentReference
DCoAltvDocumentReference DCoAltvDocumentReference
DCoAcctgDocumentReference1ID DCoAcctgDocumentReference1ID
DCoAcctgDocumentReference2ID DCoAcctgDocumentReference2ID
DCoAcctgDocumentReference3ID DCoAcctgDocumentReference3ID
DCoAcctgDocIsBlockedForPayment DCoAcctgDocIsBlockedForPayment
DCoAccountingDocumentNoteText DCoAccountingDocumentNoteText
DCoAccountingDocumentIsCleared DCoAccountingDocumentIsCleared
DCoOriglAccountingDocumentUUID DCoOriglAccountingDocumentUUID
DCoRefAccountingDocumentUUID DCoRefAccountingDocumentUUID
DCoPrdcssrAcctgDocumentUUID DCoPrdcssrAcctgDocumentUUID
DCoPrdcssrAccountingDocumentID _PredecessorAccountingDocument DCoAccountingDocumentID
DCoOriglAccountingDocumentID _OriginalAccountingDocument DCoAccountingDocumentID
DCoRefAccountingDocumentID _ReferenceAccountingDocument DCoAccountingDocumentID
DCoAcctgDocumentLogicalSystem DCoAcctgDocumentLogicalSystem
DCoPaymentIsArranged DCoPaymentIsArranged
DCoAcctgDocumentIsReversed DCoAcctgDocumentIsReversed
DCoOriginalReferenceDocument DCoOriginalReferenceDocument
DCoOriglReferenceDocumentType DCoOriglReferenceDocumentType
DCoOriglRefDocLogicalSystem DCoOriglRefDocLogicalSystem
AssignmentReference _RblPyblTransactionItem AssignmentReference Assignment Reference
DCoDisputedSumAmount DCoDisputedSumAmount
DCoPromiseToPaySumAmount DCoPromiseToPaySumAmount
DCoDaysInArrearsValue DCoDaysInArrearsValue
RblPyblItemIsBlockedForDunning RblPyblItemIsBlockedForDunning
BusinessPartnerName _BusinessPartner BusinessPartnerName Extracted Customer Name
DCoAcctgDocumentBranchName _BranchAccount BusinessPartnerFullName Broker Name
_Account _Account
_AccountingDocument _AccountingDocument
_BusinessPartnerQuickView _BusinessPartnerQuickView
_BranchAccountQuickView _BranchAccountQuickView
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartnerBranchCustomer _BusinessPartnerBranchCustomer
_InvoiceQuickView _InvoiceQuickView
_AcctgDocQuickView _AcctgDocQuickView
_AcctgDocArrearsDays _AcctgDocArrearsDays
_AccountingDocumentHierarchy _AccountingDocumentHierarchy
_AcctgDocRelatedDispute _AcctgDocRelatedDispute
_AcctgDocRelatedPrms2P _AcctgDocRelatedPrms2P
_AcctgDocRelatedTask _AcctgDocRelatedTask

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view /DCO/C_AcctAcctgDocumentTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW /DCO/C_AcctAcctgDocumentTP AS
SELECT
  DCoBusinessPartnerUUID,
  DCoAccountUUID,
  DCoAccountingDocumentUUID,
  DebtCollectionsSegment,
  DebtCollectionsCompanyCode,
  BusinessPartner,
  CompanyCode,
  DCoAccountingDocumentOrigin,
  DCoAccountingDocumentID,
  _RblPyblTransactionItem.PostingClassification AS PostingClassification,
  _RblPyblTransactionItem.PostingSubclassification AS PostingSubclassification,
  _RblPyblTransactionItem.RblPyblDocumentRelationType AS RblPyblDocumentRelationType,
  _RblPyblTransactionItem.PaymentDifferenceReason AS PaymentDifferenceReason,
  DCoAccountingDocumentDate,
  DCoAcctgDocOriginalDueDate,
  DCoAccountingDocumentDueDate,
  DCoAcctgDocLastPaymentDate,
  DCoAccountingDocumentCurrency,
  DCoAcctgDocumentOriginalAmount,
  DCoAcctgDocumentOpenAmount,
  DCoAcctgDocumentPaidAmount,
  DCoAcctgDocumentCreditedAmount,
  DCoAcctgDocWriteOffAmount,
  DCoAcctgDocCshDiscUsedAmount,
  DCoAccountingDocumentBranch,
  DCoDocumentReference,
  DCoAltvDocumentReference,
  DCoAcctgDocumentReference1ID,
  DCoAcctgDocumentReference2ID,
  DCoAcctgDocumentReference3ID,
  DCoAcctgDocIsBlockedForPayment,
  DCoAccountingDocumentNoteText,
  DCoAccountingDocumentIsCleared,
  DCoOriglAccountingDocumentUUID,
  DCoRefAccountingDocumentUUID,
  DCoPrdcssrAcctgDocumentUUID,
  _PredecessorAccountingDocument.DCoAccountingDocumentID AS DCoPrdcssrAccountingDocumentID,
  _OriginalAccountingDocument.DCoAccountingDocumentID AS DCoOriglAccountingDocumentID,
  _ReferenceAccountingDocument.DCoAccountingDocumentID AS DCoRefAccountingDocumentID,
  DCoAcctgDocumentLogicalSystem,
  DCoPaymentIsArranged,
  DCoAcctgDocumentIsReversed,
  DCoOriginalReferenceDocument,
  DCoOriglReferenceDocumentType,
  DCoOriglRefDocLogicalSystem,
  _RblPyblTransactionItem.AssignmentReference AS AssignmentReference,
  DCoDisputedSumAmount,
  DCoPromiseToPaySumAmount,
  DCoDaysInArrearsValue,
  RblPyblItemIsBlockedForDunning,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _BranchAccount.BusinessPartnerFullName AS DCoAcctgDocumentBranchName
FROM /DCO/R_AcctAcctgDocumentTP
;

Learn More