R_JITSupplyControlHeaderTP

DDL: R_JITSUPPLYCONTROLHEADERTP Type: view_entity TRANSACTIONAL Package: NJIT_MODEL_SUPPLY_CONTROL
55 Fields 1 Data Sources 4 Associations

Just In Time Supply Control - TP

R_JITSupplyControlHeaderTP is a Transactional CDS View that provides data about "Just In Time Supply Control - TP" in SAP S/4HANA. It reads from 1 data source (I_JITSupplyControlHeader) and exposes 55 fields with key field SupplyControlUUID. It has 4 associations to related views. Part of development package NJIT_MODEL_SUPPLY_CONTROL.

Data Sources (1)

SourceAliasJoin Type
I_JITSupplyControlHeader I_JITSupplyControlHeader from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_JITDelivSeqGrpEntryPoint _JITDelivSeqGrpEntryPoint $projection.JITEntryPointForScheduling = _JITDelivSeqGrpEntryPoint.JITEntryPoint
[0..1] I_JITCallTypeEnhanced _JITSupplyControlCallType $projection.JITCallType = _JITSupplyControlCallType.JITCallType
[0..*] R_JITSupplyControlDescTP _JITSupplyControlDescTP
[0..*] R_JITSupplyControlTolLvlTP _JITSupplyControlTolLvlTP

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Just In Time Supply Control - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name JustInTimeSupplyControl view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY SupplyControlUUID SupplyControlUUID NodeID
SupplyControlID SupplyControlID Supply Control ID
ShipToParty ShipToParty Ship-To Party (obsolete)
CustomerUUID CustomerUUID NodeID
BusinessPartnerUUID BusinessPartnerUUID UUID
Plant Plant Valuation Area
CustSupplyArea CustSupplyArea Cust. Supply Area
SupplyAreaUUID SupplyAreaUUID NodeID
Material Material Vehicle Model
JITActionCtrl JITActionCtrl Action Control
JITCallType JITCallType Call Type
JITSupplyControlStatus JITSupplyControlStatus Sup. Cntrl. St.
PartialDeliveryIsAllowed PartialDeliveryIsAllowed Partial Deliv.
JITUnderDeliveryToleranceInPct JITUnderDeliveryToleranceInPct Undrdelvry Tolerance
JITOverDeliveryToleranceInPct JITOverDeliveryToleranceInPct Ovrdelivry Tolerance
JITUnlimitedOverDelivIsAllowed JITUnlimitedOverDelivIsAllowed Unlmt Ov Del
RepetitiveManufacturingIsAllwd RepetitiveManufacturingIsAllwd Repetitive Manufacturing Enabled
ProductionVersion ProductionVersion Version ID
JITExternalProcessingStatus JITExternalProcessingStatus External Status
JITProdnConfirmationControl JITProdnConfirmationControl Prodn Conf Ctrl
JITEntryPointForScheduling JITEntryPointForScheduling Entry Point
AddressID AddressID Ship-to address
SchedulingSchema SchedulingSchema Schema
JITDelivConfControl JITDelivConfControl Deliv Conf Control
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_JITSupplyControlDescTP _JITSupplyControlDescTP
_JITSupplyControlTolLvlTP _JITSupplyControlTolLvlTP
_BusinessPartnerAddress _BusinessPartnerAddress
_CreatedByUser _CreatedByUser
_Customer _Customer
_Description _Description
_JITActionCtrl _JITActionCtrl
_JITCallType _JITCallType
_JITCustomer _JITCustomer
_JITCustomerSupplyArea _JITCustomerSupplyArea
_JITDelivConfControl _JITDelivConfControl
_JITEntryPointForSchedg _JITEntryPointForSchedg
_JITPartialDelivery _JITPartialDelivery
_JITProdnConfirmationControl _JITProdnConfirmationControl
_JITRepetitiveMfg _JITRepetitiveMfg
_JITSchedulingSchema _JITSchedulingSchema
_JITSupplyControlOffset _JITSupplyControlOffset
_JITSupplyControlStatus _JITSupplyControlStatus
_LastChangedByUser _LastChangedByUser
_Material _Material
_Plant _Plant
_ProductionVersion _ProductionVersion
_SupplierExtStatus _SupplierExtStatus
_ToleranceLevel _ToleranceLevel
_JITDelivSeqGrpEntryPoint _JITDelivSeqGrpEntryPoint
_JITSupplyControlCallType _JITSupplyControlCallType
_ChangeDocument _ChangeDocument

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_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 R_JITSupplyControlHeaderTP AS
SELECT
  SupplyControlUUID,
  SupplyControlID,
  ShipToParty,
  CustomerUUID,
  BusinessPartnerUUID,
  Plant,
  CustSupplyArea,
  SupplyAreaUUID,
  Material,
  JITActionCtrl,
  JITCallType,
  JITSupplyControlStatus,
  PartialDeliveryIsAllowed,
  JITUnderDeliveryToleranceInPct,
  JITOverDeliveryToleranceInPct,
  JITUnlimitedOverDelivIsAllowed,
  RepetitiveManufacturingIsAllwd,
  ProductionVersion,
  JITExternalProcessingStatus,
  JITProdnConfirmationControl,
  JITEntryPointForScheduling,
  AddressID,
  SchedulingSchema,
  JITDelivConfControl,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_JITSupplyControlHeader
LEFT OUTER JOIN I_JITDelivSeqGrpEntryPoint AS _JITDelivSeqGrpEntryPoint ON JITEntryPointForScheduling = _JITDelivSeqGrpEntryPoint.JITEntryPoint  -- association [0..1]
LEFT OUTER JOIN I_JITCallTypeEnhanced AS _JITSupplyControlCallType ON JITCallType = _JITSupplyControlCallType.JITCallType  -- association [0..1]
LEFT OUTER JOIN R_JITSupplyControlDescTP AS _JITSupplyControlDescTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_JITSupplyControlTolLvlTP AS _JITSupplyControlTolLvlTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More