C_JITSupplyControlOffsetTP

DDL: C_JITSUPPLYCONTROLOFFSETTP Type: view_entity CONSUMPTION
8 Fields 1 Data Sources 1 Associations

Consumption view for JIT Supply Control Offst

C_JITSupplyControlOffsetTP is a Consumption CDS View that provides data about "Consumption view for JIT Supply Control Offst" in SAP S/4HANA. It reads from 1 data source (I_JITSupplyControlOffsetTP) and exposes 8 fields with key field SupplyControlOffsetUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITSupplyControlOffsetTP I_JITSupplyControlOffsetTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_JITSupplyControlHeaderTP _JITSupplyControlHeaderTP $projection.SupplyControlUUID = _JITSupplyControlHeaderTP.SupplyControlUUID

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Consumption view for JIT Supply Control Offst view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey SupplyControlOffsetUUID view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
Analytics.technicalName CJITSCOFFSTTP view
UI.headerInfo.typeNamePlural Offset view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SupplyControlOffsetUUID SupplyControlOffsetUUID NodeID
JITOffsetType JITOffsetType Offset Type
SupplyControlUUID SupplyControlUUID NodeID
OffsetInDays OffsetInDays Offset In Days
OffsetInHours OffsetInHours Offset In Hours
JITOffsetTypeText
_JITOffsetType _JITOffsetType
_JITSupplyControlHeaderTP _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_JITSupplyControlOffsetTP.
-- 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_JITSupplyControlOffsetTP AS
SELECT
  SupplyControlOffsetUUID,
  JITOffsetType,
  SupplyControlUUID,
  OffsetInDays,
  OffsetInHours,
  _JITOffsetType._Text[1:Language = $session.system_language].JITOffsetTypeText AS JITOffsetTypeText
FROM I_JITSupplyControlOffsetTP
LEFT OUTER JOIN C_JITSupplyControlHeaderTP AS _JITSupplyControlHeaderTP ON SupplyControlUUID = _JITSupplyControlHeaderTP.SupplyControlUUID  -- association [1..1]
;

Learn More