I_OIL_StorObjectCharcMatlBasic

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_OIL_StorObjectCharcMatlBasic.
-- 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_OIL_StorObjectCharcMatlBasic AS
SELECT
  socnr AS StorObjectCharcSegmentNumber,
  ftmstm AS AssignmentStartDateTimeValue,
  asscnt AS MultipleMaterialAssignmentVal,
  ttmstm AS AssignmentEndDateTimeValue,
  matnr AS Material,
  matkl AS MaterialGroup,
  charg AS Batch,
  bwtar AS ValuationType,
  bstar AS PhysicalInventoryStockType,
  ns_stock AS MaterialIsNonSpecialStock,
  so_stock AS MaterialIsSalesOrderStock,
  vc_stock AS MaterialIsSupplierCsgnmtStock,
  pr_stock AS MaterialIsProjectStock,
  meins AS StorObjectMaterialVolumeUnit,
  uomgr AS OilUnitOfMeasureGroup,
  umrsl AS ConversionGroup,
  kapaz_ind AS MaterialSgmtPlannedCapacityQty,
  volun AS TankVolumeUnitOfMeasure,
  pld_ttmstm AS PlannedEndDateTimeValue,
  erdat AS CreationDate,
  erzeit AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  aenam AS LastChangedByUser,
  bloind AS EntityIsBlocked,
  delind AS EntityIsMarkedForDeletion
FROM oiisoctsm
LEFT OUTER JOIN I_OIL_StorageObjCharcSegment AS _StorageObjCharcSegment ON StorObjectCharcSegmentNumber = _StorageObjCharcSegment.StorObjectCharcSegmentNumber  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_PhysInvtryStockType AS _PhysInvtryStockType ON PhysicalInventoryStockType = _PhysInvtryStockType.PhysicalInventoryStockType  -- association [1..1]
;