C_MaterialDocumentItemTP

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_MaterialDocumentItemTP.
-- 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_MaterialDocumentItemTP AS
SELECT
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentLine,
  MaterialDocumentParentLine,
  GoodsMovementType,
  Material,
  _Product._Text.ProductName as ProductName : localized AS ProductNameasProductNamelocalized,
  Plant,
  _Plant.PlantName AS PlantName,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  IssuingOrReceivingStorageLoc,
  _IssuingOrReceivingStorageLoc.StorageLocationName AS IssuingOrReceivingStorLocName,
  virtual SerialNumberProfile : serail AS virtualSerialNumberProfileserail,
  virtual UICT_Batch : boole_d AS virtualUICT_Batchboole_d,
  virtual UICT_SerialNumber : boole_d AS virtualUICT_SerialNumberboole_d,
  virtual UICT_HasAccountAssignment : boole_d AS virtualUICT_HasAccountAssignmentboole_d,
  virtual UICT_GLAccount : boole_d AS virtualUICT_GLAccountboole_d,
  virtual UICT_ProfitCenter : boole_d AS virtualUICT_ProfitCenterboole_d,
  virtual UICT_CostCenter : boole_d AS virtualUICT_CostCenterboole_d,
  virtual UICT_ManufacturingOrder : boole_d AS virtualUICT_ManufacturingOrderboole_d,
  virtual UICT_BusinessArea : boole_d AS virtualUICT_BusinessAreaboole_d,
  StorageType,
  StorageBin,
  InventoryUsabilityCode,
  QuantityInEntryUnit,
  EntryUnit,
  QuantityInBaseUnit,
  MaterialBaseUnit,
  Batch,
  ShelfLifeExpirationDate,
  ManufactureDate,
  InventorySpecialStockType,
  InventoryStockType,
  Customer,
  Supplier,
  IssgOrRcvgMaterial,
  IssuingOrReceivingPlant,
  IssgOrRcvgBatch,
  virtual UICT_IssgOrRcvgBatch : boole_d AS virtualUICT_IssgOrRcvgBatchboole_d,
  IssgOrRcvgSpclStockInd,
  IssuingOrReceivingValType,
  WBSElementInternalID,
  Reservation,
  ReservationItem,
  OriginalMaterialDocumentItem,
  GoodsMovementRefDocType,
  GoodsMovementReasonCode,
  InventoryValuationType,
  _Plant.ValuationArea AS ValuationArea,
  MaterialDocumentPostingType,
  PurchaseOrder,
  PurchaseOrderItem,
  CostCenter,
  GLAccount,
  CompanyCode,
  PostingDate,
  DocumentDate,
  ControllingArea,
  ProfitCenter,
  AccountAssignmentCategory,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  ReferenceDocumentFiscalYear,
  InvtryMgmtRefDocumentItem,
  InvtryMgmtReferenceDocument,
  DeliveryDocument,
  DeliveryDocumentItem,
  ReversedMaterialDocumentYear,
  ReversedMaterialDocument,
  ReversedMaterialDocumentItem,
  GoodsMovementIsCancelled,
  GoodsRecipientName,
  UnloadingPointName,
  ReservationIsFinallyIssued,
  ProjectNetwork,
  ManufacturingOrder,
  ManufacturingOrderItem,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  FiscalYearPeriod,
  FiscalYearVariant,
  IsCompletelyDelivered,
  MaterialDocumentItemText,
  EWMWarehouse,
  EWMStorageBin,
  ProductStandardID,
  IsAutomaticallyCreated,
  SerialNumbersAreCreatedAutomly
FROM R_MaterialDocumentItemTP
LEFT OUTER JOIN C_ReservationDocItemOPg AS _ReservationDocumentItem ON Reservation = _ReservationDocumentItem.Reservation AND ReservationItem = _ReservationDocumentItem.ReservationItem  -- association [0..*]
LEFT OUTER JOIN C_ReservationDocOPg AS _ReservationDocument ON Reservation = _ReservationDocument.Reservation  -- association [0..*]
;