I_JITSupplyControlTolLvl

DDL: I_JITSUPPLYCONTROLTOLLVL Type: view_entity BASIC
10 Fields 1 Data Sources 1 Associations

JIT Supply Control Tolerance

I_JITSupplyControlTolLvl is a Basic CDS View (Dimension) that provides data about "JIT Supply Control Tolerance" in SAP S/4HANA. It reads from 1 data source (njit_d_sc_tollvl) and exposes 10 fields with key field SupplyControlToleranceUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
njit_d_sc_tollvl njit_d_sc_tollvl from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_JITToleranceDateType _JITToleranceDateType $projection.JITToleranceDateType = _JITToleranceDateType.JITToleranceDateType

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Analytics.dataCategory #DIMENSION view
EndUserText.label JIT Supply Control Tolerance view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey SupplyControlToleranceUUID view
ObjectModel.sapObjectNodeType.name JITSupplyControlTolLvl view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SupplyControlToleranceUUID supplycontroltoleranceuuid NodeID
JITToleranceDateType jittolerancedatetype Reminder Type
SupplyControlUUID supplycontroluuid NodeID
SupplyControlID supplycontrolid Supply Control ID
AlarmOffsetInDays alarmoffsetindays 2nd Offst Days
AlarmOffsetInHours alarmoffsetinhours 2nd Offst
WarningOffsetInDays warningoffsetindays 1st Rmndr Days
WarningOffsetInHours warningoffsetinhours 1st Rmndr Hours
_JITSupplyControlHeader _JITSupplyControlHeader
_JITToleranceDateType _JITToleranceDateType

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 I_JITSupplyControlTolLvl.
-- 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 I_JITSupplyControlTolLvl AS
SELECT
  SupplyControlToleranceUUID,
  JITToleranceDateType,
  SupplyControlUUID,
  SupplyControlID,
  AlarmOffsetInDays,
  AlarmOffsetInHours,
  WarningOffsetInDays,
  WarningOffsetInHours
FROM njit_d_sc_tollvl
LEFT OUTER JOIN I_JITToleranceDateType AS _JITToleranceDateType ON JITToleranceDateType = _JITToleranceDateType.JITToleranceDateType  -- association [0..1]
;

Learn More