I_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 I_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 I_MaterialOverdueSIT AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  case when GoodsIssueMaterialDocument is null then cast( '0000000000' as nsdm_gi_mblnr) else GoodsIssueMaterialDocument end AS GoodsIssueMaterialDocument,
  case when GoodsIssueMaterialDocumentItem is null then '0000' else GoodsIssueMaterialDocumentItem end AS GoodsIssueMaterialDocumentItem,
  case when GoodsIssueMaterialDocumentYear is null then '0000' else GoodsIssueMaterialDocumentYear end AS GoodsIssueMaterialDocumentYear,
  case when GoodsReceiptMaterialDocument is null then cast( '0000000000' as nsdm_gr_mblnr) else GoodsReceiptMaterialDocument end AS GoodsReceiptMaterialDocument,
  case when GoodsReceiptMaterialDocItem is null then '0000' else GoodsReceiptMaterialDocItem end AS GoodsReceiptMaterialDocItem,
  case when GoodsReceiptMaterialDocYear is null then '0000' else GoodsReceiptMaterialDocYear end AS GoodsReceiptMaterialDocYear,
  case when GoodsIssueUTCDateTime is null then cast( '000000000000000' as mmim_date_time) else GoodsIssueUTCDateTime end AS GoodsIssueUTCDateTime,
  case when GoodsReceiptUTCDateTime is null then cast( '000000000000000' as mmim_date_time) else GoodsReceiptUTCDateTime end AS GoodsReceiptUTCDateTime,
  MatlOverdueSitSitnAnchrID,
  SupplyingStorageLocation,
  IssuingCompanyCode,
  IssuingPlant,
  IssuingPlantName,
  PurchasingDocumentType,
  CreatedByUser,
  GRCreatedByUser,
  GICreatedByUser,
  CreationDate,
  PurchasingDocumentCategory,
  PurchasingDocumentDeletionCode,
  InventorySpecialStockType,
  Material,
  MaterialName,
  IsCompletelyDelivered,
  PurchaseOrderItemQuantity,
  BaseUnit,
  NetAmount,
  DocumentCurrency,
  MaterialGroup,
  NumbersOfDaysSincePurOrdPostg,
  DifferenceOfGRAndGIDate,
  DurationBetweenPOAndGI,
  UnitOfMeasure,
  MaterialBaseUnit,
  StockInTransitProcessType,
  GoodsIssueMovementType,
  GoodsIssuePostingDate,
  GoodsIssueQuantity,
  GoodsIssueQtyInOrderUnit,
  ReceivingPlant,
  ReceivingPlantName,
  GoodsReceiptMovementType,
  GoodsReceiptPostingDate,
  ReceivingCompanyCode,
  GoodsReceiptQuantity,
  GoodsReceiptQtyInOrderUnit,
  StorageLocation,
  Batch,
  IssuingStorageLocation,
  IssuingBatch,
  LastPostingDateOfMaterialDoc,
  ScheduleLine,
  ScheduleLineDeliveryDate,
  GoodsReceiptIsCanceled,
  GoodsIssueIsCanceled,
  RealOrExpectedMaterialPostgDte,
  DaysInTransit,
  GoodsIssueForDeliveryDocItem,
  GoodsIssueDelivDocItmCrtnDte,
  GoodsIssueDelivDocItmQty,
  GoodsIssueDelivDocItmBatch,
  GoodsIssueDelivDocType,
  GoodsIssueDelivDocItmStatus,
  GoodsReceiptForDeliveryDocItem,
  GoodsReceiptDelivDocItmCrtnDte,
  GoodsReceiptDelivDocItmQty,
  GoodsReceiptDelivDocItmBatch,
  GoodsReceiptDelivDocType,
  GoodsReceiptDelivDocItmStatus
FROM P_MaterialOverdueSITLoc
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]
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_StorageLocationOfSIT AS _StorageLocationOfSIT ON ReceivingPlant = _StorageLocationOfSIT.ReceivingPlant AND StorageLocation = _StorageLocationOfSIT.StorageLocation  -- association [1..1]
LEFT OUTER JOIN I_BatchOfSIT AS _BatchOfSIT ON Batch = _BatchOfSIT.Batch AND Material = _BatchOfSIT.Material  -- association [1..1]
;