/DCO/C_AccountTP

DDL: /DCO/C_ACCOUNTTP Type: view_entity CONSUMPTION Package: /DCO/ODATA_COLL_ACCOUNT

Collections Account - TP

/DCO/C_AccountTP is a Consumption CDS View that provides data about "Collections Account - TP" in SAP S/4HANA. It reads from 1 data source (/DCO/R_AccountTP) and exposes 32 fields with key fields DCoBusinessPartnerUUID, DCoAccountUUID. 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_AccountTP /DCO/R_AccountTP projection

Annotations (12)

NameValueLevelField
EndUserText.label Collections Account - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey DCoAccountUUID view
ObjectModel.sapObjectNodeType.name DebtCollectionsAccount view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
Metadata.allowExtensions true view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewCompositions 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 (32)

KeyFieldSource TableSource FieldDescription
KEY DCoBusinessPartnerUUID DCoBusinessPartnerUUID
KEY DCoAccountUUID DCoAccountUUID
BusinessPartner BusinessPartner Issuing Authority
DebtCollectionsSegment DebtCollectionsSegment
DCoAccountStickyNoteText _BusinessPartnerSegment DCoAccountStickyNoteText
DCoMainCustContactPerson _BusinessPartnerSegment DCoAcctMainCustContactPerson
DebtCollectionsLastActivity _LastActivity DebtCollectionsLastActivity
DCoPaymentBehaviorRating _BusinessPartnerSegment DCoPaymentBehaviorRating
LinkedSAPObjectKey LinkedSAPObjectKey SAP Object Key
SAPObjectNodeType SAPObjectNodeType SONT Name
BusinessPartnerName _BusinessPartner BusinessPartnerName Extracted Customer Name
DCoAcctMainCustCntctPersonName
_AccountDispute _AccountDispute
_AcctAccountingDocument _AcctAccountingDocument
_AccountPromiseToPay _AccountPromiseToPay
_AccountActivity _AccountActivity
_AccountTask _AccountTask
_AccountNote _AccountNote
_BusinessPartner _BusinessPartner
_BusinessPartnerSegment _BusinessPartnerSegment
_DCoBusinessPartner _DCoBusinessPartner
_DebtCollectionsSegment _DebtCollectionsSegment
_CustomerContactPerson _CustomerContactPerson
_ContactPersonQuickView _ContactPersonQuickView
_SgmtDCoCoCodeAssignment _SgmtDCoCoCodeAssignment
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartnerQuickView _BusinessPartnerQuickView
_AccountDueDateGrid _AccountDueDateGrid
_AccountPaymentTrend _AccountPaymentTrend
_ActivityQuickView _ActivityQuickView
_BusinessPartnerHierarchy _BusinessPartnerHierarchy
_CurrentWorklistItem _CurrentWorklistItem

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_AccountTP.
-- 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_AccountTP AS
SELECT
  DCoBusinessPartnerUUID,
  DCoAccountUUID,
  BusinessPartner,
  DebtCollectionsSegment,
  _BusinessPartnerSegment.DCoAccountStickyNoteText AS DCoAccountStickyNoteText,
  _BusinessPartnerSegment.DCoAcctMainCustContactPerson AS DCoMainCustContactPerson,
  _LastActivity.DebtCollectionsLastActivity AS DebtCollectionsLastActivity,
  _BusinessPartnerSegment.DCoPaymentBehaviorRating AS DCoPaymentBehaviorRating,
  LinkedSAPObjectKey,
  SAPObjectNodeType,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _BusinessPartnerSegment._MainCustomerContactPerson.BusinessPartnerName AS DCoAcctMainCustCntctPersonName
FROM /DCO/R_AccountTP
;