C_SeqJITOutbDelivHeader

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_SeqJITOutbDelivHeader.
-- 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_SeqJITOutbDelivHeader AS
SELECT
  JITPckgGrpUUID,
  JITPckgGrpID,
  _JITPckgGrpDef.JITPckgGrpDefID AS JITPckgGrpDefID,
  _JITPckgGrpDef._PackageGroupDefinitionText[1: Language = $session.system_language].JITPckgGrpDesc AS JITPckgGrpDesc,
  JITPckgGrpDefUUID,
  CustomerUUID,
  ShipToParty,
  _JITShipToPartyValueHelp._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _JITShipToPartyValueHelp._CustomerToBusinessPartner._BusinessPartner.OrganizationBPName1 AS BusinessPartnerOrgLongName,
  _JITPckgGrpDef.PackagingMaterial AS PackagingMaterial,
  _JITPckgGrpDef._Product._Text[1: Language = $session.system_language].ProductName AS ProductName,
  Plant,
  _Plant.PlantName AS PlantName,
  _JITPckgGrpCnsmpnStsCnsldtd.TotalNumberOfCnsmdCellCnt AS TotalNumberOfCnsmdCellCnt,
  _JITPckgGrpDef.JITPckgRackSize AS JITPckgRackSize,
  ShippingPoint,
  _ShippingPointText[1: Language = $session.system_language].ShippingPointName AS ShippingPointName,
  UnloadingPointName,
  _JITPckgGrpStatus._Text[1: Language = $session.system_language].JITPckgGrpStatusTxt AS JITPckgGrpStatusTxt,
  JITPckgGrpStatus,
  cast ( 0 as brgew ) AS GrossWeight,
  WeightUnit,
  PlannedShippingDateTime,
  RequirementDateTime,
  DeliveryCreationDate,
  CustAssemblyLoc,
  CustSupplyArea,
  _JITCustomerSupplyArea._JITCustomerSupplyAreaDesc[1: Language = $session.system_language].SupplyAreaDesc AS SupplyAreaDesc,
  cast( '' as abap.char( 80 ) ) AS JITExtSequenceNumber,
  _Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  LastChangedByUser,
  CreatedByUser,
  CreationDateTime,
  ChangedOnDateTime,
  cast( ' ' as char40 ) AS DocRelationshipUUID,
  cast( ' ' as njit_comp_grp_mat) AS CompGrpMatl,
  cast ( 0 as abap.int4) AS NumberOfAlerts,
  cast( ' ' as njit_ext_call_num) AS ExternalJITCallNumber,
  JITAltvHndlgUnitID,
  JITAltvHndlgUnitIDShrt,
  _Customer.Country AS Country,
  _Customer.CityName AS CityName,
  cast( ' ' as njit_ext_comp_grp_num) AS ExtCompGrpNumber,
  _JITPckgGrpHandlingUnitRef.BusinessTransactionDocument AS BusinessTransactionDocument,
  cast(_JITPckgGrpHandlingUnitRef.BusinessTransactionDocument as abap.char( 20 )) AS HandlingUnitExternalID,
  _JITPckgGrpHandlingUnitRef.HandlingUnitProcessStatus AS HandlingUnitProcessStatus,
  _JITPckgGrpHandlingUnitRef._HandlingUnitProcessStatus._Text[1: Language = $session.system_language].HandlingUnitProcessStatusText AS HandlingUnitProcessStatusText
LEFT OUTER JOIN C_SeqJITOutbDelivItem AS _SeqJITOutbDelivItem ON JITPckgGrpUUID = _SeqJITOutbDelivItem.JITPckgGrpUUID  -- association [1..*]
LEFT OUTER JOIN C_JITShipToPartyValueHelp AS _JITShipToPartyValueHelp ON ShipToParty = _JITShipToPartyValueHelp.ShipToParty AND CustomerUUID = _JITShipToPartyValueHelp.CustomerUUID  -- association [0..1]
LEFT OUTER JOIN C_JITShippingPointVH AS _ShippingPointVH ON ShippingPoint = _ShippingPointVH.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN C_JITUnloadingPointValueHelp AS _JITUnloadingPointValueHelp ON ShipToParty = _JITUnloadingPointValueHelp.Customer AND UnloadingPointName = _JITUnloadingPointValueHelp.UnloadingPointName  -- association [0..1]
LEFT OUTER JOIN C_JITCustSupplyAreaVH AS _JITCustSupplyAreaVH ON ShipToParty = _JITCustSupplyAreaVH.ShipToParty AND CustSupplyArea = _JITCustSupplyAreaVH.CustSupplyArea  -- association [0..1]
LEFT OUTER JOIN C_JITPckgGrpIDVH AS _JITPckgGrpIDVH ON JITPckgGrpID = _JITPckgGrpIDVH.JITPckgGrpID  -- association [0..*]
LEFT OUTER JOIN C_JITMaterialValueHelp AS _JITMaterialVH ON CompGrpMatl = _JITMaterialVH.Product AND Plant = _JITMaterialVH.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_JITPckgGrpStatus AS _JITPckgGrpStatus ON JITPckgGrpStatus = _JITPckgGrpStatus.JITPckgGrpStatus  -- association [0..1]
LEFT OUTER JOIN E_JITPckgGrpHeader AS _JITPckgGrpHeaderExtension ON JITPckgGrpUUID = _JITPckgGrpHeaderExtension.JITPckgGrpUUID  -- association [0..1]
LEFT OUTER JOIN C_JITCustContactPersonTP AS _JITContactPerson ON ShipToParty = _JITContactPerson.ShipToParty  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _Customer ON ShipToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN C_JITPckgGrpHandlingUnitRef AS _JITPckgGrpHandlingUnitRef ON JITPckgGrpUUID = _JITPckgGrpHandlingUnitRef.JITPckgGrpUUID  -- association [0..1]
LEFT OUTER JOIN I_JITPckgGrpDefHier AS _JITPckgGrpDefHier ON JITPckgGrpDefUUID = _JITPckgGrpDefHier.JITChildPckgGrpDefUUID  -- association [0..1]
LEFT OUTER JOIN I_JITCallCompGroupBasic AS _JITCallCompGroup ON JITPckgGrpUUID = _JITCallCompGroup.JITSuperPckgGrpUUID  -- association [0..*]
;