C_JITSupplyControlHeaderTP

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_JITSupplyControlHeaderTP.
-- 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_JITSupplyControlHeaderTP AS
SELECT
  SupplyControlUUID,
  SupplyControlID,
  CustomerUUID,
  SupplyAreaUUID,
  _JITSupplyControlDescTP[1:Language = $session.system_language].SupplyControlDesc AS SupplyControlDesc,
  ShipToParty,
  I_JITSupplyControlHeaderTP._Customer.CustomerName AS BusinessPartnerName,
  I_JITSupplyControlHeaderTP._Customer.OrganizationBPName1 AS BusinessPartnerOrgLongName,
  _Customer._StandardAddress._Country._Text[1:Language = $session.system_language].CountryName AS CountryName,
  AddressID,
  I_JITSupplyControlHeaderTP._Customer.CityName AS CityName,
  Plant,
  I_JITSupplyControlHeaderTP._Plant.PlantName AS PlantName,
  I_JITSupplyControlHeaderTP._JITCustomerSupplyArea.UnloadingPointName AS UnloadingPointName,
  CustSupplyArea,
  _JITCustomerSupplyArea._JITCustomerSupplyAreaDesc[1:Language=$session.system_language].SupplyAreaDesc AS SupplyAreaDesc,
  Material,
  _Material._Text[1:Language = $session.system_language].ProductName AS ProductName,
  JITActionCtrl,
  _JITActionCtrl._Text[1:Language=$session.system_language].JITActionCtrlText AS JITActionCtrlText,
  JITCallType,
  _JITCallType._Text [1: Language = $session.system_language ].JITCallTypeText AS JITCallTypeText,
  JITSupplyControlStatus,
  _JITSupplyControlStatus._Text[1:Language = $session.system_language].JITSupplyControlStatusText AS JITSupplyControlStatusText,
  JITDelivConfControl,
  _JITDelivConfControl._Text [1: Language = $session.system_language ].JITDelivConfControlText AS JITDelivConfControlText,
  PartialDeliveryIsAllowed,
  _JITPartialDelivery._Text [1: Language = $session.system_language ].PartialDeliveryIsAllowedText AS PartialDeliveryIsAllowedText,
  JITUnlimitedOverDelivIsAllowed,
  JITUnderDeliveryToleranceInPct,
  JITOverDeliveryToleranceInPct,
  CreatedByUser,
  I_JITSupplyControlHeaderTP._CreatedByUser.FullName AS CreatedByUserDescription,
  I_JITSupplyControlHeaderTP._CreatedByUser.FirstName AS CreatedByUserFirstName,
  I_JITSupplyControlHeaderTP._CreatedByUser.LastName AS CreatedByUserLastName,
  CreationDateTime,
  LastChangedByUser,
  I_JITSupplyControlHeaderTP._LastChangedByUser.FullName AS LastChangedByUserDescription,
  I_JITSupplyControlHeaderTP._LastChangedByUser.FirstName AS FirstName,
  I_JITSupplyControlHeaderTP._LastChangedByUser.LastName AS LastName,
  LastChangeDateTime,
  JITLifeCycleStatusCriticality,
  RepetitiveManufacturingIsAllwd,
  _JITRepetitiveMfg._Text[1:Language = $session.system_language].RepetitiveMfgIsAllwdText AS RepetitiveMfgIsAllwdText,
  JITProdnConfirmationControl,
  SchedulingSchema,
  JITEntryPointForScheduling,
  _JITDelivSeqGrpEntryPoint._Text[1:Language = $session.system_language].JITEntryPointText AS JITEntryPointText,
  _JITProdnConfirmationControl._Text[1:Language = $session.system_language].JITProdnConfControlText AS JITProdnConfControlText,
  ProductionVersion,
  I_JITSupplyControlHeaderTP._ProductionVersion.ProductionVersionText AS ProductionVersionText,
  ProdnVersValidityStartDate,
  ProdnVersValidityEndDate,
  JITExternalProcessingStatus,
  _JITCustomerExtStatusDesc[1: Language = $session.system_language ].JITExternalStatusText AS JITExternalStatusText,
  I_JITSupplyControlHeaderTP._JITCustomerSupplyArea.CustAssemblyLoc AS CustAssemblyLoc,
  _JITSupplyControlCallType.JITCallIsSummarized AS JITCallIsSummarized
