I_InternalOrder
Internal Order
I_InternalOrder is a Basic CDS View (Dimension) that provides data about "Internal Order" in SAP S/4HANA. It reads from 1 data source (aufk) and exposes 128 fields with key field InternalOrder. It has 52 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| aufk | aufk | from |
Associations (52)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_ControllingArea | _ControllingAreaText | $projection.ControllingArea = _ControllingAreaText.ControllingArea |
| [0..*] | I_InternalOrderTypeText | _InternalOrderTypeText | $projection.OrderType = _InternalOrderTypeText.OrderType |
| [0..1] | I_ControllingArea | _ControllingArea | $projection.ControllingArea = _ControllingArea.ControllingArea |
| [0..1] | I_CompanyCode | _CompanyCode | $projection.CompanyCode = _CompanyCode.CompanyCode |
| [0..*] | I_ProfitCenter | _ProfitCenter | $projection.ControllingArea = _ProfitCenter.ControllingArea and $projection.ProfitCenter = _ProfitCenter.ProfitCenter |
| [0..1] | I_FunctionalArea | _FunctionalArea | $projection.FunctionalArea = _FunctionalArea.FunctionalArea |
| [0..1] | I_ControllingObjectClass | _ControllingObjectClass | $projection.ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass |
| [0..1] | I_InternalOrderType | _InternalOrderType | $projection.OrderType = _InternalOrderType.OrderType |
| [0..*] | I_CostCenter | _CostCenter | $projection.ControllingArea = _CostCenter.ControllingArea and $projection.ResponsibleCostCenter = _CostCenter.CostCenter |
| [0..*] | I_InternalOrderSystemStatus | _SystemStatus | $projection.ControllingObject = _SystemStatus.ControllingObject |
| [1..1] | E_LogisticsOrder | _Extension | $projection.InternalOrder = _Extension.OrderID |
| [0..*] | I_ProfitCenterText | _CurProfitCenterText | $projection.ControllingArea = _CurProfitCenterText.ControllingArea and $projection.ProfitCenter = _CurProfitCenterText.ProfitCenter and _CurProfitCenterText.ValidityStartDate <= $session.system_date and _CurProfitCenterText.ValidityEndDate >= $session.system_date |
| [0..1] | I_Plant | _Plant | $projection.Plant = _Plant.Plant |
| [0..1] | I_User | _User | $projection.InternalOrderResponsibleUser = _User.UserID |
| [0..1] | I_BusinessArea | _BusinessArea | $projection.BusinessArea = _BusinessArea.BusinessArea |
| [0..1] | I_Currency | _Currency | $projection.Currency = _Currency.Currency |
| [0..1] | I_OrderCategory | _OrderCategory | $projection.OrderCategory = _OrderCategory.OrderCategory |
| [0..*] | I_CostCenterText | _CurRespCostCenterText | $projection.ControllingArea = _CurRespCostCenterText.ControllingArea and $projection.ResponsibleCostCenter = _CurRespCostCenterText.CostCenter and _CurRespCostCenterText.ValidityStartDate <= $session.system_date and _CurRespCostCenterText.ValidityEndDate >= $session.system_date |
| [0..1] | I_WBSElementBasicData | _WBSElementBasicData | $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID |
| [0..*] | I_CostCenter | _RequestingCostCenter | $projection.RequestingCostCenter = _RequestingCostCenter.CostCenter and $projection.ControllingArea = _RequestingCostCenter.ControllingArea |
| [0..*] | I_CostCenterText | _CurRequestingCostCenterText | $projection.ControllingArea = _CurRequestingCostCenterText.ControllingArea and $projection.RequestingCostCenter = _CurRequestingCostCenterText.CostCenter and _CurRequestingCostCenterText.ValidityStartDate <= $session.system_date and _CurRequestingCostCenterText.ValidityEndDate >= $session.system_date |
| [0..1] | I_CompanyCode | _RequestingCompanyCode | $projection.RequestingCompanyCode = _RequestingCompanyCode.CompanyCode |
| [0..1] | I_Order | _RequestingOrder | $projection.RequestingOrder = _RequestingOrder.OrderID |
| [0..1] | I_Location | _Location | $projection.InternalOrderLocation = _Location.Location and $projection.LocationPlant = _Location.Plant |
| [0..1] | I_Plant | _LocationPlant | $projection.LocationPlant = _LocationPlant.Plant |
| [0..*] | I_CostCenter | _ActualPostedCostCenter | $projection.ControllingArea = _ActualPostedCostCenter.ControllingArea and $projection.ActualPostedCostCenter = _ActualPostedCostCenter.CostCenter |
| [0..*] | I_CostCenterText | _CurActualPostedCostCenterText | $projection.ControllingArea = _CurActualPostedCostCenterText.ControllingArea and $projection.ActualPostedCostCenter = _CurActualPostedCostCenterText.CostCenter and _CurActualPostedCostCenterText.ValidityStartDate <= $session.system_date and _CurActualPostedCostCenterText.ValidityEndDate >= $session.system_date |
| [0..*] | I_CostCenter | _CostCenterData | $projection.ControllingArea = _CostCenterData.ControllingArea and $projection.CostCenter = _CostCenterData.CostCenter |
| [0..*] | I_CostCenterText | _CurCostCenterDataText | $projection.ControllingArea = _CurCostCenterDataText.ControllingArea and $projection.CostCenter = _CurCostCenterDataText.CostCenter and _CurCostCenterDataText.ValidityStartDate <= $session.system_date and _CurCostCenterDataText.ValidityEndDate >= $session.system_date |
| [0..1] | I_LogicalSystem | _LogicalSystem | $projection.LogicalSystem = _LogicalSystem.LogicalSystem |
| [0..1] | I_ConditionUsage | _ConditionUsage | $projection.ConditionUsage = _ConditionUsage.ConditionUsage |
| [0..1] | I_ConditionApplication | _ConditionApplication | $projection.ConditionApplication = _ConditionApplication.ConditionApplication |
| [0..1] | I_CostingSheetProcedure | _CostingSheetProcedure | $projection.ConditionUsage = _CostingSheetProcedure.ConditionUsage and $projection.ConditionApplication = _CostingSheetProcedure.ConditionApplication and $projection.CostingSheet = _CostingSheetProcedure.CostingSheetProcedure |
| [0..*] | I_CostElementOnControllingArea | _IntOrderSettlementCostElement | $projection.ControllingArea = _IntOrderSettlementCostElement.ControllingArea and $projection.IntOrderSettlementCostElement = _IntOrderSettlementCostElement.CostElement |
| [0..1] | I_GLAccountInCompanyCode | _BasicSettlementGLAccount | $projection.CompanyCode = _BasicSettlementGLAccount.CompanyCode and $projection.BasicSettlementGLAccount = _BasicSettlementGLAccount.GLAccount |
| [0..1] | I_OrderProcessingGroup | _OrderProcessingGroup | $projection.ControllingArea = _OrderProcessingGroup.ControllingArea and $projection.OrderProcessingGroup = _OrderProcessingGroup.OrderProcessingGroup |
| [0..1] | I_InvestmentProfile | _InvestmentProfile | $projection.InvestmentProfile = _InvestmentProfile.InvestmentProfile |
| [0..1] | I_InvestmentReason | _InvestmentReason | $projection.InvestmentReason = _InvestmentReason.InvestmentReason |
| [0..1] | I_EnvrnmtlInvestmentReason | _EnvrnmtlInvestmentReason | $projection.EnvironmentalInvestmentReason = _EnvrnmtlInvestmentReason.EnvrnmtlInvestmentReason |
| [0..1] | I_JointVentureMaster | _JointVentureMaster | $projection.CompanyCode = _JointVentureMaster.CompanyCode and $projection.JointVenture = _JointVentureMaster.JointVenture |
| [0..1] | I_JointVentureRecovery | _JointVentureRecovery | $projection.JointVentureRecoveryCode = _JointVentureRecovery.JointVentureRecoveryCode and $projection.CompanyCode = _JointVentureRecovery.CompanyCode |
| [0..1] | I_JntVntrEquityTypeMaster | _JntVntrEquityTypeMaster | $projection.JointVentureEquityType = _JntVntrEquityTypeMaster.JointVentureEquityType and $projection.CompanyCode = _JntVntrEquityTypeMaster.CompanyCode |
| [0..1] | I_JntVntrCostCtrType | _JntVntrCostCtrType | $projection.JointVentureObjectType = _JntVntrCostCtrType.JntVntrCostCtrType and $projection.CompanyCode = _JntVntrCostCtrType.CompanyCode |
| [0..1] | I_JntIntrstBillgClass | _JntIntrstBillgClass | $projection.JointVentureClass = _JntIntrstBillgClass.JntIntrstBillgClass and $projection.CompanyCode = _JntIntrstBillgClass.CompanyCode |
| [0..1] | I_JntIntrstBillgSubclass | _JntIntrstBillgSubclass | $projection.CompanyCode = _JntIntrstBillgSubclass.CompanyCode and $projection.JointVentureClass = _JntIntrstBillgSubclass.JntIntrstBillgClass and $projection.JointVentureSubClass = _JntIntrstBillgSubclass.JntIntrstBillgSubClass |
| [0..1] | I_UserContactCard | _ResponsibleUser | $projection.InternalOrderResponsibleUser = _ResponsibleUser.ContactCardID |
| [0..1] | I_UserContactCard | _CreatedByUser | $projection.CreatedByUser = _CreatedByUser.ContactCardID |
| [0..1] | I_UserContactCard | _LastChangedByUser | $projection.LastChangedByUser = _LastChangedByUser.ContactCardID |
| [0..1] | I_ResultsAnalysisKey | _ResultsAnalysisKey | $projection.ResultAnalysisInternalID = _ResultsAnalysisKey.ResultAnalysisInternalID |
| [0..1] | I_InvestmentObjectScale | _InvestmentObjectScale | $projection.InvestmentScale = _InvestmentObjectScale.InvestmentScale |
| [0..*] | I_IntOrderActiveSystemStatus | _IntOrderActiveSystemStatus | $projection.ControllingObject = _IntOrderActiveSystemStatus.StatusObject |
| [0..*] | I_IntOrderActiveUserStatus | _IntOrderActiveUserStatus | $projection.ControllingObject = _IntOrderActiveUserStatus.StatusObject |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Internal Order | view | |
| AbapCatalog.sqlViewName | IFIINTERNALORDER | view | |
| AbapCatalog.buffering.type | #NONE | view | |
| AbapCatalog.buffering.numberOfKeyFields | 0 | view | |
| AbapCatalog.buffering.status | #NOT_ALLOWED | view | |
| VDM.viewType | #BASIC | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| Analytics.dataExtraction.enabled | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ClientHandling.type | #CLIENT_DEPENDENT | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.representativeKey | InternalOrder | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Metadata.allowExtensions | true | view |
Fields (128)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InternalOrder | |||
| InternalOrderDescription | ||||
| OrderCategory | autyp | |||
| BusinessArea | ||||
| ControllingArea | ||||
| Plant | werks | |||
| Currency | waers | |||
| IsStatisticalOrder | ||||
| ReferenceOrder | ||||
| SalesOrder | kdauf | |||
| SalesOrderItem | kdpos | |||
| WBSElement | pspel | |||
| WBSElementInternalID | ||||
| RequestingCostCenter | akstl | |||
| RequestingCompanyCode | abukr | |||
| RequestingOrder | anfaufnr | |||
| InternalOrderLocation | ||||
| LocationPlant | sowrk | |||
| ExternalOrder | aufex | |||
| ActualPostedCostCenter | ||||
| PlanningWithLineItemsIsActive | plgkz | |||
| CostCenter | ||||
| LogicalSystem | logsystem | |||
| OrdIsUsedInIntegratedPlanning | ||||
| TaxJurisdiction | ||||
| ResultAnalysisInternalID | ||||
| ConditionUsage | kvewe | |||
| ConditionApplication | kappl | |||
| CostingSheet | kalsm | |||
| OverheadCode | ||||
| OrderInterestCalcProfile | ||||
| IntOrderSettlementCostElement | ||||
| BasicSettlementGLAccount | saknr | |||
| IntOrderIndividualField1Value | user0 | |||
| IntOrderIndividualField2Value | user1 | |||
| IntOrderIndividualField3Value | user2 | |||
| IntOrderIndividualField4Value | user3 | |||
| IntOrderIndividualField5Amount | user4 | |||
| IntOrderIndividualField6Date | user5 | |||
| IntOrderIndividualField7Value | user6 | |||
| IntOrderIndividualField8Date | user7 | |||
| IntOrderIndividualField9Date | user8 | |||
| IntOrderIndividualField10Value | user9 | |||
| OrderProcessingGroup | ||||
| InvestmentProfile | ||||
| InvestmentScale | ||||
| InvestmentReason | izwek | |||
| EnvironmentalInvestmentReason | umwkz | |||
| JointVenture | vname | |||
| JointVentureRecoveryCode | recid | |||
| JointVentureEquityType | etype | |||
| JointVentureOriginalCostObject | jv_oco | |||
| JointVentureObjectType | otype | |||
| JointVentureClass | jv_jibcl | |||
| JointVentureSubClass | jv_jibsa | |||
| IsDeleted | loekz | |||
| CreationDate | erdat | |||
| CreationTime | erfzeit | |||
| CreatedByUser | ||||
| LastChangedByUser | aenam | |||
| LastChangeDate | aedat | |||
| LastChangeTime | aezeit | |||
| ControllingObject | objnr | |||
| CompanyCode | ||||
| ProfitCenter | ||||
| FunctionalArea | ||||
| ControllingObjectClass | ||||
| OrderType | auart | |||
| ResponsibleCostCenter | ||||
| InternalOrderResponsibleUser | ||||
| IntOrderPlannedReleaseDate | pdat1 | |||
| IntOrderPlannedCompletionDate | pdat2 | |||
| IntOrderPlannedClosingDate | pdat3 | |||
| InternalOrderReleaseDate | idat1 | |||
| InternalOrderCompletionDate | idat2 | |||
| InternalOrderClosingDate | idat3 | |||
| CostCollector | cckey | |||
| _ControllingArea | _ControllingArea | |||
| _CompanyCode | _CompanyCode | |||
| _ProfitCenter | _ProfitCenter | |||
| _FunctionalArea | _FunctionalArea | |||
| _ControllingObjectClass | _ControllingObjectClass | |||
| _InternalOrderType | _InternalOrderType | |||
| _CostCenter | _CostCenter | |||
| _User | _User | |||
| _WBSElementBasicData | _WBSElementBasicData | |||
| _RequestingCostCenter | _RequestingCostCenter | |||
| _RequestingCompanyCode | _RequestingCompanyCode | |||
| _RequestingOrder | _RequestingOrder | |||
| _Location | _Location | |||
| _LocationPlant | _LocationPlant | |||
| _ActualPostedCostCenter | _ActualPostedCostCenter | |||
| _CostCenterData | _CostCenterData | |||
| _LogicalSystem | _LogicalSystem | |||
| _ConditionUsage | _ConditionUsage | |||
| _ConditionApplication | _ConditionApplication | |||
| _CostingSheetProcedure | _CostingSheetProcedure | |||
| _IntOrderSettlementCostElement | _IntOrderSettlementCostElement | |||
| _BasicSettlementGLAccount | _BasicSettlementGLAccount | |||
| _OrderProcessingGroup | _OrderProcessingGroup | |||
| _InvestmentProfile | _InvestmentProfile | |||
| _InvestmentReason | _InvestmentReason | |||
| _EnvrnmtlInvestmentReason | _EnvrnmtlInvestmentReason | |||
| _JointVentureMaster | _JointVentureMaster | |||
| _JointVentureRecovery | _JointVentureRecovery | |||
| _JntVntrEquityTypeMaster | _JntVntrEquityTypeMaster | |||
| _JntVntrCostCtrType | _JntVntrCostCtrType | |||
| _JntIntrstBillgClass | _JntIntrstBillgClass | |||
| _JntIntrstBillgSubclass | _JntIntrstBillgSubclass | |||
| _ResponsibleUser | _ResponsibleUser | |||
| _CreatedByUser | _CreatedByUser | |||
| _LastChangedByUser | _LastChangedByUser | |||
| _CurRespCostCenterText | _CurRespCostCenterText | |||
| _CurRequestingCostCenterText | _CurRequestingCostCenterText | |||
| _CurCostCenterDataText | _CurCostCenterDataText | |||
| _SystemStatus | _SystemStatus | |||
| _ResultsAnalysisKey | _ResultsAnalysisKey | |||
| _InvestmentObjectScale | _InvestmentObjectScale | |||
| _Currency | _Currency | |||
| _OrderCategory | _OrderCategory | |||
| _BusinessArea | _BusinessArea | |||
| _Plant | _Plant | |||
| _CurProfitCenterText | _CurProfitCenterText | |||
| _CurActualPostedCostCenterText | _CurActualPostedCostCenterText | |||
| _IntOrderActiveSystemStatus | _IntOrderActiveSystemStatus | |||
| _IntOrderActiveUserStatus | _IntOrderActiveUserStatus | |||
| _ControllingAreaText | _ControllingAreaText | |||
| _InternalOrderTypeText | _InternalOrderTypeText |
@EndUserText.label: 'Internal Order'
@AbapCatalog.sqlViewName: 'IFIINTERNALORDER'
@AbapCatalog.buffering: {type: #NONE, numberOfKeyFields: 0, status: #NOT_ALLOWED}
@VDM.viewType: #BASIC
@Analytics: { dataCategory: #DIMENSION,
dataExtraction:{ enabled: true }
}
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.representativeKey: 'InternalOrder'
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true
//--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0
@AccessControl.privilegedAssociations: ['_ControllingAreaText','_InternalOrderTypeText', '_ResponsibleUser', '_LastChangedByUser','_CreatedByUser']
// ]--GENERATED
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE ]
define view I_InternalOrder
as select from aufk
//--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0
association [0..1] to I_ControllingArea as _ControllingAreaText on $projection.ControllingArea = _ControllingAreaText.ControllingArea
association [0..*] to I_InternalOrderTypeText as _InternalOrderTypeText on $projection.OrderType = _InternalOrderTypeText.OrderType
// ]--GENERATED
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..*] to I_ProfitCenter as _ProfitCenter on $projection.ControllingArea = _ProfitCenter.ControllingArea
and $projection.ProfitCenter = _ProfitCenter.ProfitCenter
association [0..1] to I_FunctionalArea as _FunctionalArea on $projection.FunctionalArea = _FunctionalArea.FunctionalArea
association [0..1] to I_ControllingObjectClass as _ControllingObjectClass on $projection.ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass
association [0..1] to I_InternalOrderType as _InternalOrderType on $projection.OrderType = _InternalOrderType.OrderType
association [0..*] to I_CostCenter as _CostCenter on $projection.ControllingArea = _CostCenter.ControllingArea
and $projection.ResponsibleCostCenter = _CostCenter.CostCenter
association [0..*] to I_InternalOrderSystemStatus as _SystemStatus on $projection.ControllingObject = _SystemStatus.ControllingObject
association [1..1] to E_LogisticsOrder as _Extension on $projection.InternalOrder = _Extension.OrderID
association [0..*] to I_ProfitCenterText as _CurProfitCenterText on $projection.ControllingArea = _CurProfitCenterText.ControllingArea
and $projection.ProfitCenter = _CurProfitCenterText.ProfitCenter
and _CurProfitCenterText.ValidityStartDate <= $session.system_date
and _CurProfitCenterText.ValidityEndDate >= $session.system_date
association [0..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association [0..1] to I_User as _User on $projection.InternalOrderResponsibleUser = _User.UserID
association [0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association [0..1] to I_Currency as _Currency on $projection.Currency = _Currency.Currency
association [0..1] to I_OrderCategory as _OrderCategory on $projection.OrderCategory = _OrderCategory.OrderCategory
association [0..*] to I_CostCenterText as _CurRespCostCenterText on $projection.ControllingArea = _CurRespCostCenterText.ControllingArea
and $projection.ResponsibleCostCenter = _CurRespCostCenterText.CostCenter
and _CurRespCostCenterText.ValidityStartDate <= $session.system_date
and _CurRespCostCenterText.ValidityEndDate >= $session.system_date
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
association [0..*] to I_CostCenter as _RequestingCostCenter on $projection.RequestingCostCenter = _RequestingCostCenter.CostCenter
and $projection.ControllingArea = _RequestingCostCenter.ControllingArea
association [0..*] to I_CostCenterText as _CurRequestingCostCenterText on $projection.ControllingArea = _CurRequestingCostCenterText.ControllingArea
and $projection.RequestingCostCenter = _CurRequestingCostCenterText.CostCenter
and _CurRequestingCostCenterText.ValidityStartDate <= $session.system_date
and _CurRequestingCostCenterText.ValidityEndDate >= $session.system_date
association [0..1] to I_CompanyCode as _RequestingCompanyCode on $projection.RequestingCompanyCode = _RequestingCompanyCode.CompanyCode
association [0..1] to I_Order as _RequestingOrder on $projection.RequestingOrder = _RequestingOrder.OrderID
association [0..1] to I_Location as _Location on $projection.InternalOrderLocation = _Location.Location
and $projection.LocationPlant = _Location.Plant
association [0..1] to I_Plant as _LocationPlant on $projection.LocationPlant = _LocationPlant.Plant
association [0..*] to I_CostCenter as _ActualPostedCostCenter on $projection.ControllingArea = _ActualPostedCostCenter.ControllingArea
and $projection.ActualPostedCostCenter = _ActualPostedCostCenter.CostCenter
association [0..*] to I_CostCenterText as _CurActualPostedCostCenterText on $projection.ControllingArea = _CurActualPostedCostCenterText.ControllingArea
and $projection.ActualPostedCostCenter = _CurActualPostedCostCenterText.CostCenter
and _CurActualPostedCostCenterText.ValidityStartDate <= $session.system_date
and _CurActualPostedCostCenterText.ValidityEndDate >= $session.system_date
association [0..*] to I_CostCenter as _CostCenterData on $projection.ControllingArea = _CostCenterData.ControllingArea
and $projection.CostCenter = _CostCenterData.CostCenter
association [0..*] to I_CostCenterText as _CurCostCenterDataText on $projection.ControllingArea = _CurCostCenterDataText.ControllingArea
and $projection.CostCenter = _CurCostCenterDataText.CostCenter
and _CurCostCenterDataText.ValidityStartDate <= $session.system_date
and _CurCostCenterDataText.ValidityEndDate >= $session.system_date
association [0..1] to I_LogicalSystem as _LogicalSystem on $projection.LogicalSystem = _LogicalSystem.LogicalSystem
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..*] to I_CostElementOnControllingArea as _IntOrderSettlementCostElement on $projection.ControllingArea = _IntOrderSettlementCostElement.ControllingArea
and $projection.IntOrderSettlementCostElement = _IntOrderSettlementCostElement.CostElement
association [0..1] to I_GLAccountInCompanyCode as _BasicSettlementGLAccount on $projection.CompanyCode = _BasicSettlementGLAccount.CompanyCode
and $projection.BasicSettlementGLAccount = _BasicSettlementGLAccount.GLAccount
association [0..1] to I_OrderProcessingGroup as _OrderProcessingGroup on $projection.ControllingArea = _OrderProcessingGroup.ControllingArea
and $projection.OrderProcessingGroup = _OrderProcessingGroup.OrderProcessingGroup
association [0..1] to I_InvestmentProfile as _InvestmentProfile on $projection.InvestmentProfile = _InvestmentProfile.InvestmentProfile
association [0..1] to I_InvestmentReason as _InvestmentReason on $projection.InvestmentReason = _InvestmentReason.InvestmentReason
association [0..1] to I_EnvrnmtlInvestmentReason as _EnvrnmtlInvestmentReason on $projection.EnvironmentalInvestmentReason = _EnvrnmtlInvestmentReason.EnvrnmtlInvestmentReason
association [0..1] to I_JointVentureMaster as _JointVentureMaster on $projection.CompanyCode = _JointVentureMaster.CompanyCode
and $projection.JointVenture = _JointVentureMaster.JointVenture
association [0..1] to I_JointVentureRecovery as _JointVentureRecovery on $projection.JointVentureRecoveryCode = _JointVentureRecovery.JointVentureRecoveryCode
and $projection.CompanyCode = _JointVentureRecovery.CompanyCode
association [0..1] to I_JntVntrEquityTypeMaster as _JntVntrEquityTypeMaster on $projection.JointVentureEquityType = _JntVntrEquityTypeMaster.JointVentureEquityType
and $projection.CompanyCode = _JntVntrEquityTypeMaster.CompanyCode
association [0..1] to I_JntVntrCostCtrType as _JntVntrCostCtrType on $projection.JointVentureObjectType = _JntVntrCostCtrType.JntVntrCostCtrType
and $projection.CompanyCode = _JntVntrCostCtrType.CompanyCode
association [0..1] to I_JntIntrstBillgClass as _JntIntrstBillgClass on $projection.JointVentureClass = _JntIntrstBillgClass.JntIntrstBillgClass
and $projection.CompanyCode = _JntIntrstBillgClass.CompanyCode
association [0..1] to I_JntIntrstBillgSubclass as _JntIntrstBillgSubclass on $projection.CompanyCode = _JntIntrstBillgSubclass.CompanyCode
and $projection.JointVentureClass = _JntIntrstBillgSubclass.JntIntrstBillgClass
and $projection.JointVentureSubClass = _JntIntrstBillgSubclass.JntIntrstBillgSubClass
association [0..1] to I_UserContactCard as _ResponsibleUser on $projection.InternalOrderResponsibleUser = _ResponsibleUser.ContactCardID
association [0..1] to I_UserContactCard as _CreatedByUser on $projection.CreatedByUser = _CreatedByUser.ContactCardID
association [0..1] to I_UserContactCard as _LastChangedByUser on $projection.LastChangedByUser = _LastChangedByUser.ContactCardID
association [0..1] to I_ResultsAnalysisKey as _ResultsAnalysisKey on $projection.ResultAnalysisInternalID = _ResultsAnalysisKey.ResultAnalysisInternalID
association [0..1] to I_InvestmentObjectScale as _InvestmentObjectScale on $projection.InvestmentScale = _InvestmentObjectScale.InvestmentScale
association [0..*] to I_IntOrderActiveSystemStatus as _IntOrderActiveSystemStatus on $projection.ControllingObject = _IntOrderActiveSystemStatus.StatusObject
association [0..*] to I_IntOrderActiveUserStatus as _IntOrderActiveUserStatus on $projection.ControllingObject = _IntOrderActiveUserStatus.StatusObject
{
@ObjectModel.text.element: ['InternalOrderDescription']
key cast( aufnr as fins_int_aufnr preserving type ) as InternalOrder,
@Semantics.text: true
cast(ktext as fis_internalorder_text) as InternalOrderDescription,
@ObjectModel.foreignKey.association: '_OrderCategory'
autyp as OrderCategory,
@ObjectModel.foreignKey.association: '_BusinessArea'
cast(gsber as fis_rbusa) as BusinessArea,
//--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ControllingArea',
element: 'ControllingArea' }
}]
@ObjectModel.text.association: '_ControllingAreaText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_ControllingArea'
cast(kokrs as fis_kokrs preserving type ) as ControllingArea,
@ObjectModel.foreignKey.association: '_Plant'
werks as Plant,
@ObjectModel.foreignKey.association: '_Currency'
waers as Currency,
cast (astkz as fins_co_xaufnr_stat preserving type ) as IsStatisticalOrder,
cast(refnr as fis_aufrefnr preserving type ) as ReferenceOrder,
kdauf as SalesOrder,
kdpos as SalesOrderItem,
pspel as WBSElement,
@ObjectModel.foreignKey.association: '_WBSElementBasicData'
cast ( pspel as ps_s4_pspnr preserving type ) as WBSElementInternalID,
akstl as RequestingCostCenter,
@ObjectModel.foreignKey.association: '_RequestingCompanyCode'
abukr as RequestingCompanyCode,
@ObjectModel.foreignKey.association: '_RequestingOrder'
anfaufnr as RequestingOrder,
@ObjectModel.foreignKey.association: '_Location'
cast( stort as fco_io_aufstort preserving type ) as InternalOrderLocation,
@ObjectModel.foreignKey.association: '_LocationPlant'
sowrk as LocationPlant,
aufex as ExternalOrder,
cast( cycle as fins_st_kostl preserving type ) as ActualPostedCostCenter,
plgkz as PlanningWithLineItemsIsActive,
cast(kostl as fis_kostl preserving type ) as CostCenter,
@ObjectModel.foreignKey.association: '_LogicalSystem'
logsystem as LogicalSystem,
cast(plint as fco_plint preserving type ) as OrdIsUsedInIntegratedPlanning,
cast ( txjcd as fis_txjcd preserving type ) as TaxJurisdiction,
cast(abgsl as fco_abgr_schl preserving type ) as ResultAnalysisInternalID,
@ObjectModel.foreignKey.association: '_ConditionUsage'
kvewe as ConditionUsage,
@ObjectModel.foreignKey.association: '_ConditionApplication'
kappl as ConditionApplication,
@ObjectModel.foreignKey.association: '_CostingSheetProcedure'
kalsm as CostingSheet,
cast(zschl as fco_aufzschl preserving type ) as OverheadCode,
// TODO - Define basic view for TPI01
cast(zschm as fco_io_ps_zschm preserving type ) as OrderInterestCalcProfile,
cast(kstar as fco_aufkstar preserving type ) as IntOrderSettlementCostElement,
@ObjectModel.foreignKey.association: '_BasicSettlementGLAccount'
saknr as BasicSettlementGLAccount,
user0 as IntOrderIndividualField1Value,
user1 as IntOrderIndividualField2Value,
user2 as IntOrderIndividualField3Value,
user3 as IntOrderIndividualField4Value,
@Semantics.amount.currencyCode: 'Currency'
user4 as IntOrderIndividualField5Amount,
user5 as IntOrderIndividualField6Date,
user6 as IntOrderIndividualField7Value,
user7 as IntOrderIndividualField8Date,
user8 as IntOrderIndividualField9Date,
user9 as IntOrderIndividualField10Value,
@ObjectModel.foreignKey.association: '_OrderProcessingGroup'
cast(abkrs as fco_aufabkrs preserving type ) as OrderProcessingGroup,
cast(ivpro as fco_im_profil preserving type ) as InvestmentProfile,
cast(sizecl as fco_im_sizecl preserving type ) as InvestmentScale,
izwek as InvestmentReason,
@ObjectModel.foreignKey.association: '_EnvrnmtlInvestmentReason'
umwkz as EnvironmentalInvestmentReason,
vname as JointVenture,
@ObjectModel.foreignKey.association: '_JointVentureRecovery'
recid as JointVentureRecoveryCode,
@ObjectModel.foreignKey.association: '_JntVntrEquityTypeMaster'
etype as JointVentureEquityType,
//TODO - Domain Fixed values
jv_oco as JointVentureOriginalCostObject,
otype as JointVentureObjectType,
@ObjectModel.foreignKey.association: '_JntIntrstBillgClass'
jv_jibcl as JointVentureClass,
@ObjectModel.foreignKey.association: '_JntIntrstBillgSubclass'
jv_jibsa as JointVentureSubClass,
// abkrs as ProcessingGroup,
loekz as IsDeleted,
erdat as CreationDate,
erfzeit as CreationTime,
@ObjectModel.foreignKey.association: '_CreatedByUser'
cast(ernam as fin_usnam preserving type ) as CreatedByUser,
@ObjectModel.foreignKey.association: '_LastChangedByUser'
aenam as LastChangedByUser,
aedat as LastChangeDate,
aezeit as LastChangeTime,
objnr as ControllingObject,
//--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_CompanyCodeStdVH',
element: 'CompanyCode' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_CompanyCode' //Inserted by VDM CDS Suite Plugin
cast(bukrs as fis_bukrs preserving type ) as CompanyCode,
//--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ProfitCenterStdVH',
element: 'ProfitCenter' },
additionalBinding: [{ localElement: 'ControllingArea',
element: 'ControllingArea' }]
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_ProfitCenter' //Inserted by VDM CDS Suite Plugin
cast(prctr as fis_prctr) as ProfitCenter,
@ObjectModel.foreignKey.association: '_FunctionalArea' //Inserted by VDM CDS Suite Plugin
cast(func_area as fm_farea) as FunctionalArea,
@ObjectModel.foreignKey.association: '_ControllingObjectClass' //Inserted by VDM CDS Suite Plugin
cast(scope as fis_scope_cv_conv) as ControllingObjectClass,
//--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_InternalOrderTypeStdVH',
element: 'OrderType' }
}]
@ObjectModel.text.association: '_InternalOrderTypeText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_InternalOrderType'
auart as OrderType,
//--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_CostCenterStdVH',
element: 'CostCenter' },
additionalBinding: [{ localElement: 'ControllingArea',
element: 'ControllingArea' }]
}]
// ]--GENERATED
cast( kostv as fin_io_aufkostv preserving type ) as ResponsibleCostCenter,
@ObjectModel.foreignKey.association: '_ResponsibleUser'
cast( veraa_user as fco_veraa_user preserving type ) as InternalOrderResponsibleUser,
pdat1 as IntOrderPlannedReleaseDate,
pdat2 as IntOrderPlannedCompletionDate,
pdat3 as IntOrderPlannedClosingDate,
idat1 as InternalOrderReleaseDate,
idat2 as InternalOrderCompletionDate,
idat3 as InternalOrderClosingDate,
cckey as CostCollector,
_ControllingArea,
_CompanyCode,
_ProfitCenter,
_FunctionalArea,
_ControllingObjectClass,
_InternalOrderType,
_CostCenter,
_User,
_WBSElementBasicData,
_RequestingCostCenter,
_RequestingCompanyCode,
_RequestingOrder,
_Location,
_LocationPlant,
_ActualPostedCostCenter,
_CostCenterData,
_LogicalSystem,
_ConditionUsage,
_ConditionApplication,
_CostingSheetProcedure,
_IntOrderSettlementCostElement,
_BasicSettlementGLAccount,
_OrderProcessingGroup,
_InvestmentProfile,
_InvestmentReason,
_EnvrnmtlInvestmentReason,
_JointVentureMaster,
_JointVentureRecovery,
_JntVntrEquityTypeMaster,
_JntVntrCostCtrType,
_JntIntrstBillgClass,
_JntIntrstBillgSubclass,
_ResponsibleUser,
_CreatedByUser,
_LastChangedByUser,
_CurRespCostCenterText,
_CurRequestingCostCenterText,
_CurCostCenterDataText,
_SystemStatus,
_ResultsAnalysisKey,
_InvestmentObjectScale,
_Currency,
_OrderCategory,
_BusinessArea,
_Plant,
_CurProfitCenterText,
_CurActualPostedCostCenterText,
_IntOrderActiveSystemStatus,
_IntOrderActiveUserStatus,
//--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0
@Consumption.hidden: true
_ControllingAreaText,
@Consumption.hidden: true
_InternalOrderTypeText
// ]--GENERATED
}
where
autyp = '01'
or autyp = '02'
or autyp = '03';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AUFK"
],
"ASSOCIATED":
[
"E_LOGISTICSORDER",
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_CONDITIONAPPLICATION",
"I_CONDITIONUSAGE",
"I_CONTROLLINGAREA",
"I_CONTROLLINGOBJECTCLASS",
"I_COSTCENTER",
"I_COSTCENTERTEXT",
"I_COSTELEMENTONCONTROLLINGAREA",
"I_COSTINGSHEETPROCEDURE",
"I_CURRENCY",
"I_ENVRNMTLINVESTMENTREASON",
"I_FUNCTIONALAREA",
"I_GLACCOUNTINCOMPANYCODE",
"I_INTERNALORDERSYSTEMSTATUS",
"I_INTERNALORDERTYPE",
"I_INTERNALORDERTYPETEXT",
"I_INTORDERACTIVESYSTEMSTATUS",
"I_INTORDERACTIVEUSERSTATUS",
"I_INVESTMENTOBJECTSCALE",
"I_INVESTMENTPROFILE",
"I_INVESTMENTREASON",
"I_JNTINTRSTBILLGCLASS",
"I_JNTINTRSTBILLGSUBCLASS",
"I_JNTVNTRCOSTCTRTYPE",
"I_JNTVNTREQUITYTYPEMASTER",
"I_JOINTVENTUREMASTER",
"I_JOINTVENTURERECOVERY",
"I_LOCATION",
"I_LOGICALSYSTEM",
"I_ORDER",
"I_ORDERCATEGORY",
"I_ORDERPROCESSINGGROUP",
"I_PLANT",
"I_PROFITCENTER",
"I_PROFITCENTERTEXT",
"I_RESULTSANALYSISKEY",
"I_USER",
"I_USERCONTACTCARD",
"I_WBSELEMENTBASICDATA"
],
"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