C_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 C_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.

CREATE VIEW C_MaterialOverdueSIT AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  GoodsIssueMaterialDocument,
  GoodsIssueMaterialDocumentItem,
  GoodsIssueMaterialDocumentYear,
  GoodsReceiptMaterialDocument,
  GoodsReceiptMaterialDocItem,
  GoodsReceiptMaterialDocYear,
  OverdueSITDocSelectionType,
  MatlOverdueSitSitnAnchrID,
  _SitnInstceIndicator.SitnNumberOfInstances AS SitnNumberOfInstances,
  PurchaseOrderItemCnctntdID,
  PurchaseOrderItemQuantity,
  BaseUnit,
  PurchasingDocumentType,
  _PurchaseOrderTypeOfSIT.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PurchasingDocumentCategory,
  _PurchaseOrderCategoryOfSIT.PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  CreationDate,
  PurchasingDocumentDeletionCode,
  _PurOrdDeletionCodeOfSIT.PurDocDeletionCodeName AS PurDocDeletionCodeName,
  SupplyingStorageLocation,
  IssuingCompanyCode,
  IssuingPlant,
  IssuingPlantName,
  GoodsIssueQtyInOrderUnit,
  GoodsIssueQuantity,
  Material,
  MaterialName,
  IsCompletelyDelivered,
  CompletelyDeliveredExLmt,
  GoodsIssueMovementType,
  GoodsIssuePostingDate,
  GICreatedByUser,
  _GICreatedByUser.UserDescription AS GICreatedByUserDescription,
  GoodsReceiptMovementType,
  GoodsReceiptPostingDate,
  GRCreatedByUser,
  _GRCreatedByUser.UserDescription AS GRCreatedByUserDescription,
  ReceivingCompanyCode,
  ReceivingPlant,
  ReceivingPlantName,
  GoodsReceiptQtyInOrderUnit,
  GoodsReceiptQuantity,
  ReceivingStorageLocation,
  ReceivingBatch,
  IssuingStorageLocation,
  IssuingBatch,
  InventorySpecialStockType,
  NetAmount,
  DocumentCurrency,
  MaterialGroup,
  DaysInTransit,
  NumbersOfDaysSincePurOrdPostg,
  DifferenceOfGRAndGIDate,
  DurationBetweenPOAndGI,
  UnitOfMeasure,
  MaterialBaseUnit,
  StockInTransitProcessType,
  _ProcessTypeOfSIT.StockInTransitProcessTypeName AS StockInTransitProcessTypeName,
  GoodsReceiptIsCanceled,
  GoodsIssueIsCanceled,
  PredictedDaysOfDelivDeviation,
  StartOfStockTransportOrder,
  PredictedDelivDte,
  PredictedDelDaysRltnPOPostDate,
  PlannedDelDaysRltnPOPostDate,
  RealOrExpectedMaterialPostgDte,
  ShippingDaysSincePOPostingDate,
  StkInTransitDelivDteCritlty,
  ScheduleLineDeliveryDate,
  GoodsIssueForDeliveryDoc,
  GoodsIssueForInboundDelivDoc,
  GoodsIssueForDeliveryDocItem,
  GoodsIssueDelivDocItmCrtnDte,
  GoodsIssueDelivDocItmQty,
  GoodsIssueDelivDocItmBatch,
  GoodsIssueDelivDocType,
  GoodsIssueDelivDocItmStatus,
  GoodsReceiptForDeliveryDoc,
  GoodsReceiptForOutbDelivDoc,
  GoodsReceiptForDeliveryDocItem,
  GoodsReceiptDelivDocItmCrtnDte,
  GoodsReceiptDelivDocItmQty,
  GoodsReceiptDelivDocItmBatch,
  GoodsReceiptDelivDocType,
  GoodsReceiptDelivDocItmStatus,
  cast( _MaterialPlant.MRPController as mmim_gr_mrp_controller preserving type ) AS ReceivingPlantMRPResponsible,
  _TotalQuantities.TotalGoodsIssuedForPOQty AS TotalGoodsIssuedForPOQty,
  _TotalQuantities.TotalGoodsReceiptForPOQty AS TotalGoodsReceiptForPOQty,
  _TotalQuantities.TotalGoodsIssuedQtyExLmt AS TotalGoodsIssuedQtyExLmt,
  _TotalQuantities.TotalGoodsReceiptQtyExLmt AS TotalGoodsReceiptQtyExLmt,
  DaysInTransitExLmt
FROM I_MatlOvrdStInTrPredictedDte
LEFT OUTER JOIN I_InventoryMRPControllerVH AS _ReceivingPlantMRPResponsible ON ReceivingPlant = _ReceivingPlantMRPResponsible.Plant AND ReceivingPlantMRPResponsible = _ReceivingPlantMRPResponsible.MRPController  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND ReceivingPlant = _ProductPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductIssuingPlant ON Material = _ProductIssuingPlant.Product AND IssuingPlant = _ProductIssuingPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Material = _Batch.Material AND ReceivingPlant = _Batch.Plant AND ReceivingBatch = _Batch.Batch  -- association [1..1]
LEFT OUTER JOIN I_GdsRecGdsIssdTotQtyForPO AS _TotalQuantities ON PurchaseOrder = _TotalQuantities.PurchaseOrder AND PurchaseOrderItem = _TotalQuantities.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_MaterialPlant AS _MaterialPlant ON Material = _MaterialPlant.Material AND ReceivingPlant = _MaterialPlant.Plant  -- association [1..1]
;