FROM I_JITSupplyControlHeaderTP
LEFT OUTER JOIN C_JITCustomerValueHelp AS _JITCustomerValueHelp ON CustomerUUID = _JITCustomerValueHelp.CustomerUUID  -- association [0..1]
LEFT OUTER JOIN C_JITPlantValueHelp AS _JITPlantValueHelp ON Plant = _JITPlantValueHelp.Plant  -- association [0..1]
LEFT OUTER JOIN C_JITCustSupplyAreaVH AS _JITCustSupplyAreaVH ON SupplyAreaUUID = _JITCustSupplyAreaVH.SupplyAreaUUID  -- association [0..1]
LEFT OUTER JOIN C_JITMaterialValueHelp AS _JITMaterialVH ON Material = _JITMaterialVH.Product AND Plant = _JITMaterialVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_JITCallTypeValueHelp AS _JITCallTypeValueHelp ON JITCallType = _JITCallTypeValueHelp.JITCallType  -- association [0..1]
LEFT OUTER JOIN C_JITActnCtrlCallTypeVH AS _JITActionCtrlVH ON JITActionCtrl = _JITActionCtrlVH.JITActionCtrl  -- association [0..*]
LEFT OUTER JOIN C_JITSupplyControlTolLvlTP AS _JITSupplyControlTolLvlTP ON SupplyControlUUID = _JITSupplyControlTolLvlTP.SupplyControlUUID  -- association [0..*]
LEFT OUTER JOIN C_JITSupplyControlDescTP AS _JITSupplyControlDescTP ON SupplyControlUUID = _JITSupplyControlDescTP.SupplyControlUUID  -- association [0..*]
LEFT OUTER JOIN C_JITSupplyControlDescTP AS _JITSupplyControlCurDescTP ON SupplyControlUUID = _JITSupplyControlCurDescTP.SupplyControlUUID AND _JITSupplyControlCurDescTP.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_JITCustContactPersonTP AS _JITContactPerson ON CustomerUUID = _JITContactPerson.CustomerUUID  -- association [0..*]
LEFT OUTER JOIN C_JITUnloadingPointValueHelp AS _JITUnloadingPointValueHelp ON ShipToParty = _JITUnloadingPointValueHelp.Customer AND unloadingpointname = _JITUnloadingPointValueHelp.UnloadingPointName  -- association [1..1]
LEFT OUTER JOIN C_JITSupplyControlOffsetTP AS _JITSupplyControlOffsetTP ON SupplyControlUUID = _JITSupplyControlOffsetTP.SupplyControlUUID  -- association [0..*]
LEFT OUTER JOIN C_JITSupplyControlVH AS _JITSupplyControlVH ON SupplyControlUUID = _JITSupplyControlVH.SupplyControlUUID  -- association [0..1]
LEFT OUTER JOIN C_JITSchedgSchemaForSumzdVH AS _JITSchedgSchemaForSumzdVH ON SchedulingSchema = _JITSchedgSchemaForSumzdVH.SchedulingSchema AND JITCallType = _JITSchedgSchemaForSumzdVH.JITCallType AND Plant = _JITSchedgSchemaForSumzdVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_JITDelivSeqGrpEntryPointVH AS _JITDelivSeqGrpEntryPointVH ON JITEntryPointForScheduling = _JITDelivSeqGrpEntryPointVH.JITEntryPoint  -- association [0..1]
LEFT OUTER JOIN C_JITShipToPartyAddressVH AS _JITShipToPartyAddressVH ON AddressID = _JITShipToPartyAddressVH.AddressID AND ShipToParty = _JITShipToPartyAddressVH.BusinessPartner  -- association [0..1]
;