I_OIL_TransptDisallowedMatl

DDL: I_OIL_TRANSPTDISALLOWEDMATL Type: view_entity BASIC
16 Fields 1 Data Sources 3 Associations

Disallowed Material Sequence

I_OIL_TransptDisallowedMatl is a Basic CDS View that provides data about "Disallowed Material Sequence" in SAP S/4HANA. It reads from 1 data source (oijtsmatseq) and exposes 16 fields with key fields TransportSystem, FromMaterialNumber, ToMaterialNumber. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
oijtsmatseq oijtsmatseq from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_OIL_TransportSystem _TransportSystem _TransportSystem.TransportSystem = $projection.TransportSystem
[1..1] I_Material _MaterialFrom _MaterialFrom.Material = $projection.FromMaterialNumber
[1..1] I_Material _MaterialTo _MaterialTo.Material = $projection.ToMaterialNumber

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Disallowed Material Sequence view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
ObjectModel.sapObjectNodeType.name OIL_BulkTransptDisallowedMatl view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY TransportSystem tsyst Trans system
KEY FromMaterialNumber pmatnr_f From material number
KEY ToMaterialNumber pmatnr_t To material number
SystemMessageType msgty Msg.Type (E,I,W..)
CreationDate erdat Entered On
CreationTime erzeit Time created
CreatedByUser ernam User Name
LastChangeDate aedat Obsolete
LastChangeTime aezeit Time changed
LastChangedByUser aenam User Name
IsBlocked bloind Single-Character Flag
IsDeleted delind Will be Deleted
TicketIsSelectable tktselect Flag to Select Tkt
_TransportSystem _TransportSystem
_MaterialFrom _MaterialFrom
_MaterialTo _MaterialTo

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_OIL_TransptDisallowedMatl.
-- 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_OIL_TransptDisallowedMatl AS
SELECT
  tsyst AS TransportSystem,
  pmatnr_f AS FromMaterialNumber,
  pmatnr_t AS ToMaterialNumber,
  msgty AS SystemMessageType,
  erdat AS CreationDate,
  erzeit AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  aenam AS LastChangedByUser,
  bloind AS IsBlocked,
  delind AS IsDeleted,
  tktselect AS TicketIsSelectable
FROM oijtsmatseq
LEFT OUTER JOIN I_OIL_TransportSystem AS _TransportSystem ON _TransportSystem.TransportSystem = TransportSystem  -- association [1..1]
LEFT OUTER JOIN I_Material AS _MaterialFrom ON _MaterialFrom.Material = FromMaterialNumber  -- association [1..1]
LEFT OUTER JOIN I_Material AS _MaterialTo ON _MaterialTo.Material = ToMaterialNumber  -- association [1..1]
;

Learn More