I_GoodsMovementDocument

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_GoodsMovementDocument.
-- 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: IGOODSMVMTDOC

CREATE VIEW I_GoodsMovementDocument AS
SELECT
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentRecordType,
  Plant,
  StorageLocation,
  Material,
  Batch,
  InventorySpecialStockType,
  InventoryStockType,
  StockOwner,
  CompanyCode,
  InventorySpecialStockValnType,
  CompanyCodeCurrency,
  MaterialBaseUnit,
  EntryUnit,
  IsReversalMovementType,
  MaterialDocumentPostingType,
  InventoryTransactionType,
  ConsumptionPosting,
  GoodsReceiptType,
  cast(IssuingOrReceivingPlant as nsdm_umwrk preserving type) AS IssuingOrReceivingPlant,
  IssuingOrReceivingStorageLoc,
  IssgOrRcvgMaterial,
  IssgOrRcvgBatch,
  cast (IssgOrRcvgSpclStockInd as nsdm_umsok preserving type) AS IssgOrRcvgSpclStockInd,
  cast (IssuingOrReceivingStockType as nsdm_lbbsa_cid preserving type) AS IssuingOrReceivingStockType,
  IssuingOrReceivingValType,
  cast(ResourceID as nsdm_resourcename preserving type ) AS ResourceID,
  cast(IssgOrRcvgResourceID as nsdm_transfer_resourcename preserving type ) AS IssgOrRcvgResourceID,
  GoodsMovementIsCancelled,
  ReversedMaterialDocument,
  ReversedMaterialDocumentItem,
  ReversedMaterialDocumentYear,
  DocumentDate,
  AccountingDocumentType,
  CreationDate,
  CreationTime,
  PostingDate,
  FiscalYearVariant,
  FiscalYear,
  FiscalYearPeriod,
  YearDay,
  YearWeek,
  YearMonth,
  YearQuarter,
  CalendarQuarter,
  CalendarMonth,
  CalendarWeek,
  CalendarDay,
  WeekDay,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  PurchaseOrder,
  cast(PurchaseOrderItem as nsdm_ebelp preserving type) AS PurchaseOrderItem,
  ProjectNetwork,
  DeliveryDocument,
  cast(DeliveryDocumentItem as nsdm_posnr_vl preserving type) AS DeliveryDocumentItem,
  WBSElementInternalID,
  ManufacturingOrder,
  ManufacturingOrderItem,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  SpecialStockIdfgWBSElement,
  ReferenceDocument,
  GoodsIssueOrReceiptSlipNumber,
  ReferenceDocumentFiscalYear,
  InvtryMgmtRefDocumentItem,
  InvtryMgmtReferenceDocument,
  InventoryUsabilityCode,
  EWMWarehouse,
  EWMStorageBin,
  HandlingUnitExternalID,
  GoodsMovementType,
  InventoryValuationType,
  CreatedByUser,
  Supplier,
  Customer,
  IsMaterialDocumentHeader,
  MaterialDocumentHeaderText,
  MaterialDocumentItemText,
  IsCompletelyDelivered,
  GoodsRecipientName,
  UnloadingPointName,
  GoodsMovementRefDocType,
  GoodsMovementReasonCode,
  ShelfLifeExpirationDate,
  ManufactureDate,
  SerialNumbersAreCreatedAutomly,
  VersionForPrintingSlip,
  ManualPrintIsTriggered,
  CtrlPostgForExtWhseMgmtSyst,
  AccountAssignmentCategory,
  CostCenter,
  ControllingArea,
  CostObject,
  GLAccount,
  FunctionalArea,
  ProfitabilitySegment,
  ProfitabilitySegment_2,
  ProfitCenter,
  MasterFixedAsset,
  FixedAsset,
  FundsCenter,
  Fund,
  CommitmentItem,
  CommitmentItemShortID,
  GrantID,
  Reservation,
  ReservationItem,
  ReservationRecordType AS ReservationItemRecordType,
  ReservationIsFinallyIssued,
  DebitCreditCode,
  TotalGoodsMvtAmtInCCCrcy,
  GoodsMovementStkAmtInCCCrcy,
  GoodsMvtCnsmpnAmtInCCCrcy,
  GdsMvtExtAmtInCoCodeCrcy,
  SlsPrcAmtInclVATInCoCodeCrcy,
  EnteredSlsAmtInCoCodeCrcy,
  MatlStkChangeQtyInBaseUnit,
  MatlCnsmpnQtyInMatlBaseUnit,
  QuantityInBaseUnit,
  QuantityInEntryUnit,
  GoodsReceiptQtyInOrderUnit,
  TransactionCode,
  IsAutomaticallyCreated,
  MaterialDocumentLine,
  MaterialDocumentParentLine,
  HierarchyNodeLevel
FROM I_MaterialDocumentRecord
LEFT OUTER JOIN I_Plant AS _IssuingOrReceivingPlant ON IssuingOrReceivingPlant = _IssuingOrReceivingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _IssgOrRcvgSpclStockInd ON IssgOrRcvgSpclStockInd = _IssgOrRcvgSpclStockInd.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_InventoryStockType AS _IssuingOrReceivingStockType ON IssuingOrReceivingStockType = _IssuingOrReceivingStockType.InventoryStockType  -- association [0..1]
;