I_ORDERBASIC
Order Header Basic
I_ORDERBASIC is a CDS View in S/4HANA. Order Header Basic. It contains 43 fields. 11 CDS views read from this table.
CDS Views using this table (11)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_IntOrdSettlmtRuleNtwkActyVH | view_entity | inner | CONSUMPTION | Internal Order Settlement Rule Network activity |
| FINOC_RT_POI_FILL | view | inner | Orgl Change: Fill Runtime for Purg Doc | |
| I_ManufacturingOrderLongText | view_entity | inner | COMPOSITE | Manufacturing Order - Text |
| I_MfgOrderForExtraction | view | from | BASIC | Manufacturing Order |
| I_Order | view | from | BASIC | Order Header |
| I_OrderBasicVH | view_entity | from | COMPOSITE | Order Header |
| I_OrderComponent | view | inner | BASIC | Order Component |
| I_OrderConfirmation | view | inner | BASIC | Order Confirmation |
| I_QualityCostCollector | view | from | COMPOSITE | QM Order |
| P_CnsldtnOrder | view | from | COMPOSITE | |
| P_CnsldtnOrderT | view | from | COMPOSITE |
Fields (43)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | OrderID | OrderID | 1 |
| _BusinessArea | _BusinessArea | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _ControllingObjectClass | _ControllingObjectClass | 1 | |
| _CostCenter | _CostCenter | 1 | |
| _Currency | _Currency | 1 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _LongText | _LongText | 1 | |
| _OrderCategory | _OrderCategory | 2 | |
| _OrderHierarchyNode | _OrderHierarchyNode | 1 | |
| _OrderType | _OrderType | 2 | |
| _ProductCostCtrlgOrder | _ProductCostCtrlgOrder | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ResponsibleCostCenter | _ResponsibleCostCenter | 1 | |
| BusinessArea | BusinessArea | 2 | |
| CompanyCode | CompanyCode | 3 | |
| ConditionApplication | ConditionApplication | 1 | |
| ControllingArea | ControllingArea | 3 | |
| CostCenter | CostCenter | 1 | |
| CostElement | CostElement | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| Currency | Currency | 1 | |
| EventBasedPostingMethod | EventBasedPostingMethod | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| GLAccount | GLAccount | 1 | |
| IsMarkedForDeletion | IsMarkedForDeletion | 2 | |
| IsStatisticalOrder | IsStatisticalOrder | 1 | |
| LastChangeDate | LastChangeDate | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| LastChangeTime | LastChangeTime | 1 | |
| LongTextLanguage | LongTextLanguage | 1 | |
| ObjectInternalID | ObjectInternalID | 1 | |
| OrderCategory | ManufacturingOrderCategory,OrderCategory | 4 | |
| OrderDescription | ManufacturingOrderText,OrderDescription | 2 | |
| OrderHasLongText | ManufacturingOrderHasLongText,OrderHasLongText | 2 | |
| OrderType | ManufacturingOrderType,OrderType | 3 | |
| Plant | Plant | 1 | |
| ProductCostCollector | ProductCostCollector | 1 | |
| ProfitCenter | ProfitCenter | 2 | |
| ReferenceOrder | ReferenceOrder | 1 | |
| ResponsibleCostCenter | ResponsibleCostCenter | 1 | |
| TechnicalCompletionDate | MfgOrderActualCompletionDate | 1 |
@AbapCatalog.sqlViewName: 'IORDERBASIC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_CreatedByUser', '_LastChangedByUser', '_LongText']
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.representativeKey: 'OrderID'
@ObjectModel.semanticKey: ['OrderID']
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Order Header Basic'
// Basic view selecting from order header table AUFK only - without restriction on any category
// Due to the high number of consumers, this CDS view is protected against incompatible changes
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
define view I_OrderBasic
as select from aufk as aufk
association [1..1] to I_OrderCategory as _OrderCategory on $projection.OrderCategory = _OrderCategory.OrderCategory
association [1..1] to I_OrderType as _OrderType on $projection.OrderType = _OrderType.OrderType
association [0..1] to I_OrderLongText as _LongText on $projection.OrderID = _LongText.OrderID
association [1..1] to I_Order as _ReferenceOrder on $projection.ReferenceOrder= _ReferenceOrder.OrderID
association [1..1] to I_LogisticsOrderBasic as _LogisticsOrder on $projection.OrderID = _LogisticsOrder.OrderID
association [0..*] to I_OrderHierarchyNode as _OrderHierarchyNode on $projection.OrderID = _OrderHierarchyNode.OrderID
association [1..1] to I_User as _CreatedByUser on $projection.CreatedByUser = _CreatedByUser.UserID
association [0..1] to I_User as _LastChangedByUser on $projection.LastChangedByUser = _LastChangedByUser.UserID
association [0..1] to I_Currency as _Currency on $projection.Currency = _Currency.Currency
association [0..1] to I_Language as _LongTextLanguage on $projection.LongTextLanguage = _LongTextLanguage.Language
association [1..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association [1..1] to I_StatusObject as _StatusObject on $projection.ObjectInternalID = _StatusObject.StatusObject
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_CompanyCode as _RequestingCompanyCode on $projection.RequestingCompanyCode = _RequestingCompanyCode.CompanyCode
association [0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association [0..*] to I_ProfitCenter as _ProfitCenter on $projection.ControllingArea = _ProfitCenter.ControllingArea
and $projection.ProfitCenter = _ProfitCenter.ProfitCenter
association [0..*] to I_CostCenter as _CostCenter on $projection.ControllingArea = _CostCenter.ControllingArea
and $projection.CostCenter = _CostCenter.CostCenter
association [0..*] to I_CostCenter as _ResponsibleCostCenter on $projection.ControllingArea = _ResponsibleCostCenter.ControllingArea
and $projection.ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter
association [0..*] to I_CostCenter as _RequestingCostCenter on $projection.RequestingCostCenter = _RequestingCostCenter.CostCenter
and $projection.ControllingArea = _RequestingCostCenter.ControllingArea
association [0..1] to I_ProductCostCtrlgOrder as _ProductCostCtrlgOrder on $projection.ProductCostCollector = _ProductCostCtrlgOrder.OrderID
association [0..1] to I_GLAccount as _GLAccount on $projection.GLAccount = _GLAccount.GLAccount
and $projection.CompanyCode = _GLAccount.CompanyCode
association [0..1] to I_CostElement as _CostElement on $projection.ControllingArea = _CostElement.ControllingArea
and $projection.CostElement = _CostElement.CostElement
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [0..1] to I_ControllingObjectClass as _ControllingObjectClass on $projection.ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass
association [0..1] to I_FunctionalArea as _FunctionalArea on $projection.FunctionalArea = _FunctionalArea.FunctionalArea
association [0..1] to I_ConditionUsage as _ConditionUsage on $projection.ConditionUsage = _ConditionUsage.ConditionUsage
association [0..1] to I_ConditionApplication as _ConditionApplication on $projection.ConditionApplication = _ConditionApplication.ConditionApplication
association [0..1] to I_CostingSheetProcedure as _CostingSheetProcedure on $projection.ConditionUsage = _CostingSheetProcedure.ConditionUsage
and $projection.ConditionApplication = _CostingSheetProcedure.ConditionApplication
and $projection.CostingSheet = _CostingSheetProcedure.CostingSheetProcedure
association [0..1] to I_OrderProcessingGroup as _OrderProcessingGroup on $projection.ControllingArea = _OrderProcessingGroup.ControllingArea
and $projection.OrderProcessingGroup = _OrderProcessingGroup.OrderProcessingGroup
{
// Key
@ObjectModel.text.element: ['OrderDescription']
key aufk.aufnr as OrderID,
// Category and Type
@ObjectModel.foreignKey.association: '_OrderCategory'
cast(aufk.autyp as pph_autyp preserving type) as OrderCategory,
@ObjectModel.foreignKey.association: '_OrderType'
cast(aufk.auart as aufart preserving type) as OrderType,
// Text
@Semantics.text: true
cast(aufk.ktext as pph_auftext preserving type) as OrderDescription,
cast(case
when aufk.ltext is not initial then 'X'
else ''
end as aufltext preserving type) as OrderHasLongText,
@ObjectModel.foreignKey.association: '_LongTextLanguage'
cast(aufk.ltext as pph_longtextlang) as LongTextLanguage,
// Attributes
aufk.loekz as IsMarkedForDeletion,
aufk.astkz as IsStatisticalOrder,
cast(aufk.plint as fco_plint preserving type ) as OrdIsUsedInIntegratedPlanning,
// Admin
@Semantics.systemDate.createdAt: true
cast(aufk.erdat as ordercreationdate preserving type) as CreationDate,
@Semantics.systemTime.createdAt: true
cast(aufk.erfzeit as ordercreationtime preserving type) as CreationTime,
@Semantics.user.createdBy: true
aufk.ernam as CreatedByUser,
@Semantics.systemDate.lastChangedAt: true
aufk.aedat as LastChangeDate,
@Semantics.systemTime.lastChangedAt: true
aufk.aezeit as LastChangeTime,
@Semantics.user.lastChangedBy: true
aufk.aenam as LastChangedByUser,
// Assignments
@Semantics.currencyCode: true
aufk.waers as Currency,
@ObjectModel.foreignKey.association: '_ReferenceOrder'
cast(aufk.refnr as fis_aufrefnr preserving type) as ReferenceOrder,
@ObjectModel.foreignKey.association: '_Plant'
aufk.werks as Plant,
-- @ObjectModel.foreignKey.association: '_StatusObject'
cast(aufk.objnr as pph_objnr preserving type) as ObjectInternalID,
@ObjectModel.foreignKey.association: '_BusinessArea'
aufk.gsber as BusinessArea,
@ObjectModel.foreignKey.association: '_CompanyCode'
aufk.bukrs as CompanyCode,
@ObjectModel.foreignKey.association: '_RequestingCompanyCode'
aufk.abukr as RequestingCompanyCode,
@ObjectModel.foreignKey.association: '_ControllingArea'
aufk.kokrs as ControllingArea,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ProfitCenterStdVH', element: 'ProfitCenter' } } ]
aufk.prctr as ProfitCenter,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CostCenterStdVH', element: 'CostCenter' } } ]
aufk.kostl as CostCenter,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CostCenterStdVH', element: 'CostCenter' } } ]
aufk.akstl as RequestingCostCenter,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CostCenterStdVH', element: 'CostCenter' } } ]
cast(aufk.kostv as pph_kostl preserving type) as ResponsibleCostCenter,
@ObjectModel.foreignKey.association: '_CostElement'
cast(aufk.kstar as pph_kstar preserving type) as CostElement,
@ObjectModel.foreignKey.association: '_GLAccount'
aufk.saknr as GLAccount,
@ObjectModel.foreignKey.association: '_ProductCostCtrlgOrder'
aufk.pkosa as ProductCostCollector,
@ObjectModel.foreignKey.association: '_ConditionUsage'
aufk.kvewe as ConditionUsage,
@ObjectModel.foreignKey.association: '_ConditionApplication'
aufk.kappl as ConditionApplication,
@ObjectModel.foreignKey.association: '_CostingSheetProcedure'
aufk.kalsm as CostingSheet,
@ObjectModel.foreignKey.association: '_ControllingObjectClass'
cast(aufk.scope as pph_scope preserving type) as ControllingObjectClass,
@ObjectModel.foreignKey.association: '_FunctionalArea'
aufk.func_area as FunctionalArea,
@ObjectModel.foreignKey.association: '_OrderProcessingGroup'
cast(aufk.abkrs as fco_aufabkrs preserving type) as OrderProcessingGroup,
cast(aufk.zschl as fco_aufzschl preserving type) as OverheadCode,
cast(aufk.cycle as fins_st_kostl preserving type) as ActualPostedCostCenter,
cast(aufk.txjcd as fis_txjcd preserving type) as TaxJurisdiction,
cast(aufk.abgsl as fco_abgr_schl preserving type) as ResultAnalysisInternalID,
aufk.eb_post as EventBasedPostingMethod,
// Dates
aufk.pdat2 as PlannedCompletionDate,
aufk.idat2 as TechnicalCompletionDate,
// Associations
_OrderCategory,
_OrderType,
_ReferenceOrder,
_LogisticsOrder,
_OrderHierarchyNode,
_CreatedByUser,
_LastChangedByUser,
_LongText,
_LongTextLanguage,
_Currency,
_Plant,
_StatusObject,
_CompanyCode,
_RequestingCompanyCode,
_BusinessArea,
_ProfitCenter,
_CostCenter,
_RequestingCostCenter,
_ResponsibleCostCenter,
_ProductCostCtrlgOrder,
_CostElement,
_GLAccount,
_ControllingArea,
_ControllingObjectClass,
_FunctionalArea,
_ConditionUsage,
_ConditionApplication,
_CostingSheetProcedure,
_OrderProcessingGroup
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AUFK"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_CONDITIONAPPLICATION",
"I_CONDITIONUSAGE",
"I_CONTROLLINGAREA",
"I_CONTROLLINGOBJECTCLASS",
"I_COSTCENTER",
"I_COSTELEMENT",
"I_COSTINGSHEETPROCEDURE",
"I_CURRENCY",
"I_FUNCTIONALAREA",
"I_GLACCOUNT",
"I_LANGUAGE",
"I_LOGISTICSORDERBASIC",
"I_ORDER",
"I_ORDERCATEGORY",
"I_ORDERHIERARCHYNODE",
"I_ORDERLONGTEXT",
"I_ORDERPROCESSINGGROUP",
"I_ORDERTYPE",
"I_PLANT",
"I_PRODUCTCOSTCTRLGORDER",
"I_PROFITCENTER",
"I_STATUSOBJECT",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/