P_MaterialOverdueSIT

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 P_MaterialOverdueSIT.
-- 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: PMATOVERDUESIT

CREATE VIEW P_MaterialOverdueSIT AS
SELECT
  cast(PurchasingDocument as vdm_purchaseorder preserving type) AS PurchaseOrder,
  cast(PurchasingDocumentItem as vdm_purchaseorderitem preserving type) AS PurchaseOrderItem,
  cast(_GoodsIssueDataSIT.MaterialDocument as nsdm_gi_mblnr preserving type) AS GoodsIssueMaterialDocument,
  cast(_GoodsIssueDataSIT.MaterialDocumentItem as nsdm_gi_item preserving type) AS GoodsIssueMaterialDocumentItem,
  cast(_GoodsIssueDataSIT.MaterialDocumentYear as nsdm_gi_year preserving type) AS GoodsIssueMaterialDocumentYear,
  cast(_GoodsReceiptDataSIT.MaterialDocument as nsdm_gr_mblnr preserving type) AS GoodsReceiptMaterialDocument,
  cast(_GoodsReceiptDataSIT.MaterialDocumentItem as nsdm_gr_item preserving type) AS GoodsReceiptMaterialDocItem,
  cast(_GoodsReceiptDataSIT.MaterialDocumentYear as nsdm_gr_year preserving type) AS GoodsReceiptMaterialDocYear,
  cast( PurchasingDocumentItemUniqueID as mmim_overdue_sit_sitn_anchr_id preserving type) AS MatlOverdueSitSitnAnchrID,
  cast(_PurchasingDocument.SupplyingPlant as nsdm_gi_werks preserving type) AS IssuingPlant,
  cast(_PurchasingDocument._SupplyingPlant.PlantName as nsdm_gi_name preserving type) AS IssuingPlantName,
  _PurchasingDocument.PurchasingDocumentType AS PurchasingDocumentType,
  cast(_PurchasingDocumentItem.StorageLocation as mmim_supplyingstoragelocation preserving type ) AS SupplyingStorageLocation,
  cast( _PurchasingDocument.CreatedByUser as mmim_po_createdby preserving type ) AS CreatedByUser,
  GRCreatedByUser,
  GICreatedByUser,
  _PurchasingDocument.PurchasingDocumentOrderDate AS CreationDate,
  PurchasingDocumentCategory,
  PurchasingDocumentDeletionCode,
  InventorySpecialStockType,
  _PurchasingDocumentItem.Material AS Material,
  cast(PurchasingDocumentItemText as maktx preserving type) AS MaterialName,
  IsCompletelyDelivered,
  cast(OrderQuantity as mmim_po_quantity preserving type) AS PurchaseOrderItemQuantity,
  OrderQuantityUnit AS BaseUnit,
  NetAmount,
  DocumentCurrency,
  MaterialGroup,
  _PurchasingDocument.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  cast('10' as char3) AS UnitOfMeasure,
  $session.system_date AS SystemDate,
  GoodsReceiptIsCanceled,
  GoodsIssueIsCanceled,
  _GoodsIssueDataSIT.GoodsIssueForDeliveryDoc AS GoodsIssueForDeliveryDoc,
  _GoodsIssueDataSIT.GoodsIssueForDeliveryDocItem AS GoodsIssueForDeliveryDocItem,
  _GoodsIssueDataSIT.GoodsIssueDelivDocItmCrtnDte AS GoodsIssueDelivDocItmCrtnDte,
  _GoodsIssueDataSIT.GoodsIssueDelivDocItmQty AS GoodsIssueDelivDocItmQty,
  _GoodsIssueDataSIT.GoodsIssueDelivDocItmBatch AS GoodsIssueDelivDocItmBatch,
  _GoodsIssueDataSIT.GoodsIssueDelivDocType AS GoodsIssueDelivDocType,
  _GoodsIssueDataSIT.GoodsIssueDelivDocCat AS GoodsIssueDelivDocCat,
  _GoodsIssueDataSIT.GoodsIssueDelivDocItmStatus AS GoodsIssueDelivDocItmStatus,
  _GoodsReceiptDataSIT.GoodsReceiptForDeliveryDoc AS GoodsReceiptForDeliveryDoc,
  _GoodsReceiptDataSIT.GoodsReceiptForDeliveryDocItem AS GoodsReceiptForDeliveryDocItem,
  _GoodsReceiptDataSIT.GoodsReceiptDelivDocItmCrtnDte AS GoodsReceiptDelivDocItmCrtnDte,
  _GoodsReceiptDataSIT.GoodsReceiptDelivDocItmQty AS GoodsReceiptDelivDocItmQty,
  _GoodsReceiptDataSIT.GoodsReceiptDelivDocItmBatch AS GoodsReceiptDelivDocItmBatch,
  _GoodsReceiptDataSIT.GoodsReceiptDelivDocType AS GoodsReceiptDelivDocType,
  _GoodsReceiptDataSIT.GoodsReceiptDelivDocCat AS GoodsReceiptDelivDocCat,
  _GoodsReceiptDataSIT.GoodsReceiptDelivDocItmStatus AS GoodsReceiptDelivDocItmStatus,
  _GoodsIssueDataSIT.GoodsIssueMovementType AS GoodsIssueMovementType,
  _GoodsIssueDataSIT.GoodsIssuePostingDate AS GoodsIssuePostingDate,
  _GoodsIssueDataSIT.GoodsIssueQuantity AS GoodsIssueQuantity,
  _GoodsIssueDataSIT.GoodsIssueQtyInOrderUnit AS GoodsIssueQtyInOrderUnit,
  cast(_PurchasingDocumentItem.Plant as nsdm_gr_werks preserving type) AS ReceivingPlant,
  _PurchasingDocumentItem._Plant.PlantName AS ReceivingPlantName,
  _GoodsReceiptDataSIT.GoodsReceiptMovementType AS GoodsReceiptMovementType,
  _GoodsReceiptDataSIT.GoodsReceiptPostingDate AS GoodsReceiptPostingDate,
  cast(_PurchasingDocumentItem.CompanyCode as nsdm_gr_bukrs preserving type) AS ReceivingCompanyCode,
  _GoodsReceiptDataSIT.GoodsReceiptQuantity AS GoodsReceiptQuantity,
  _GoodsReceiptDataSIT.GoodsReceiptQtyInOrderUnit AS GoodsReceiptQtyInOrderUnit,
  _GoodsIssueDataSIT.GoodsIssueUTCDateTime AS GoodsIssueUTCDateTime,
  _GoodsReceiptDataSIT.GoodsReceiptUTCDateTime AS GoodsReceiptUTCDateTime,
  _GoodsIssueDataSIT.IssuingStorageLocation AS IssuingStorageLocation,
  _GoodsIssueDataSIT.IssuingBatch AS IssuingBatch,
  _GoodsIssueDataSIT.IssuingCompanyCode AS IssuingCompanyCode,
  _GoodsReceiptDataSIT._GetLastPostingDate.LastPostingDateOfMaterialDoc AS LastPostingDateOfMaterialDoc,
  _ScheduleLine.ScheduleLine AS ScheduleLine,
  _ScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate
