C_ProcmtDocSubcontrg

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_ProcmtDocSubcontrg.
-- 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: CSUBCTRG
-- Parameters: P_ReqdDelivDteRngeFrmDte : vdm_shippingdate, P_ReqdDelivDteRngeToDte : vdm_shippingdate

CREATE VIEW C_ProcmtDocSubcontrg AS
SELECT
  _SubCtr.SuplrMatlPlnt AS SuplrMatlPlnt,
  cast ( MaterialComponent as idnrk ) AS Material,
  cast ( _SubCtr.MaterialComponent as idnrk ) AS MatlFilterAnlytlMod,
  Plant,
  _SubCtr.Plant AS PlntFilterAnlytlMod,
  Subcontractor AS Supplier,
  _SubCtr.Subcontractor AS SuplrFilterAnlytlMod,
  _SubCtr.ParentNode AS ParentNode,
  _SubCtr.HierarchyNodeLevel AS HierarchyNodeLevel,
  cast (PurchaseOrder as vdm_purchaseorder ) AS PurchasingDocument,
  cast (_SubCtr.PurchaseOrder as vdm_purchaseorder) AS PurOrdFilterAnlytlMod,
  _SubCtr.PurchaseOrderItem AS PurchasingDocumentItem,
  _SubCtr.FormattedPurchaseOrderItem AS FormattedPurchaseOrderItem,
  cast ( RequestedDeliveryDate as vdm_shippingdate ) AS RequestedDeliveryDate,
  cast ( _SubCtr.RequestedDeliveryDate as vdm_shippingdate ) AS ReqdDelivDteFilterAnlytlMod,
  cast ( ShippingStatus as vdm_shippingstatus ) AS ShippingStatus,
  cast ( _SubCtr.ShippingStatus as vdm_shippingstatus ) AS ShipgStsFilterAnlytlMod,
  cast ( Assembly as bagrp ) AS Assembly,
  cast ( _SubCtr.Assembly as bagrp ) AS AssemblyFilterAnlytlMod,
  cast ( PurchasingGroup as mmpur_req_d_ekgrp) AS PurchasingGroup,
  cast (_SubCtr.PurchasingGroup as mmpur_req_d_ekgrp ) AS PurgGrpFilterAnlytlMod,
  cast ( PurchasingOrganization as ekorg_ll) AS PurchasingOrganization,
  cast ( _SubCtr.PurchasingOrganization as ekorg_ll ) AS PurgOrgFilterAnlytlMod,
  Batch,
  _SubCtr.Batch AS BatchFilterAnlytlMod,
  cast ( _SubCtr.SupplyingPlant as vdm_supplyplant ) AS SupplyingPlant,
  MaterialGroup,
  _SubCtr.MaterialGroup AS MatlGrpFilterAnlytlMod,
  StorageLocation,
  _SubCtr.StorageLocation AS SubcontrgOrdsNodeStorLocation,
  _SubCtr.StillToBeDeliveredQuantity AS StillToBeDeliveredQuantity,
  _SubCtr.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _SubCtr.StockBalanceQuantityUnit AS StockBalanceQuantityUnit,
  _SubCtr.StockUnit AS StockUnit,
  DeliveryType,
  _SubCtr.DeliveryType AS SubcontrgOrdsNodeDeliveryType,
  ProposedShippingPoint,
  _SubCtr.ProposedShippingPoint AS SubcontrgOrdsNodePrpsdShipgPt,
  ScheduleLineDeliveryDate,
  _SubCtr.ScheduleLineDeliveryDate AS SubcontrgDeliveryDate,
  NumberOfItems,
  LoadingGroup,
  _SubCtr.LoadingGroup AS SubcontrgOrdsNodeLoadingGroup,
  PurchasingDocumentType,
  _SubCtr.PurchasingDocumentType AS PurgDocTypeFilterAnlytlMod,
  _SubCtr.RequiredQuantity AS RequiredQuantity,
  _SubCtr.MaterialComponentName AS MaterialComponentName,
  _SubCtr.PlantName AS PlantName,
  _SubCtr.SupplierName AS SupplierName,
  _SubCtr.AssemblyName AS AssemblyName,
  _SubCtr.MaterialGroupName AS MaterialGroupName,
  _SubCtr.StorageLocationName AS StorageLocationName,
  _SubCtr.SupplyingPlantName AS SupplyingPlantName,
  _SubCtr.ShippingStatusText AS ShippingStatusText,
  _SubCtr.PurchasingGroupName AS PurchasingGroupName,
  _SubCtr.PurchasingOrganizationName AS PurchasingOrganizationName,
  _SubCtr.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _SubCtr.CompanyCode AS CompanyCode,
  _SubCtr.AuthorizationGroup AS AuthorizationGroup,
  _SubCtr.SupplierAccountGroup AS SupplierAccountGroup
FROM C_ProcmtDocSubcontrgStruc
;