APS_COM_CS_D2_PARTNER_TP

DDL: APS_COM_CS_D2_PARTNER_TP SQL: APS_COM_CS_P_T_2 Type: view Package: SR_APS_COM_CS
8 Fields 1 Data Sources 1 Associations

CS Draft 2.0 Business Partner TP View

APS_COM_CS_D2_PARTNER_TP is a CDS View that provides data about "CS Draft 2.0 Business Partner TP View" in SAP S/4HANA. It reads from 1 data source (APS_COM_CS_D2_PARTNER) and exposes 8 fields with key field db_key. It has 1 association to related views. Part of development package SR_APS_COM_CS.

Data Sources (1)

SourceAliasJoin Type
APS_COM_CS_D2_PARTNER Document from

Associations (1)

CardinalityTargetAliasCondition
[1..1] Aps_Com_Cs_D2_Root_Tp _Root _Root.db_key = $projection.parent_key

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName APS_COM_CS_P_T_2 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeActivePersistence APS_CS_D_BP view
ObjectModel.writeDraftPersistence APS_CS_D_BP_D2 view
ObjectModel.semanticKey BusinessPartnerUUID view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
EndUserText.label CS Draft 2.0 Business Partner TP View view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY db_key db_key UUID
parent_key parent_key UUID
BusinessPartnerUUID BusinessPartnerUUID UUID
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_Root _Root

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 APS_COM_CS_D2_PARTNER_TP.
-- 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.
-- SQL view name: APS_COM_CS_P_T_2

CREATE VIEW APS_COM_CS_D2_PARTNER_TP AS
SELECT
  db_key,
  parent_key,
  BusinessPartnerUUID,
  CreatedByUser,
  CreationDateTime,
  LastChangeDateTime,
  LastChangedByUser
FROM APS_COM_CS_D2_PARTNER AS Document
LEFT OUTER JOIN Aps_Com_Cs_D2_Root_Tp AS _Root ON _Root.db_key = parent_key  -- association [1..1]
;

Learn More