I_OrderTypeDetails

DDL: I_ORDERTYPEDETAILS SQL: IPPORDERTYPEDET Type: view BASIC

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)

SourceAliasJoin Type
t399x typ from

Associations (7)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/