LEFT OUTER JOIN P_GoodsReceiptDataSITLoc AS _GoodsReceiptDataSIT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_GoodsIssueDataSIT AS _GoodsIssueDataSIT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseOrderOfSIT AS _PurchaseOrderOfSIT ON PurchaseOrder = _PurchaseOrderOfSIT.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderOfSIT.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_MaterialOfSIT AS _MaterialOfSIT ON Material = _MaterialOfSIT.Material AND MaterialName = _MaterialOfSIT.MaterialName AND MaterialGroup = _MaterialOfSIT.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_ReceivingCompanyCodeOfSIT AS _ReceivingCompanyCodeOfSIT ON ReceivingCompanyCode = _ReceivingCompanyCodeOfSIT.ReceivingCompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ReceivingPlantOfSIT AS _ReceivingPlantOfSIT ON ReceivingPlant = _ReceivingPlantOfSIT.ReceivingPlant  -- association [1..1]
LEFT OUTER JOIN I_IssuingCompanyCodeOfSIT AS _IssuingCompanyCodeOfSIT ON IssuingCompanyCode = _IssuingCompanyCodeOfSIT.IssuingCompanyCode  -- association [1..1]
LEFT OUTER JOIN I_IssuingPlantOfSIT AS _IssuingPlantOfSIT ON IssuingPlant = _IssuingPlantOfSIT.IssuingPlant  -- association [1..1]
LEFT OUTER JOIN I_IssueMovementTypeOfSIT AS _IssueMovementTypeOfSIT ON GoodsIssueMovementType = _IssueMovementTypeOfSIT.GoodsIssueMovementType  -- association [1..1]
LEFT OUTER JOIN I_ReceiptMovementTypeOfSIT AS _ReceiptMovementTypeOfSIT ON GoodsReceiptMovementType = _ReceiptMovementTypeOfSIT.GoodsReceiptMovementType  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderTypeOfSIT AS _PurchaseOrderTypeOfSIT ON PurchasingDocumentType = _PurchaseOrderTypeOfSIT.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderCategoryOfSIT AS _PurchaseOrderCategoryOfSIT ON PurchasingDocumentCategory = _PurchaseOrderCategoryOfSIT.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_InventorySpecStockTypeOfSIT AS _InventorySpecStockTypeOfSIT ON InventorySpecialStockType = _InventorySpecStockTypeOfSIT.InventorySpecialStockType  -- association [1..1]
LEFT OUTER JOIN I_GIStorageLocationVH AS _GIStorageLocationVH ON IssuingPlant = _GIStorageLocationVH.IssuingPlant AND IssuingStorageLocation = _GIStorageLocationVH.IssuingStorageLocation  -- association [1..1]
LEFT OUTER JOIN I_GIBatchVH AS _GIBatchVH ON IssuingBatch = _GIBatchVH.IssuingBatch AND Material = _GIBatchVH.Material  -- association [1..1]
LEFT OUTER JOIN I_CreatedByUserOfSIT AS _CreatedByUserOfSIT ON CreatedByUser = _CreatedByUserOfSIT.CreatedByUser  -- association [1..1]
LEFT OUTER JOIN I_MatlDocUserVH AS _GoodsReceiptUserVH ON GRCreatedByUser = _GoodsReceiptUserVH.CreatedByUser  -- association [1..1]
LEFT OUTER JOIN I_MatlDocUserVH AS _GoodsIssueUserVH ON GICreatedByUser = _GoodsIssueUserVH.CreatedByUser  -- association [1..1]
LEFT OUTER JOIN I_PurOrdDeletionCodeOfSIT AS _PurOrdDeletionCodeOfSIT ON PurchasingDocumentDeletionCode = _PurOrdDeletionCodeOfSIT.PurchasingDocumentDeletionCode  -- association [1..1]
LEFT OUTER JOIN I_ProcessTypeOfSIT AS _ProcessTypeOfSIT ON StockInTransitProcessType = _ProcessTypeOfSIT.StockInTransitProcessType  -- association [1..1]
LEFT OUTER JOIN I_MatlDocYearOfStInTransit AS _GoodsIssueMatDocYearOfSIT ON GoodsIssueMaterialDocumentYear = _GoodsIssueMatDocYearOfSIT.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_MatlDocYearOfStInTransit AS _GoodsReceiptMatDocYearOfSIT ON GoodsReceiptMaterialDocYear = _GoodsReceiptMatDocYearOfSIT.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_GoodsIssueMatDocOfSIT AS _GoodsIssueMatDocOfSIT ON GoodsIssueMaterialDocument = _GoodsIssueMatDocOfSIT.MaterialDocument  -- association [1..1]
LEFT OUTER JOIN I_GoodsReceiptMatDocOfSIT AS _GoodsReceiptMatDocOfSIT ON GoodsReceiptMaterialDocument = _GoodsReceiptMatDocOfSIT.MaterialDocument  -- association [1..1]
;