C_JITSupplyControlHeaderTP_2

DDL: C_JITSUPPLYCONTROLHEADERTP_2 Type: view_entity CONSUMPTION Package: NJIT_MODEL_SUPPLY_CONTROL
68 Fields 1 Data Sources 4 Associations 1 OData Services

Just In Time Supply Control

C_JITSupplyControlHeaderTP_2 is a Consumption CDS View that provides data about "Just In Time Supply Control" in SAP S/4HANA. It reads from 1 data source (R_JITSupplyControlHeaderTP) and exposes 68 fields with key field SupplyControlUUID. It has 4 associations to related views. It is exposed through 1 OData service (NJIT_UI_JITSUPPLYCONTROL). Part of development package NJIT_MODEL_SUPPLY_CONTROL.

Data Sources (1)

SourceAliasJoin Type
R_JITSupplyControlHeaderTP R_JITSupplyControlHeaderTP projection

Associations (4)

CardinalityTargetAliasCondition
[0..1] C_JITShipToPartyQuickView _JITShipToPartyQuickView $projection.ShipToParty = _JITShipToPartyQuickView.ShipToParty
[0..1] C_JITSchedgSchemaForSumzdVH _JITSchedgSchemaForSumzdVH $projection.SchedulingSchema = _JITSchedgSchemaForSumzdVH.SchedulingSchema and $projection.JITCallType = _JITSchedgSchemaForSumzdVH.JITCallType and $projection.Plant = _JITSchedgSchemaForSumzdVH.Plant
[0..1] C_JITDelivSeqGrpEntryPointVH _JITDelivSeqGrpEntryPointVH $projection.JITEntryPointForScheduling = _JITDelivSeqGrpEntryPointVH.JITEntryPoint
[0..*] C_JITShipToPartyAddressVH _JITShipToPartyAddressVH $projection.AddressID = _JITShipToPartyAddressVH.AddressID and $projection.ShipToParty = _JITShipToPartyAddressVH.BusinessPartner

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Just In Time Supply Control view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
UI.headerInfo.typeName Just-In-Time Supply Control view
UI.headerInfo.typeNamePlural Supply Controls view
UI.headerInfo.title.value SupplyControlID view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.description.value SupplyControlDesc view
Search.searchable true view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
NJIT_UI_JITSUPPLYCONTROL

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY SupplyControlUUID SupplyControlUUID NodeID
SupplyControlID SupplyControlID Supply Control ID
CustomerUUID CustomerUUID NodeID
SupplyAreaUUID SupplyAreaUUID NodeID
SupplyControlDesc
ShipToParty ShipToParty Ship-To Party (obsolete)
BusinessPartnerName _Customer CustomerName Name of Customer
BusinessPartnerOrgLongName _Customer OrganizationBPName1 Name 1
CountryName
AddressID AddressID Ship-to address
CityName _Customer CityName Name
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
UnloadingPointName _JITCustomerSupplyArea UnloadingPointName Unloading Point Name
CustSupplyArea CustSupplyArea Cust. Supply Area
SupplyAreaDesc
Material Material Vehicle Model
ProductName
JITActionCtrl JITActionCtrl Action Control
JITActionCtrlText
JITCallType JITCallType Call Type
JITCallTypeText
JITSupplyControlStatus JITSupplyControlStatus Sup. Cntrl. St.
JITSupplyControlStatusText
JITDelivConfControl JITDelivConfControl Deliv Conf Control
JITDelivConfControlText
PartialDeliveryIsAllowed PartialDeliveryIsAllowed Partial Deliv.
PartialDeliveryIsAllowedText
JITUnlimitedOverDelivIsAllowed JITUnlimitedOverDelivIsAllowed Unlmt Ov Del
JITUnderDeliveryToleranceInPct JITUnderDeliveryToleranceInPct Undrdelvry Tolerance
JITOverDeliveryToleranceInPct JITOverDeliveryToleranceInPct Ovrdelivry Tolerance
CreatedByUser CreatedByUser User Name
CreatedByUserDescription _CreatedByUser FullName Name
CreatedByUserFirstName _CreatedByUser FirstName First Name
CreatedByUserLastName _CreatedByUser LastName Last Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserDescription _LastChangedByUser FullName Name
FirstName _LastChangedByUser FirstName First Name
LastName _LastChangedByUser LastName Last Name
LastChangeDateTime LastChangeDateTime Timestamp
RepetitiveManufacturingIsAllwd RepetitiveManufacturingIsAllwd Repetitive Manufacturing Enabled
RepetitiveMfgIsAllwdText
JITProdnConfirmationControl JITProdnConfirmationControl Prodn Conf Ctrl
SchedulingSchema SchedulingSchema Schema
JITEntryPointForScheduling JITEntryPointForScheduling Entry Point
JITEntryPointText
JITProdnConfControlText
ProductionVersion ProductionVersion Version ID
ProductionVersionText _ProductionVersion ProductionVersionText
JITExternalProcessingStatus JITExternalProcessingStatus External Status
JITExternalStatusText
CustAssemblyLoc _JITCustomerSupplyArea CustAssemblyLoc Assembly Location
JITCallIsSummarized _JITSupplyControlCallType JITCallIsSummarized
int1
dats
dats
_JITPartialDelivery _JITPartialDelivery
_Customer _Customer
_ProductionVersion _ProductionVersion
_JITRepetitiveMfg _JITRepetitiveMfg
_JITProdnConfirmationControl _JITProdnConfirmationControl
_JITDelivSeqGrpEntryPoint _JITDelivSeqGrpEntryPoint
_JITDelivConfControl _JITDelivConfControl
_JITSchedgSchemaForSumzdVH _JITSchedgSchemaForSumzdVH
_JITShipToPartyQuickView _JITShipToPartyQuickView
_JITDelivSeqGrpEntryPointVH _JITDelivSeqGrpEntryPointVH
_JITShipToPartyAddressVH _JITShipToPartyAddressVH

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_2.
-- 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_2 AS
SELECT
  SupplyControlUUID,
  SupplyControlID,
  CustomerUUID,
  SupplyAreaUUID,
  _JITSupplyControlDescTP[1:Language = $session.system_language].SupplyControlDesc AS SupplyControlDesc,
  ShipToParty,
  _Customer.CustomerName AS BusinessPartnerName,
  _Customer.OrganizationBPName1 AS BusinessPartnerOrgLongName,
  _Customer._StandardAddress._Country._Text[1:Language = $session.system_language].CountryName AS CountryName,
  AddressID,
  _Customer.CityName AS CityName,
  Plant,
  _Plant.PlantName AS PlantName,
  _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,
  _CreatedByUser.FullName AS CreatedByUserDescription,
  _CreatedByUser.FirstName AS CreatedByUserFirstName,
  _CreatedByUser.LastName AS CreatedByUserLastName,
  CreationDateTime,
  LastChangedByUser,
  _LastChangedByUser.FullName AS LastChangedByUserDescription,
  _LastChangedByUser.FirstName AS FirstName,
  _LastChangedByUser.LastName AS LastName,
  LastChangeDateTime,
  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,
  _ProductionVersion.ProductionVersionText AS ProductionVersionText,
  JITExternalProcessingStatus,
  _SupplierExtStatus._JITExternalStatusText [1: Language = $session.system_language ].JITExternalStatusText AS JITExternalStatusText,
  _JITCustomerSupplyArea.CustAssemblyLoc AS CustAssemblyLoc,
  _JITSupplyControlCallType.JITCallIsSummarized AS JITCallIsSummarized,
  virtual JITLifeCycleStatusCriticality : abap.int1 AS int1,
  virtual ProdnVersValidityStartDate: abap.dats AS dats
FROM R_JITSupplyControlHeaderTP
LEFT OUTER JOIN C_JITShipToPartyQuickView AS _JITShipToPartyQuickView ON ShipToParty = _JITShipToPartyQuickView.ShipToParty  -- 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..*]
;

Learn More