C_JITOutbCallCompGrpDataTP

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_JITOutbCallCompGrpDataTP.
-- 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: CJITOUTBCGTP

CREATE VIEW C_JITOutbCallCompGrpDataTP AS
SELECT
  ParentDraftKey,
  InternalJITCallNumber,
  CompGrpNumber,
  CompGrpNumberForEdit,
  CompGrpMatl,
  _ProductCompGrp._Text[1: Language=$session.system_language].ProductName AS ProductName,
  JITIntProcessingStatus,
  JITIntStatusUpdtdOn,
  _JITInternalStatus._Text[1: Language=$session.system_language].JITInternalStatusText AS JITInternalStatusText,
  Plant,
  PlantName,
  JITActionCtrl,
  ReplenishmentStrategy,
  JITOutbStockTransferSts,
  _JITStockTransferSts._Text[1: Language = $session.system_language].JITStockTransferStsText AS JITStockTransferStsText,
  JITControlCycle,
  StorageLocation,
  StorageLocationName,
  JITOutbDestinationStorLoc,
  RequirementDateTime,
  RequirementDateTimeForEdit,
  JITSupplyDateTime,
  ProductionSupplyArea,
  ProductionSupplyAreaName,
  _ResponsiblePerson.MRPControllerName AS MRPControllerName,
  Responsible,
  EWMWarehouse,
  cast('' as /scwm/de_desc40 ) AS WarehouseName,
  StorageType,
  StorageTypeName,
  StorageBin
FROM I_JITOutbCallCompGrpDataTP AS _JITOutbCallCompGrpDataTP
LEFT OUTER JOIN C_JITOutbCallHdrTP AS _JITOutbCallHdrTP ON ParentDraftKey = _JITOutbCallHdrTP.JITHeaderUUID AND InternalJITCallNumber = _JITOutbCallHdrTP.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN C_JITOutbCallCompMatlDataTP AS _JITOutbCallCompMatlDataTP ON ParentDraftKey = _JITOutbCallCompMatlDataTP.RootDraftKey AND InternalJITCallNumber = _JITOutbCallCompMatlDataTP.InternalJITCallNumber AND CompGrpNumber = _JITOutbCallCompMatlDataTP.CompGrpNumber  -- association [1..*]
LEFT OUTER JOIN C_JITOutbCallRefTextCompGrpTP AS _JITOutbCallRefTextCompGrpTP ON ParentDraftKey = _JITOutbCallRefTextCompGrpTP.RootDraftKey AND InternalJITCallNumber = _JITOutbCallRefTextCompGrpTP.InternalJITCallNumber AND CompGrpNumber = _JITOutbCallRefTextCompGrpTP.CompGrpNumber  -- association [0..*]
LEFT OUTER JOIN I_JITInternalStatus AS _JITInternalStatus ON JITIntProcessingStatus = _JITInternalStatus.JITIntProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_JITStockTransferSts AS _JITStockTransferSts ON JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _ProductionSupplyArea ON Plant = _ProductionSupplyArea.Plant AND ProductionSupplyArea = _ProductionSupplyArea.ProductionSupplyArea  -- association [0..1]
;