/DCO/C_AccountActivityTP

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

Account Activity - TP

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

Annotations (9)

NameValueLevelField
EndUserText.label Account Activity - TP view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey DCoActivityUUID 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 (43)

KeyFieldSource TableSource FieldDescription
KEY DCoBusinessPartnerUUID DCoBusinessPartnerUUID
KEY DCoAccountUUID DCoAccountUUID
KEY DCoActivityUUID DCoActivityUUID
DCoDebtCollectionsActivity DCoDebtCollectionsActivity
BusinessPartner BusinessPartner Issuing Authority
DebtCollectionsSegment DebtCollectionsSegment
DCoActyMainCustContactPerson DCoActyMainCustContactPerson
DCoActivityDirection DCoActivityDirection
DCoActivityType DCoActivityType
DCoActivityResult DCoActivityResult
DCoActivityIsMigrated DCoActivityIsMigrated
DCoWorklistItemIsFinalized DCoWorklistItemIsFinalized
DCoActivityCreatedByUser DCoActivityCreatedByUser
DCoActivityCreationDateTime DCoActivityCreationDateTime
DCoActivityLastChangedByUser DCoActivityLastChangedByUser
DCoActivityLastChangeDateTime DCoActivityLastChangeDateTime
DCoActivityCriticality DCoActivityCriticality
BusinessPartnerName _BusinessPartner BusinessPartnerName Extracted Customer Name
DebtCollectionsSegmentNamelocalized
DCoActyMainCustCntctPersonName _MainCustomerContactPerson BusinessPartnerFullName Broker Name
DCoActivityDirectionNamelocalized
DCoActivityTypeNamelocalized
DCoActivityResultNamelocalized
DCoActivityCreatedByUserName _CreatedByUser UserDescription Full Name
DCoActyLastChangedByUserName _LastChangedBy UserDescription Full Name
_BusinessPartnerCustomer _BusinessPartnerCustomer
_CustomerContactPerson _CustomerContactPerson
_BusinessPartnerQuickView _BusinessPartnerQuickView
_SgmtDCoCoCodeAssignment _SgmtDCoCoCodeAssignment
_ContactPersonQuickView _ContactPersonQuickView
_CreationUserContactCard _CreationUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard
_Account _Account
_Activity _Activity
_ActivityDirection _ActivityDirection
_ActivityResult _ActivityResult
_ActivityType _ActivityType
_BusinessPartner _BusinessPartner
_CreatedByUser _CreatedByUser
_DCoBusinessPartner _DCoBusinessPartner
_DebtCollectionsSegment _DebtCollectionsSegment
_LastChangedBy _LastChangedBy
_MainCustomerContactPerson _MainCustomerContactPerson

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_AccountActivityTP.
-- 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_AccountActivityTP AS
SELECT
  DCoBusinessPartnerUUID,
  DCoAccountUUID,
  DCoActivityUUID,
  DCoDebtCollectionsActivity,
  BusinessPartner,
  DebtCollectionsSegment,
  DCoActyMainCustContactPerson,
  DCoActivityDirection,
  DCoActivityType,
  DCoActivityResult,
  DCoActivityIsMigrated,
  DCoWorklistItemIsFinalized,
  DCoActivityCreatedByUser,
  DCoActivityCreationDateTime,
  DCoActivityLastChangedByUser,
  DCoActivityLastChangeDateTime,
  DCoActivityCriticality,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _DebtCollectionsSegment._Text.DebtCollectionsSegmentName : localized AS DebtCollectionsSegmentNamelocalized,
  _MainCustomerContactPerson.BusinessPartnerFullName AS DCoActyMainCustCntctPersonName,
  _ActivityDirection._Text.DCoActivityDirectionName : localized AS DCoActivityDirectionNamelocalized,
  _ActivityType._Text.DCoActivityTypeName : localized AS DCoActivityTypeNamelocalized,
  _ActivityResult._Text.DCoActivityResultName : localized AS DCoActivityResultNamelocalized,
  _CreatedByUser.UserDescription AS DCoActivityCreatedByUserName,
  _LastChangedBy.UserDescription AS DCoActyLastChangedByUserName
FROM /DCO/R_AccountActivityTP
;

Learn More