/VSCEW/C_NSC_Procurement

DDL: /VSCEW/C_NSC_PROCUREMENT Type: view_entity Package: /VSCEW/CORE_CDS
10 Fields 3 Data Sources

Neutral Supply Chain (External)

/VSCEW/C_NSC_Procurement is a CDS View that provides data about "Neutral Supply Chain (External)" in SAP S/4HANA. It reads from 3 data sources (I_PurchasingInfoRecordApi01, /VSCEW/I_ProductMRPArea, I_PurgInfoRecdOrgPlntDataApi01) and exposes 10 fields with key fields Product, Plant, MRPArea, Supplier, PurchasingOrganization. Part of development package /VSCEW/CORE_CDS.

Data Sources (3)

SourceAliasJoin Type
I_PurchasingInfoRecordApi01 InfoRecord from
/VSCEW/I_ProductMRPArea MRPArea inner
I_PurgInfoRecdOrgPlntDataApi01 OrgPlantData inner

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Neutral Supply Chain (External) view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Product I_PurchasingInfoRecordApi01 Material Vehicle Model
KEY Plant I_PurgInfoRecdOrgPlntDataApi01 Plant Valuation Area
KEY MRPArea /VSCEW/I_ProductMRPArea MRPArea MRP Area
KEY Supplier I_PurchasingInfoRecordApi01 Supplier Supplier
KEY PurchasingOrganization I_PurgInfoRecdOrgPlntDataApi01 PurchasingOrganization Purchasing Organization
IsRegularSupplierXthen1else2endasPrio
PlannedDeliveryDurationInDays I_PurgInfoRecdOrgPlntDataApi01 MaterialPlannedDeliveryDurn Pl. Deliv. Time
MinLotSize I_PurgInfoRecdOrgPlntDataApi01 MinimumPurchaseOrderQuantity Minimum Qty
quan133endasMaxLotSize
QuantityUnit I_PurgInfoRecdOrgPlntDataApi01 PurchaseOrderPriceUnit Order Price Un.

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 /VSCEW/C_NSC_Procurement.
-- 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 /VSCEW/C_NSC_Procurement AS
SELECT
  InfoRecord.Material AS Product,
  OrgPlantData.Plant AS Plant,
  MRPArea.MRPArea AS MRPArea,
  InfoRecord.Supplier AS Supplier,
  OrgPlantData.PurchasingOrganization AS PurchasingOrganization,
  case when InfoRecord.IsRegularSupplier = 'X' then 1 else 2 end as Prio AS IsRegularSupplierXthen1else2endasPrio,
  OrgPlantData.MaterialPlannedDeliveryDurn AS PlannedDeliveryDurationInDays,
  OrgPlantData.MinimumPurchaseOrderQuantity AS MinLotSize,
  case when OrgPlantData.MaximumOrderQuantity is not initial then OrgPlantData.MaximumOrderQuantity else cast(9999999999.000 as abap.quan(13,3)) end as MaxLotSize AS quan133endasMaxLotSize,
  OrgPlantData.PurchaseOrderPriceUnit AS QuantityUnit
FROM I_PurchasingInfoRecordApi01 AS InfoRecord
INNER JOIN I_PurgInfoRecdOrgPlntDataApi01 AS OrgPlantData ON /* join condition not captured in parsed metadata */
INNER JOIN /VSCEW/I_ProductMRPArea AS MRPArea ON /* join condition not captured in parsed metadata */
;

Learn More