I_JITPckgGrpHeader

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_JITPckgGrpHeader.
-- 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_JITPckgGrpHeader AS
SELECT
  db_key AS JITPckgGrpUUID,
  pckg_grp_def_uuid AS JITPckgGrpDefUUID,
  pckg_grp_id AS JITPckgGrpID,
  status AS JITPckgGrpStatus,
  kunnr AS ShipToParty,
  ablad AS UnloadingPointName,
  vstel AS ShippingPoint,
  planned_shipping_dt AS PlannedShippingDateTime,
  requirement_date AS RequirementDateTime,
  ledat AS DeliveryCreationDate,
  DeliveryCreationTime,
  MaterialAvailabilityDateTime,
  ProductionStartDate,
  ProductionEndDate,
  gross_weight AS GrossWeight,
  gewei AS WeightUnit,
  cust_sup_area AS CustSupplyArea,
  fldpo AS CustAssemblyLoc,
  werks AS Plant,
  crea_date_time AS CreationDateTime,
  crea_uname AS CreatedByUser,
  lchg_date_time AS ChangedOnDateTime,
  lchg_uname AS LastChangedByUser,
  JITComponentIsReordered,
  JITPackageLevel,
  hu_stat AS HandlingUnitStatus,
  lgort AS StorageLocation,
  JITPackingGroupIsNested,
  JITArchivingStatus,
  CustomerUUID,
  JITAltvHndlgUnitID,
  JITAltvHndlgUnitIDShrt,
  RepetitiveManufacturingIsAllwd,
  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,
  JITDelivSqncGrpID,
  JITDelivSqncGrpUUID,
  JITExtSequenceNumberFrom,
  JITExtSequenceNumberTo,
  JITFormattedSequenceNmbrFrom,
  JITFormattedSequenceNmbrTo,
  JITExtStatusUpdtdOn,
  JITIntStatusUpdtdOn
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_JITPckgGrpHandlingUnitRef AS _JITPckgGrpHandlingUnitRef ON JITPckgGrpUUID = _JITPckgGrpHandlingUnitRef.JITPckgGrpUUID  -- association [0..1]
LEFT OUTER JOIN I_JITPackingGroupIsNested AS _JITPackingGroupIsNested ON JITPackingGroupIsNested = _JITPackingGroupIsNested.JITPackingGroupIsNested  -- association [0..1]
LEFT OUTER JOIN I_JITCallCompGroupBasic AS _JITCallCompGroupBasic ON JITPckgGrpUUID = _JITCallCompGroupBasic.JITSuperPckgGrpUUID  -- association [0..*]
LEFT OUTER JOIN I_JITPckgGrpDeliveryRef AS _JITPckgGrpDeliveryRef ON JITPckgGrpUUID = _JITPckgGrpDeliveryRef.JITPckgGrpUUID  -- association [0..1]
LEFT OUTER JOIN I_JITInbCallComponentGroup AS _JITInbCallComponentGroup ON JITPckgGrpUUID = _JITInbCallComponentGroup.JITSuperPckgGrpUUID  -- association [0..*]
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 _JITDelivSqncGrpHeaderBasic ON JITDelivSqncGrpUUID = _JITDelivSqncGrpHeaderBasic.JITDelivSqncGrpUUID  -- association [0..1]
LEFT OUTER JOIN I_JITDeliveryStatus AS _JITDeliveryStatus ON DeliveryStatus = _JITDeliveryStatus.DeliveryStatus  -- association [0..1]
LEFT OUTER JOIN I_JITGoodsMovementStatus AS _JITGoodsMovementStatus ON GoodsMovementStatus = _JITGoodsMovementStatus.GoodsMovementStatus  -- association [0..1]
LEFT OUTER JOIN I_JITBillingStatus AS _JITBillingStatus ON JITBillingStatus = _JITBillingStatus.JITBillingStatus  -- association [0..1]
LEFT OUTER JOIN I_JITReleaseToProductionStatus AS _JITReleaseToProductionStatus ON JITReleaseToProductionStatus = _JITReleaseToProductionStatus.JITReleaseToProductionStatus  -- association [0..1]
LEFT OUTER JOIN I_JITProdnConfirmationStatus AS _JITProdnConfirmationStatus ON JITProdnConfirmationStatus = _JITProdnConfirmationStatus.JITProdnConfirmationStatus  -- association [0..1]
LEFT OUTER JOIN I_JITReleaseToPackingStatus AS _JITReleaseToPackingStatus ON JITReleaseForPackingStatus = _JITReleaseToPackingStatus.JITReleaseToPackingStatus  -- association [0..1]
LEFT OUTER JOIN I_JITPackingConfStatus AS _JITPackingConfStatus ON JITPackingConfirmationStatus = _JITPackingConfStatus.JITPackingConfirmationStatus  -- association [0..1]
LEFT OUTER JOIN I_JITHndlgUnitCrtnStatus AS _JITHndlgUnitCrtnStatus ON HandlingUnitStatus = _JITHndlgUnitCrtnStatus.HandlingUnitStatus  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_JITArchivingStatus AS _JITArchivingStatus ON JITArchivingStatus = _JITArchivingStatus.JITArchivingStatus  -- association [0..1]
LEFT OUTER JOIN I_JITPckgGrpItem AS _JITPckgGrpItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITPckgGrpCellCnsmpnSts AS _JITPckgGrpCellCnsmpnSts ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITPckgGrpDocRefBasic AS _JITPckgGrpDocRefBasic ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITPckgGrpActionLogBasic AS _JITPckgGrpActionLogBasic ON /* condition not available in parsed metadata */  -- association [0..*]
;