P_ACMAssignDistr

DDL: P_ACMASSIGNDISTR Type: view_entity BASIC
3 Fields 1 Data Sources

ACM Assignment Distribution Private

P_ACMAssignDistr is a Basic CDS View that provides data about "ACM Assignment Distribution Private" in SAP S/4HANA. It reads from 1 data source (wb2_d_asgt_dist) and exposes 3 fields with key fields ContractItemAssignmentUUID, ACMPricingAspect, ACMPricingAspectvalue.

Data Sources (1)

SourceAliasJoin Type
wb2_d_asgt_dist AssignDistr from

Annotations (4)

NameValueLevelField
EndUserText.label ACM Assignment Distribution Private view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ContractItemAssignmentUUID a_guid Assignment GUID
KEY ACMPricingAspect pr_aspect Pricing Aspect
KEY ACMPricingAspectvalue pr_count Aspect Counter

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 P_ACMAssignDistr.
-- 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 P_ACMAssignDistr AS
SELECT
  a_guid AS ContractItemAssignmentUUID,
  pr_aspect AS ACMPricingAspect,
  pr_count AS ACMPricingAspectvalue
FROM wb2_d_asgt_dist AS AssignDistr
;

Learn More