I_OrderTypeDetails
Order Type Details
I_OrderTypeDetails is a Basic CDS View (Dimension) that provides data about "Order Type Details" in SAP S/4HANA. It reads from 1 data source (t399x) and exposes 28 fields with key fields Plant, OrderType. It has 7 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| t399x | typ | from |
Associations (7)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_Plant | _Plant | $projection.Plant = _Plant.Plant |
| [0..1] | I_OrderCategory | _OrderCategory | $projection.OrderCategory = _OrderCategory.OrderCategory |
| [0..1] | I_BillOfOperationsType | _BillOfOperationsType | $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType |
| [0..1] | I_InspectionLotType | _InspectionLotType | $projection.InspectionLotType = _InspectionLotType.InspectionLotType |
| [0..1] | I_CostingVariant | _ActualCostsCostingVariant | $projection.ActualCostsCostingVariant = _ActualCostsCostingVariant.CostingVariant |
| [0..1] | I_CostingVariant | _PlannedCostsCostingVariant | $projection.PlannedCostsCostingVariant = _PlannedCostsCostingVariant.CostingVariant |
| [0..1] | I_LeadTimeReductionStrategy | _LeadTimeReductionStrategy | $projection.LeadTimeReductionStrategy = _LeadTimeReductionStrategy.LeadTimeReductionStrategy and $projection.Plant = _LeadTimeReductionStrategy.Plant |
Annotations (22)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IPPORDERTYPEDET | view | |
| AbapCatalog.buffering.status | #ACTIVE | view | |
| AbapCatalog.buffering.type | #FULL | view | |
| AbapCatalog.buffering.numberOfKeyFields | 000 | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| Analytics.internalName | #LOCAL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Consumption.ranked | true | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_DIMENSION | view | |
| ObjectModel.representativeKey | OrderType | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.dataClass | #CUSTOMIZING | view | |
| Search.searchable | true | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| VDM.viewType | #BASIC | view | |
| EndUserText.label | Order Type Details | view |
Fields (28)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Plant | t399x | werks | |
| KEY | OrderType | t399x | auart | |
| OrderCategory | ||||
| BillOfOperationsType | ||||
| SettlementDefaultRule | t399x | dfreg | ||
| VarianceKey | t399x | awsls | ||
| InspectionLotType | t399x | pruefart | ||
| BOMExplosionApplication | t399x | capid | ||
| PlannedCostsCostingVariant | t399x | klvarp | ||
| ActualCostsCostingVariant | t399x | klvari | ||
| BillOfOperationSelection | t399x | arbpa | ||
| ResultAnalysisInternalID | t399x | abgsl | ||
| LeadTimeReductionStrategy | t399x | rstra | ||
| AcctAssgmtIsDfndAtOpLvl | t399x | objnr_vorg | ||
| OrderIsNotCostedAutomatically | t399x | naucost | ||
| ProductCostCollectorIsCostObj | t399x | pkosa | ||
| ProductionVersionSelection | t399x | pvsel | ||
| StsChgDocIsActiveForHeader | ||||
| StsChgDocIsActiveForOperation | ||||
| StsChgDocIsActiveForComponent | ||||
| StsChgDocIsActiveForPRT | ||||
| _Plant | _Plant | |||
| _OrderCategory | _OrderCategory | |||
| _BillOfOperationsType | _BillOfOperationsType | |||
| _InspectionLotType | _InspectionLotType | |||
| _ActualCostsCostingVariant | _ActualCostsCostingVariant | |||
| _PlannedCostsCostingVariant | _PlannedCostsCostingVariant | |||
| _LeadTimeReductionStrategy | _LeadTimeReductionStrategy |
@AbapCatalog.sqlViewName: 'IPPORDERTYPEDET'
@AbapCatalog.buffering: {status: #ACTIVE, type: #FULL, numberOfKeyFields: 000}
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Consumption.ranked: true
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #SEARCHABLE_ENTITY]
@ObjectModel.representativeKey: 'OrderType'
@ObjectModel.semanticKey: ['Plant', 'OrderType']
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #S, dataClass: #CUSTOMIZING}
@Search.searchable: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Order Type Details'
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
define view I_OrderTypeDetails as select from t399x as typ
association [0..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association [0..1] to I_OrderCategory as _OrderCategory on $projection.OrderCategory = _OrderCategory.OrderCategory
association [0..1] to I_BillOfOperationsType as _BillOfOperationsType on $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
association [0..1] to I_InspectionLotType as _InspectionLotType on $projection.InspectionLotType = _InspectionLotType.InspectionLotType
association [0..1] to I_CostingVariant as _ActualCostsCostingVariant on $projection.ActualCostsCostingVariant = _ActualCostsCostingVariant.CostingVariant
association [0..1] to I_CostingVariant as _PlannedCostsCostingVariant on $projection.PlannedCostsCostingVariant = _PlannedCostsCostingVariant.CostingVariant
association [0..1] to I_LeadTimeReductionStrategy as _LeadTimeReductionStrategy on $projection.LeadTimeReductionStrategy = _LeadTimeReductionStrategy.LeadTimeReductionStrategy
and $projection.Plant = _LeadTimeReductionStrategy.Plant
{
@ObjectModel.foreignKey.association: '_Plant'
key typ.werks as Plant,
@Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
key typ.auart as OrderType,
@ObjectModel.foreignKey.association: '_OrderCategory'
cast(typ.autyp as pph_autyp preserving type) as OrderCategory,
@ObjectModel.foreignKey.association: '_BillOfOperationsType'
cast(typ.plnty as billofoperationstype preserving type) as BillOfOperationsType,
typ.dfreg as SettlementDefaultRule,
typ.awsls as VarianceKey,
@ObjectModel.foreignKey.association: '_InspectionLotType'
typ.pruefart as InspectionLotType,
typ.capid as BOMExplosionApplication,
@ObjectModel.foreignKey.association: '_PlannedCostsCostingVariant'
typ.klvarp as PlannedCostsCostingVariant,
@ObjectModel.foreignKey.association: '_ActualCostsCostingVariant'
typ.klvari as ActualCostsCostingVariant,
typ.arbpa as BillOfOperationSelection,
typ.abgsl as ResultAnalysisInternalID,
@ObjectModel.foreignKey.association: '_LeadTimeReductionStrategy'
typ.rstra as LeadTimeReductionStrategy,
typ.objnr_vorg as AcctAssgmtIsDfndAtOpLvl,
typ.naucost as OrderIsNotCostedAutomatically,
typ.pkosa as ProductCostCollectorIsCostObj,
typ.pvsel as ProductionVersionSelection,
cast(chgkz_head as vdm_chgkz_h preserving type) as StsChgDocIsActiveForHeader,
cast(chgkz_opr as vdm_chgkz_o preserving type) as StsChgDocIsActiveForOperation,
cast(chgkz_cmp as vdm_chgkz_c preserving type) as StsChgDocIsActiveForComponent,
cast(chgkz_prt as vdm_chgkz_p preserving type) as StsChgDocIsActiveForPRT,
// Associations
_Plant,
_OrderCategory,
_BillOfOperationsType,
_InspectionLotType,
_ActualCostsCostingVariant,
_PlannedCostsCostingVariant,
_LeadTimeReductionStrategy
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T399X"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONSTYPE",
"I_COSTINGVARIANT",
"I_INSPECTIONLOTTYPE",
"I_LEADTIMEREDUCTIONSTRATEGY",
"I_ORDERCATEGORY",
"I_PLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA