R_JITPackingGroupTP

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 R_JITPackingGroupTP.
-- 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 R_JITPackingGroupTP AS
SELECT
  db_key AS JITPckgGrpUUID,
  pckg_grp_id AS JITPckgGrpID,
  pckg_grp_def_uuid AS JITPckgGrpDefUUID,
  status AS JITPckgGrpStatus,
  kunnr AS ShipToParty,
  ablad AS UnloadingPointName,
  vstel AS ShippingPoint,
  planned_shipping_dt AS PlannedShippingDateTime,
  requirement_date AS RequirementDateTime,
  ledat AS DeliveryCreationDate,
  MaterialAvailabilityDateTime,
  ProductionStartDate,
  ProductionEndDate,
  cust_sup_area AS CustSupplyArea,
  fldpo AS CustAssemblyLoc,
  werks AS Plant,
  JITComponentIsReordered,
  jitcomponentisreordered AS JITPackingGroupUsageType,
  JITPackageLevel,
  lgort AS StorageLocation,
  CustomerUUID,
  JITAltvHndlgUnitID,
  JITAltvHndlgUnitIDShrt,
  RepetitiveManufacturingIsAllwd,
  JITDelivSqncGrpID,
  JITDelivSqncGrpUUID,
  JITExtSequenceNumberFrom,
  JITExtSequenceNumberTo,
  JITFormattedSequenceNmbrFrom,
  JITFormattedSequenceNmbrTo,
  JITExtStatusUpdtdOn,
  JITIntStatusUpdtdOn,
  DeliveryCreationTime,
  pkg_grp_stat AS JITPackingGroupCreationStatus,
  deli_crea_stat AS DeliveryStatus,
  goods_mvmt_stat AS GoodsMovementStatus,
  bill_stat AS JITBillingStatus,
  r2p_stat AS JITReleaseToProductionStatus,
  cp_stat AS JITProdnConfirmationStatus,
  r2pck_stat AS JITReleaseForPackingStatus,
  pack_stat AS JITPackingConfirmationStatus,
  hu_stat AS HandlingUnitStatus,
  JITArchivingStatus,
  JITCompGrpErlstDelivCrtnUUID,
  crea_date_time AS CreationDateTime,
  crea_uname AS CreatedByUser,
  lchg_date_time AS ChangedOnDateTime,
  lchg_uname AS LastChangedByUser,
  JITLogsIntegRlvtEntity,
  _JITPckgGrpStatus._Text[1: Language=$session.system_language].JITPckgGrpStatusTxt AS JITPckgGrpStatusTxt,
  _Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Customer.AuthorizationGroup AS AuthorizationGroup
FROM njit_d_pg_hdr
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON ShipToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_JITPckgGrpStatus AS _JITPckgGrpStatus ON JITPckgGrpStatus = _JITPckgGrpStatus.JITPckgGrpStatus  -- association [0..1]
LEFT OUTER JOIN I_JITPckgGrpDef AS _JITPckgGrpDef ON JITPckgGrpDefUUID = _JITPckgGrpDef.JITPckgGrpDefUUID  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_JITDelivSqncGrpHeaderBasic AS _JITDelivSqncGrpHeader ON JITDelivSqncGrpUUID = _JITDelivSqncGrpHeader.JITDelivSqncGrpUUID  -- association [1..1]
LEFT OUTER JOIN R_JITPackingGroupItemRefTP AS _JITPackingGroupItemRefTP ON JITPckgGrpUUID = _JITPackingGroupItemRefTP.ReferenceDocumentUUID AND _JITPackingGroupItemRefTP.JITPckgCntntType = '0'  -- association [0..*]
LEFT OUTER JOIN I_JITPackingGroupUsageType AS _JITPackingGroupUsageType ON JITPackingGroupUsageType = _JITPackingGroupUsageType.JITPackingGroupUsageType  -- association [0..1]
LEFT OUTER JOIN I_JITLogsIntegRlvtEntity AS _JITLogsIntegRlvtEntity ON JITLogsIntegRlvtEntity = _JITLogsIntegRlvtEntity.JITLogsIntegRlvtEntity  -- association [0..1]
LEFT OUTER JOIN R_JITPackingGroupItemTP AS _JITPackingGroupItemTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_JITPackingGrpCellCnsmpnTP AS _JITPackingGrpCellCnsmpnTP ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN R_JITPackingGroupDocumentRefTP AS _JITPackingGroupDocumentRefTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_JITPackingGroupActionLogTP AS _JITPackingGroupActionLogTP ON /* condition not available in parsed metadata */  -- association [0..*]
;