I_CntrlPurContrAggrgnDistrSts

DDL: I_CNTRLPURCONTRAGGRGNDISTRSTS SQL: ICCTRAGDISTSTS Type: view BASIC Package: VDM_MM_PUR_CCTR
3 Fields 2 Data Sources 2 Associations

Agg. Distr Status of Cntrl Pur Contr

I_CntrlPurContrAggrgnDistrSts is a Basic CDS View that provides data about "Agg. Distr Status of Cntrl Pur Contr" in SAP S/4HANA. It reads from 2 data sources (I_CntrlPurContrOvrlDistrSts, R_CentralPurchaseContract) and exposes 3 fields with key field CentralPurchaseContract. It has 2 associations to related views. Part of development package VDM_MM_PUR_CCTR.

Data Sources (2)

SourceAliasJoin Type
I_CntrlPurContrOvrlDistrSts _OverallDistributionStatus inner
R_CentralPurchaseContract cctr from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CntrlPurContrDistrStatusText _CntrlPurContrDistrStatusText $projection.CntrlPurContrDistributionSts = _CntrlPurContrDistrStatusText.ItemDistributionStatus
[1..1] I_CentralPurchaseContract _CentralPurchaseContract _CentralPurchaseContract.CentralPurchaseContract = $projection.CentralPurchaseContract

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICCTRAGDISTSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Agg. Distr Status of Cntrl Pur Contr view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract R_CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
_CntrlPurContrDistrStatusText _CntrlPurContrDistrStatusText
_CentralPurchaseContract _CentralPurchaseContract

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 I_CntrlPurContrAggrgnDistrSts.
-- 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: ICCTRAGDISTSTS

CREATE VIEW I_CntrlPurContrAggrgnDistrSts AS
SELECT
  cctr.CentralPurchaseContract AS CentralPurchaseContract
FROM R_CentralPurchaseContract AS cctr
INNER JOIN I_CntrlPurContrOvrlDistrSts AS _OverallDistributionStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CntrlPurContrDistrStatusText AS _CntrlPurContrDistrStatusText ON CntrlPurContrDistributionSts = _CntrlPurContrDistrStatusText.ItemDistributionStatus  -- association [0..1]
LEFT OUTER JOIN I_CentralPurchaseContract AS _CentralPurchaseContract ON _CentralPurchaseContract.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
;

Learn More