I_InternalOrderType

DDL: I_INTERNALORDERTYPE SQL: IFIINTORDTYPE Type: view BASIC
8 Fields 1 Data Sources 1 Associations

Internal Order Type

I_InternalOrderType is a Basic CDS View (Dimension) that provides data about "Internal Order Type" in SAP S/4HANA. It reads from 1 data source (t003o) and exposes 8 fields with key field OrderType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
t003o t003o from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_InternalOrderTypeText _Text $projection.OrderType = _Text.OrderType

Annotations (17)

NameValueLevelField
EndUserText.label Internal Order Type view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFIINTORDTYPE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey OrderType view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 1 view
AbapCatalog.buffering.status #ACTIVE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY OrderType auart Sales Doc. Type
RevenuePostingIsAllowed erloese Revenues
OrderCategory autyp Order category
CommitmentsMgmtActvtnStatus Commt Update
StatusProfile stsma Status Profile
ResidenceTime1 resz1 Residence Time1
ResidenceTime2 resz2 Residence Time2
_Text _Text

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_InternalOrderType.
-- 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.
-- SQL view name: IFIINTORDTYPE

CREATE VIEW I_InternalOrderType AS
SELECT
  auart AS OrderType,
  erloese AS RevenuePostingIsAllowed,
  autyp AS OrderCategory,
  cast( obligo as fins_co_obligo preserving type ) AS CommitmentsMgmtActvtnStatus,
  stsma AS StatusProfile,
  resz1 AS ResidenceTime1,
  resz2 AS ResidenceTime2
FROM t003o
LEFT OUTER JOIN I_InternalOrderTypeText AS _Text ON OrderType = _Text.OrderType  -- association [0..*]
;

Learn More