/DCO/C_AccountPromiseToPayTP

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

Account Promise To Pay - TP

/DCO/C_AccountPromiseToPayTP is a Consumption CDS View that provides data about "Account Promise To Pay - TP" in SAP S/4HANA. It reads from 1 data source (/DCO/R_AccountPromiseToPayTP) and exposes 54 fields with key fields DCoBusinessPartnerUUID, DCoAccountUUID, DCoPromiseToPayUUID. 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_AccountPromiseToPayTP /DCO/R_AccountPromiseToPayTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Account Promise To Pay - TP view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey DCoPromiseToPayUUID 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 (54)

KeyFieldSource TableSource FieldDescription
KEY DCoBusinessPartnerUUID DCoBusinessPartnerUUID
KEY DCoAccountUUID DCoAccountUUID
KEY DCoPromiseToPayUUID DCoPromiseToPayUUID
DebtCollectionsSegment DebtCollectionsSegment
DCoBusinessPartnerBranch DCoBusinessPartnerBranch
BusinessPartner BusinessPartner Issuing Authority
DebtCollectionsPromiseToPay DebtCollectionsPromiseToPay
DebtCollectionsCompanyCode DebtCollectionsCompanyCode
DCoPromiseToPayDueDate DCoPromiseToPayDueDate
DCoPromiseToPayAmount DCoPromiseToPayAmount
DCoPrms2PDistrdPromisedAmount DCoPrms2PDistrdPromisedAmount
DCoPrmsToPayUsedCreditAmount DCoPrmsToPayUsedCreditAmount
DCoPrms2PInsmPlnNrOfInstlmnts DCoPrms2PInsmPlnNrOfInstlmnts
DCoPromiseToPayCurrency DCoPromiseToPayCurrency
DCoPrms2PMainCustContactPerson DCoPrms2PMainCustContactPerson
DCoPromiseToPayStatus DCoPromiseToPayStatus
DCoPromiseToPayPromisedBy DCoPromiseToPayPromisedBy
DCoActivityIsCreated DCoActivityIsCreated
DCoPromiseToPayIsMigrated DCoPromiseToPayIsMigrated
DCoPredecessorPromiseToPay DCoPredecessorPromiseToPay
DCoDebtCollectionsActivity DCoDebtCollectionsActivity
DCoPromiseToPayCreatedByUser DCoPromiseToPayCreatedByUser
DCoPrmsToPayCreationDateTime DCoPrmsToPayCreationDateTime
DCoPrmsToPayLastChangedByUser DCoPrmsToPayLastChangedByUser
DCoPrmsToPayLastChangeDateTime DCoPrmsToPayLastChangeDateTime
DCoPromiseToPayClosedByUser DCoPromiseToPayClosedByUser
DCoPromiseToPayClosingDateTime DCoPromiseToPayClosingDateTime
DCoPromiseToPayCriticality DCoPromiseToPayCriticality
BusinessPartnerName _BusinessPartner BusinessPartnerName Extracted Customer Name
DCoPrms2PCustCntctPersnName _ContactPerson BusinessPartnerName Extracted Customer Name
DCoPromiseToPayPromisedByName _PromisedBy BusinessPartnerName Extracted Customer Name
DCoPrmsToPayCreatedByUserName _CreationUser UserDescription Full Name
DCoPrms2PLastChangedByUserName _LastChangedByUser UserDescription Full Name
DCoPrmsToPayClosedByUserName _ClosedByUser UserDescription Full Name
virtualUICT_ContactPersonNVIabap_boolean
virtualUICT_PromisedByNVIabap_boolean
virtualUICT_CreatedByNVIabap_boolean
virtualUICT_LastChangedByNVIabap_boolean
virtualUICT_ClosedByNVIabap_boolean
_Account _Account
_PromiseToPay _PromiseToPay
_BusinessPartner _BusinessPartner
_CompanyCode _CompanyCode
_Currency _Currency
_PromiseToPayStatus _PromiseToPayStatus
_BusinessPartnerCustomer _BusinessPartnerCustomer
_ContactPersonQuickView _ContactPersonQuickView
_BusinessPartnerQuickView _BusinessPartnerQuickView
_CreationUserContactCard _CreationUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard
_ClosedByUserContactCard _ClosedByUserContactCard
_PromisedByQuickView _PromisedByQuickView
_Prms2PAcctgDocSumAmount _Prms2PAcctgDocSumAmount
_ActivityQuickView _ActivityQuickView

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_AccountPromiseToPayTP.
-- 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_AccountPromiseToPayTP AS
SELECT
  DCoBusinessPartnerUUID,
  DCoAccountUUID,
  DCoPromiseToPayUUID,
  DebtCollectionsSegment,
  DCoBusinessPartnerBranch,
  BusinessPartner,
  DebtCollectionsPromiseToPay,
  DebtCollectionsCompanyCode,
  DCoPromiseToPayDueDate,
  DCoPromiseToPayAmount,
  DCoPrms2PDistrdPromisedAmount,
  DCoPrmsToPayUsedCreditAmount,
  DCoPrms2PInsmPlnNrOfInstlmnts,
  DCoPromiseToPayCurrency,
  DCoPrms2PMainCustContactPerson,
  DCoPromiseToPayStatus,
  DCoPromiseToPayPromisedBy,
  DCoActivityIsCreated,
  DCoPromiseToPayIsMigrated,
  DCoPredecessorPromiseToPay,
  DCoDebtCollectionsActivity,
  DCoPromiseToPayCreatedByUser,
  DCoPrmsToPayCreationDateTime,
  DCoPrmsToPayLastChangedByUser,
  DCoPrmsToPayLastChangeDateTime,
  DCoPromiseToPayClosedByUser,
  DCoPromiseToPayClosingDateTime,
  DCoPromiseToPayCriticality,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _ContactPerson.BusinessPartnerName AS DCoPrms2PCustCntctPersnName,
  _PromisedBy.BusinessPartnerName AS DCoPromiseToPayPromisedByName,
  _CreationUser.UserDescription AS DCoPrmsToPayCreatedByUserName,
  _LastChangedByUser.UserDescription AS DCoPrms2PLastChangedByUserName,
  _ClosedByUser.UserDescription AS DCoPrmsToPayClosedByUserName,
  virtual UICT_ContactPersonNVI : abap_boolean AS virtualUICT_ContactPersonNVIabap_boolean,
  virtual UICT_PromisedByNVI : abap_boolean AS virtualUICT_PromisedByNVIabap_boolean,
  virtual UICT_CreatedByNVI : abap_boolean AS virtualUICT_CreatedByNVIabap_boolean,
  virtual UICT_LastChangedByNVI : abap_boolean AS virtualUICT_LastChangedByNVIabap_boolean,
  virtual UICT_ClosedByNVI : abap_boolean AS virtualUICT_ClosedByNVIabap_boolean
FROM /DCO/R_AccountPromiseToPayTP
;

Learn More