C_CntrlPurContrItmCmmdtyQtyTP

DDL: C_CNTRLPURCONTRITMCMMDTYQTYTP SQL: CCCTRICMDTQTYTP Type: view CONSUMPTION Package: ODATA_MM_PUR_CMDT_QUANTITY
22 Fields 1 Data Sources 6 Associations

C-View for Commodity Qty in CCTR

C_CntrlPurContrItmCmmdtyQtyTP is a Consumption CDS View that provides data about "C-View for Commodity Qty in CCTR" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurContrItmCmmdtyQtyTP) and exposes 22 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem, PurgDocCmmdtyQtySqntlNumber. It has 6 associations to related views. Part of development package ODATA_MM_PUR_CMDT_QUANTITY.

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurContrItmCmmdtyQtyTP I_CntrlPurContrItmCmmdtyQtyTP from

Associations (6)

CardinalityTargetAliasCondition
[1..1] C_CntrlPurchaseContractItemTP _CntrlPurchaseContractItemTP $projection.CentralPurchaseContract = _CntrlPurchaseContractItemTP.CentralPurchaseContract and $projection.CentralPurchaseContractItem = _CntrlPurchaseContractItemTP.CentralPurchaseContractItem
[1..1] C_CentralPurchaseContractTP _CentralPurchaseContractTP _CentralPurchaseContractTP.CentralPurchaseContract = $projection.CentralPurchaseContract
[0..1] I_PurgDocCmmdtyUpdateCycle _PurgDocCmmdtyUpdateCycle $projection.PurgDocCmmdtyUpdateCycle = _PurgDocCmmdtyUpdateCycle.PurgDocCmmdtyUpdateCycleDomain
[0..1] I_PurgDocCmmdtyUpdateCycleTxt _PurgDocCmmdtyUpdateCycleVH $projection.PurgDocCmmdtyUpdateCycle = _PurgDocCmmdtyUpdateCycleVH.PurgDocCmmdtyUpdateCycleDomain
[1..1] C_PurgDocCommodityCodesVH _PurgDocCommodityCodes $projection.PurgDocCmmdtyCode = _PurgDocCommodityCodes.PurgDocCmmdtyCode and _PurgDocCommodityCodes.Language = $session.system_language
[1..1] C_PurgDocCommodityVH _CommodityVH _CommodityVH.Commodity = $projection.Commodity and _CommodityVH.Language = $session.system_language

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CCCTRICMDTQTYTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.transactionalProcessingDelegated true view
EndUserText.label C-View for Commodity Qty in CCTR view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
KEY CentralPurchaseContractItem CentralPurchaseContractItem Item in Central Purchase Contract
KEY PurgDocCmmdtyQtySqntlNumber PurgDocCmmdtyQtySqntlNumber Commodity Sequential Number
PurgDocCmmdtyQtyValidToDate PurgDocCmmdtyQtyValidToDate Valid To
PurgDocCmmdtyQtyValidFromDate PurgDocCmmdtyQtyValidFromDate Valid From
PurgDocCmmdtyCode PurgDocCmmdtyCode Commodity
Commodity Commodity Commodity
PurgDocCmmdtyDesc _PurgDocCommodityCodes PurgDocCmmdtyDesc
CommodityName Commodity Description
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
CommodityQuantity CommodityQuantity Quantity
PurgDocCmmdtyUpdateCycleText _PurgDocCmmdtyUpdateCycleVH PurgDocCmmdtyUpdateCycleText
CommodityUnit CommodityUnit Order Unit
PurgDocCmmdtyRefDocItmQty PurgDocCmmdtyRefDocItmQty Item Quantity
ItemQuantityUnit ItemQuantityUnit Quantity Unit of Item
_CntrlPurchaseContractItemTP _CntrlPurchaseContractItemTP
_CentralPurchaseContractTP _CentralPurchaseContractTP
_PurgDocCommodityCodes _PurgDocCommodityCodes
_PurgDocCmmdtyUpdateCycle _PurgDocCmmdtyUpdateCycle
_PurgDocCmmdtyUpdateCycleVH _PurgDocCmmdtyUpdateCycleVH
_Commodity _Commodity
_CommodityVH _CommodityVH

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 C_CntrlPurContrItmCmmdtyQtyTP.
-- 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: CCCTRICMDTQTYTP

CREATE VIEW C_CntrlPurContrItmCmmdtyQtyTP AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  PurgDocCmmdtyQtySqntlNumber,
  PurgDocCmmdtyQtyValidToDate,
  PurgDocCmmdtyQtyValidFromDate,
  PurgDocCmmdtyCode,
  Commodity,
  _PurgDocCommodityCodes.PurgDocCmmdtyDesc AS PurgDocCmmdtyDesc,
  _Commodity._Text[ 1: Language = $session.system_language ].CommodityName AS CommodityName,
  PurchasingDocumentCategory,
  CommodityQuantity,
  _PurgDocCmmdtyUpdateCycleVH.PurgDocCmmdtyUpdateCycleText AS PurgDocCmmdtyUpdateCycleText,
  CommodityUnit,
  PurgDocCmmdtyRefDocItmQty,
  ItemQuantityUnit
FROM I_CntrlPurContrItmCmmdtyQtyTP
LEFT OUTER JOIN C_CntrlPurchaseContractItemTP AS _CntrlPurchaseContractItemTP ON CentralPurchaseContract = _CntrlPurchaseContractItemTP.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurchaseContractItemTP.CentralPurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN C_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_PurgDocCmmdtyUpdateCycle AS _PurgDocCmmdtyUpdateCycle ON PurgDocCmmdtyUpdateCycle = _PurgDocCmmdtyUpdateCycle.PurgDocCmmdtyUpdateCycleDomain  -- association [0..1]
LEFT OUTER JOIN I_PurgDocCmmdtyUpdateCycleTxt AS _PurgDocCmmdtyUpdateCycleVH ON PurgDocCmmdtyUpdateCycle = _PurgDocCmmdtyUpdateCycleVH.PurgDocCmmdtyUpdateCycleDomain  -- association [0..1]
LEFT OUTER JOIN C_PurgDocCommodityCodesVH AS _PurgDocCommodityCodes ON PurgDocCmmdtyCode = _PurgDocCommodityCodes.PurgDocCmmdtyCode AND _PurgDocCommodityCodes.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_PurgDocCommodityVH AS _CommodityVH ON _CommodityVH.Commodity = Commodity AND _CommodityVH.Language = $session.system_language  -- association [1..1]
;

Learn More