C_GoodsMovementQuery

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_GoodsMovementQuery.
-- 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_GoodsMovementQuery AS
SELECT
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  Plant,
  StorageLocation,
  Material,
  Batch,
  InventorySpecialStockType,
  InventoryStockType,
  StockOwner,
  CompanyCode,
  InventorySpecialStockValnType,
  ResourceID,
  CompanyCodeCurrency,
  MaterialBaseUnit,
  IsReversalMovementType,
  cast(IsEffectiveGoodsMovement as nsdm_is_effective_goodsmvt preserving type ) AS IsEffectiveGoodsMovement,
  MaterialGroup,
  MaterialType,
  IssgOrRcvgMaterial,
  IssgOrRcvgBatch,
  IssgOrRcvgSpclStockInd,
  IssuingOrReceivingStockType,
  IssgOrRcvgResourceID,
  GoodsMovementIsCancelled,
  GoodsMovementCancellationType,
  DocumentDate,
  PostingDate,
  FiscalYearVariant,
  FiscalYear,
  FiscalYearPeriod,
  YearDay,
  YearWeek,
  YearMonth,
  YearQuarter,
  CalendarQuarter,
  CalendarMonth,
  CalendarWeek,
  CalendarDay,
  WeekDay,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  PurchaseOrder,
  PurchaseOrderItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  WBSElementInternalID,
  ManufacturingOrder,
  ManufacturingOrderItem,
  PurchasingGroup,
  PurchasingOrganization,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesGroup,
  GoodsMovementType,
  GoodsMovementReasonCode,
  InventoryValuationType,
  Supplier,
  Customer,
  AccountAssignmentCategory,
  CostObject,
  CostCenter,
  ControllingArea,
  ProfitabilitySegment,
  ProfitabilitySegment_2,
  ProfitCenter,
  GLAccount,
  FunctionalArea,
  StockChangeCategory,
  IsConsumptionMovement,
  IsCrossPlantTransfer,
  IsStorageLocChangeByTransf,
  IsMaterialChangeByTransf,
  IsBatchChangeByTransf,
  IsSpclStkTypeChangeByTransf,
  IsStockTypeChangeByTransf,
  NumberOfGoodsReceipts,
  NumberOfGoodsIssues,
  NumberOfGoodsMovements,
  GoodsReceiptAmountInCoCodeCrcy,
  GoodsIssueAmountInCoCodeCrcy,
  GoodsMvtCnsmpnAmtInCCCrcy,
  GoodsMovementStkAmtInCCCrcy,
  GoodsReceiptQtyInBaseUnit,
  GoodsIssueQtyInBaseUnit,
  TotalGdsMvtQtyInBaseUnit,
  MatlCnsmpnQtyInMatlBaseUnit,
  MatlStkChangeQtyInBaseUnit,
  MinGoodsRcptQtyInBaseUnit,
  MaxGoodsRcptQtyInBaseUnit,
  MinGoodsIssueQtyInBaseUnit,
  MaxGoodsIssueQtyInBaseUnit,
  MinCnsmpnQtyInBaseUnit,
  MaxCnsmpnQtyInBaseUnit,
  FirstGoodsMovementPostingDate,
  LastGoodsMovementPostingDate
FROM I_GoodsMovementCube AS GoodsMovementCube
;