C_PurContrItmCmplncCriticality

DDL: C_PURCONTRITMCMPLNCCRITICALITY SQL: CCTRITMPCCRIT Type: view CONSUMPTION
7 Fields 1 Data Sources

Criticality of the values of the Product complian

C_PurContrItmCmplncCriticality is a Consumption CDS View that provides data about "Criticality of the values of the Product complian" in SAP S/4HANA. It reads from 1 data source (R_PurchaseContractItem) and exposes 7 fields with key fields PurchaseContract, PurchaseContractItem.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseContractItem R_PurchaseContractItem from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCTRITMPCCRIT view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Criticality of the values of the Product complian view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PurchaseContractItem Item
Plant Plant Valuation Area
int4asUICT_PurgProdCmplncSupplierSts
int4asUICT_PurgProdMarketabilitySts
int4asUICT_PurgSafetyDataSheetStatus
int4asUICT_PurgCmplncDngrsGoodsSts

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_PurContrItmCmplncCriticality.
-- 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: CCTRITMPCCRIT

CREATE VIEW C_PurContrItmCmplncCriticality AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  Plant,
  cast ( case when PurgProdCmplncSupplierStatus = ' ' then 3 when PurgProdCmplncSupplierStatus = 'A' then 3 when PurgProdCmplncSupplierStatus = 'B' then 3 when PurgProdCmplncSupplierStatus = 'C' then 1 when PurgProdCmplncSupplierStatus = 'D' then 1 when PurgProdCmplncSupplierStatus = 'G' then 1 else 0 end as abap.int4 ) as UICT_PurgProdCmplncSupplierSts AS int4asUICT_PurgProdCmplncSupplierSts,
  cast ( case when PurgProductMarketabilityStatus = ' ' then 3 when PurgProductMarketabilityStatus = 'A' then 3 when PurgProductMarketabilityStatus = 'B' then 3 when PurgProductMarketabilityStatus = 'C' then 1 when PurgProductMarketabilityStatus = 'D' then 1 when PurgProductMarketabilityStatus = 'G' then 1 else 0 end as abap.int4 ) as UICT_PurgProdMarketabilitySts AS int4asUICT_PurgProdMarketabilitySts,
  cast ( case when PurgSafetyDataSheetStatus = ' ' then 3 when PurgSafetyDataSheetStatus = 'A' then 3 when PurgSafetyDataSheetStatus = 'B' then 3 when PurgSafetyDataSheetStatus = 'C' then 2 when PurgSafetyDataSheetStatus = 'D' then 3 when PurgSafetyDataSheetStatus = 'E' then 1 when PurgSafetyDataSheetStatus = 'F' then 1 when PurgSafetyDataSheetStatus = 'G' then 1 else 0 end as abap.int4 ) as UICT_PurgSafetyDataSheetStatus AS int4asUICT_PurgSafetyDataSheetStatus,
  cast ( case when PurgProdCmplncDngrsGoodsStatus = ' ' then 3 when PurgProdCmplncDngrsGoodsStatus = 'A' then 3 when PurgProdCmplncDngrsGoodsStatus = 'B' then 3 when PurgProdCmplncDngrsGoodsStatus = 'C' then 2 when PurgProdCmplncDngrsGoodsStatus = 'F' then 3 when PurgProdCmplncDngrsGoodsStatus = 'G' then 1 else 0 end as abap.int4 ) as UICT_PurgCmplncDngrsGoodsSts AS int4asUICT_PurgCmplncDngrsGoodsSts
FROM R_PurchaseContractItem
;

Learn More