R_InternalOrderTP
Internal Order
R_InternalOrderTP is a Transactional CDS View that provides data about "Internal Order" in SAP S/4HANA. It reads from 1 data source (I_InternalOrder) and exposes 129 fields with key fields InternalOrder, InternalOrderDraftInternalUUID. It has 10 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_InternalOrder | I_InternalOrder | from |
Associations (10)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_StatusObjectStatusBasic | _InternalOrderIsLocked | I_InternalOrder.ControllingObject = _InternalOrderIsLocked.StatusObject and _InternalOrderIsLocked.StatusCode = 'I0043' |
| [0..1] | I_StatusObjectStatusBasic | _IntOrdSettlementRuleIsCreated | I_InternalOrder.ControllingObject = _IntOrdSettlementRuleIsCreated.StatusObject and ( _IntOrdSettlementRuleIsCreated.StatusCode = 'I0028' or _IntOrdSettlementRuleIsCreated.StatusCode = 'I0027' ) and _IntOrdSettlementRuleIsCreated.StatusIsInactive = '' |
| [0..1] | I_StatusObjectStatusBasic | _IntOrdDeletionFlagIsSet | I_InternalOrder.ControllingObject = _IntOrdDeletionFlagIsSet.StatusObject and _IntOrdDeletionFlagIsSet.StatusCode = 'I0076' |
| [0..1] | I_StatusObjectStatusBasic | _IntOrdIsMarkedForDeletion | I_InternalOrder.ControllingObject = _IntOrdIsMarkedForDeletion.StatusObject and _IntOrdIsMarkedForDeletion.StatusCode = 'I0013' |
| [0..1] | I_TaxJurisdiction | _TaxJurisdiction | $projection.TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction |
| [0..*] | R_InternalOrderSystemStatusTP | _InternalOrderSystemStatusTP | |
| [0..*] | R_IntOrderNumberedUserStatusTP | _IntOrderNumberedUserStatusTP | |
| [0..*] | R_IntOrdUnnumberedUserStatusTP | _IntOrdUnnumberedUserStatusTP | |
| [0..*] | R_IntOrdOverallSystemStatusTP | _IntOrdOverallSystemStatusTP | |
| [0..*] | R_IntOrdLongDescriptionDraftTP | _IntOrdLongDescriptionDraftTP | |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Internal Order | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.sapObjectNodeType.name | InternalOrder | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view |
Fields (129)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InternalOrder | InternalOrder | ||
| KEY | InternalOrderDraftInternalUUID | |||
| InternalOrderForEdit | InternalOrder | |||
| InternalOrderDescription | ||||
| OrderCategory | OrderCategory | |||
| BusinessArea | BusinessArea | |||
| ControllingArea | ControllingArea | |||
| Plant | Plant | |||
| Currency | Currency | |||
| IsStatisticalOrder | IsStatisticalOrder | |||
| ReferenceOrder | ReferenceOrder | |||
| SalesOrder | SalesOrder | |||
| SalesOrderItem | SalesOrderItem | |||
| WBSElementInternalID | WBSElementInternalID | |||
| WBSElementExternalID | _WBSElementBasicData | WBSElementExternalID | ||
| RequestingCostCenter | RequestingCostCenter | |||
| RequestingCompanyCode | RequestingCompanyCode | |||
| RequestingOrder | RequestingOrder | |||
| InternalOrderLocation | InternalOrderLocation | |||
| LocationPlant | LocationPlant | |||
| ExternalOrder | ExternalOrder | |||
| ActualPostedCostCenter | ActualPostedCostCenter | |||
| CostCenter | CostCenter | |||
| LogicalSystem | LogicalSystem | |||
| OrdIsUsedInIntegratedPlanning | OrdIsUsedInIntegratedPlanning | |||
| ResultAnalysisInternalID | ResultAnalysisInternalID | |||
| ConditionUsage | ConditionUsage | |||
| ConditionApplication | ConditionApplication | |||
| CostingSheet | CostingSheet | |||
| OverheadCode | OverheadCode | |||
| OrderInterestCalcProfile | OrderInterestCalcProfile | |||
| IntOrderSettlementCostElement | IntOrderSettlementCostElement | |||
| BasicSettlementGLAccount | BasicSettlementGLAccount | |||
| IntOrderIndividualField1Value | IntOrderIndividualField1Value | |||
| IntOrderIndividualField2Value | IntOrderIndividualField2Value | |||
| IntOrderIndividualField3Value | IntOrderIndividualField3Value | |||
| IntOrderIndividualField4Value | IntOrderIndividualField4Value | |||
| IntOrderIndividualField5Amount | IntOrderIndividualField5Amount | |||
| IntOrderIndividualField6Date | IntOrderIndividualField6Date | |||
| IntOrderIndividualField7Value | IntOrderIndividualField7Value | |||
| IntOrderIndividualField8Date | IntOrderIndividualField8Date | |||
| IntOrderIndividualField9Date | IntOrderIndividualField9Date | |||
| IntOrderIndividualField10Value | ||||
| OrderProcessingGroup | OrderProcessingGroup | |||
| InvestmentProfile | InvestmentProfile | |||
| InvestmentScale | InvestmentScale | |||
| InvestmentReason | InvestmentReason | |||
| EnvironmentalInvestmentReason | EnvironmentalInvestmentReason | |||
| JointVenture | JointVenture | |||
| JointVentureRecoveryCode | JointVentureRecoveryCode | |||
| JointVentureEquityType | JointVentureEquityType | |||
| JointVentureOriginalCostObject | JointVentureOriginalCostObject | |||
| JointVentureObjectType | JointVentureObjectType | |||
| JointVentureClass | JointVentureClass | |||
| JointVentureSubClass | JointVentureSubClass | |||
| CreationDate | CreationDate | |||
| CreationTime | CreationTime | |||
| CreatedByUser | CreatedByUser | |||
| LastChangedByUser | ||||
| LastChangeDate | LastChangeDate | |||
| LastChangeTime | LastChangeTime | |||
| ControllingObject | ControllingObject | |||
| CompanyCode | CompanyCode | |||
| ProfitCenter | ProfitCenter | |||
| FunctionalArea | FunctionalArea | |||
| ControllingObjectClass | ControllingObjectClass | |||
| OrderType | OrderType | |||
| ResponsibleCostCenter | ResponsibleCostCenter | |||
| InternalOrderResponsibleUser | InternalOrderResponsibleUser | |||
| ControllingObjectStatus | _SystemStatus | ControllingObjectStatus | ||
| IntOrderSystemStatusShortName | ||||
| InternalOrderSystemStatusName | ||||
| TaxJurisdiction | TaxJurisdiction | |||
| _ActualPostedCostCenter | _ActualPostedCostCenter | |||
| _BasicSettlementGLAccount | _BasicSettlementGLAccount | |||
| _CompanyCode | _CompanyCode | |||
| _ConditionApplication | _ConditionApplication | |||
| _ConditionUsage | _ConditionUsage | |||
| _ControllingArea | _ControllingArea | |||
| _ControllingAreaText | _ControllingAreaText | |||
| _ControllingObjectClass | _ControllingObjectClass | |||
| _CostCenter | _CostCenter | |||
| _CostCenterData | _CostCenterData | |||
| _CostingSheetProcedure | _CostingSheetProcedure | |||
| _EnvrnmtlInvestmentReason | _EnvrnmtlInvestmentReason | |||
| _FunctionalArea | _FunctionalArea | |||
| _InternalOrderType | _InternalOrderType | |||
| _InternalOrderTypeText | _InternalOrderTypeText | |||
| _IntOrderSettlementCostElement | _IntOrderSettlementCostElement | |||
| _InvestmentObjectScale | _InvestmentObjectScale | |||
| _InvestmentProfile | _InvestmentProfile | |||
| _InvestmentReason | _InvestmentReason | |||
| _JntIntrstBillgClass | _JntIntrstBillgClass | |||
| _JntIntrstBillgSubclass | _JntIntrstBillgSubclass | |||
| _JntVntrEquityTypeMaster | _JntVntrEquityTypeMaster | |||
| _JointVentureRecovery | _JointVentureRecovery | |||
| _Location | _Location | |||
| _LocationPlant | _LocationPlant | |||
| _LogicalSystem | _LogicalSystem | |||
| _OrderProcessingGroup | _OrderProcessingGroup | |||
| _ProfitCenter | _ProfitCenter | |||
| _RequestingCompanyCode | _RequestingCompanyCode | |||
| _RequestingCostCenter | _RequestingCostCenter | |||
| _RequestingOrder | _RequestingOrder | |||
| _ResultsAnalysisKey | _ResultsAnalysisKey | |||
| _ResponsibleUser | _ResponsibleUser | |||
| _CreatedByUser | _CreatedByUser | |||
| _LastChangedByUser | _LastChangedByUser | |||
| _CurRespCostCenterText | _CurRespCostCenterText | |||
| _CurRequestingCostCenterText | _CurRequestingCostCenterText | |||
| _CurCostCenterDataText | _CurCostCenterDataText | |||
| _SystemStatus | _SystemStatus | |||
| _WBSElementBasicData | _WBSElementBasicData | |||
| _Currency | _Currency | |||
| _OrderCategory | _OrderCategory | |||
| _Plant | _Plant | |||
| _BusinessArea | _BusinessArea | |||
| _CurProfitCenterText | _CurProfitCenterText | |||
| _CurActualPostedCostCenterText | _CurActualPostedCostCenterText | |||
| _InternalOrderIsLocked | _InternalOrderIsLocked | |||
| _IntOrdSettlementRuleIsCreated | _IntOrdSettlementRuleIsCreated | |||
| _IntOrdDeletionFlagIsSet | _IntOrdDeletionFlagIsSet | |||
| _IntOrdIsMarkedForDeletion | _IntOrdIsMarkedForDeletion | |||
| _InternalOrderSystemStatusTP | _InternalOrderSystemStatusTP | |||
| _IntOrdUnnumberedUserStatusTP | _IntOrdUnnumberedUserStatusTP | |||
| _IntOrderNumberedUserStatusTP | _IntOrderNumberedUserStatusTP | |||
| _IntOrdOverallSystemStatusTP | _IntOrdOverallSystemStatusTP | |||
| _IntOrdLongDescriptionDraftTP | _IntOrdLongDescriptionDraftTP | |||
| _TaxJurisdiction | _TaxJurisdiction |
@AccessControl: {
authorizationCheck: #CHECK,
privilegedAssociations: [
'_InternalOrderIsLocked',
'_IntOrdSettlementRuleIsCreated'
]
}
@EndUserText.label: 'Internal Order'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.semanticKey: [ 'InternalOrder' ]
@ObjectModel.sapObjectNodeType.name: 'InternalOrder'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
define root view entity R_InternalOrderTP
as select from I_InternalOrder
composition [0..*] of R_InternalOrderSystemStatusTP as _InternalOrderSystemStatusTP
composition [0..*] of R_IntOrderNumberedUserStatusTP as _IntOrderNumberedUserStatusTP
composition [0..*] of R_IntOrdUnnumberedUserStatusTP as _IntOrdUnnumberedUserStatusTP
composition [0..*] of R_IntOrdOverallSystemStatusTP as _IntOrdOverallSystemStatusTP
composition [0..*] of R_IntOrdLongDescriptionDraftTP as _IntOrdLongDescriptionDraftTP
association [0..1] to I_StatusObjectStatusBasic as _InternalOrderIsLocked on I_InternalOrder.ControllingObject = _InternalOrderIsLocked.StatusObject
and _InternalOrderIsLocked.StatusCode = 'I0043'
association [0..1] to I_StatusObjectStatusBasic as _IntOrdSettlementRuleIsCreated on I_InternalOrder.ControllingObject = _IntOrdSettlementRuleIsCreated.StatusObject
and (
_IntOrdSettlementRuleIsCreated.StatusCode = 'I0028'
or _IntOrdSettlementRuleIsCreated.StatusCode = 'I0027'
)
and _IntOrdSettlementRuleIsCreated.StatusIsInactive = ''
association [0..1] to I_StatusObjectStatusBasic as _IntOrdDeletionFlagIsSet on I_InternalOrder.ControllingObject = _IntOrdDeletionFlagIsSet.StatusObject
and _IntOrdDeletionFlagIsSet.StatusCode = 'I0076'
association [0..1] to I_StatusObjectStatusBasic as _IntOrdIsMarkedForDeletion on I_InternalOrder.ControllingObject = _IntOrdIsMarkedForDeletion.StatusObject
and _IntOrdIsMarkedForDeletion.StatusCode = 'I0013'
association [0..1] to I_TaxJurisdiction as _TaxJurisdiction on $projection.TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction
{
key InternalOrder,
key cast('00000000000000000000000000000000' as sysuuid_c32) as InternalOrderDraftInternalUUID,
@ObjectModel.editableFieldFor: 'InternalOrder'
InternalOrder as InternalOrderForEdit,
cast( InternalOrderDescription as kltxt ) as InternalOrderDescription,
OrderCategory,
BusinessArea,
@ObjectModel.text.association:null
ControllingArea,
Plant,
Currency,
IsStatisticalOrder,
ReferenceOrder,
SalesOrder,
SalesOrderItem,
WBSElementInternalID,
_WBSElementBasicData.WBSElementExternalID,
RequestingCostCenter,
RequestingCompanyCode,
RequestingOrder,
InternalOrderLocation,
LocationPlant,
ExternalOrder,
ActualPostedCostCenter,
CostCenter,
LogicalSystem,
OrdIsUsedInIntegratedPlanning,
ResultAnalysisInternalID,
ConditionUsage,
ConditionApplication,
CostingSheet,
OverheadCode,
OrderInterestCalcProfile,
IntOrderSettlementCostElement,
BasicSettlementGLAccount,
IntOrderIndividualField1Value,
IntOrderIndividualField2Value,
IntOrderIndividualField3Value,
IntOrderIndividualField4Value,
IntOrderIndividualField5Amount,
IntOrderIndividualField6Date,
IntOrderIndividualField7Value,
IntOrderIndividualField8Date,
IntOrderIndividualField9Date,
cast ( IntOrderIndividualField10Value as fco_io_aufuser9 preserving type ) as IntOrderIndividualField10Value,
OrderProcessingGroup,
InvestmentProfile,
InvestmentScale,
InvestmentReason,
EnvironmentalInvestmentReason,
JointVenture,
JointVentureRecoveryCode,
JointVentureEquityType,
JointVentureOriginalCostObject,
JointVentureObjectType,
JointVentureClass,
JointVentureSubClass,
case _IntOrdIsMarkedForDeletion.StatusIsInactive
when 'X' then cast ('' as fco_io_markedfordeletion preserving type )
when '' then cast ('X' as fco_io_markedfordeletion preserving type )
else cast ('' as fco_io_markedfordeletion preserving type )
end as InternalOrderIsDeleted,
case _IntOrdDeletionFlagIsSet.StatusIsInactive
when 'X' then cast ('' as fco_io_deletionflag preserving type )
when '' then cast ('X' as fco_io_deletionflag preserving type )
else cast ('' as fco_io_deletionflag preserving type )
end as InternalOrderDeletionFlagIsSet,
CreationDate,
CreationTime,
CreatedByUser,
cast ( LastChangedByUser as fco_io_aufaenam preserving type ) as LastChangedByUser,
LastChangeDate,
LastChangeTime,
@Semantics.systemDateTime.lastChangedAt: true
cast( dats_tims_to_tstmp( LastChangeDate,
LastChangeTime,
abap_system_timezone( $session.client,'NULL' ),
$session.client,
'NULL' ) as timestamp ) as LastChangeDateTime,
ControllingObject,
CompanyCode,
ProfitCenter,
FunctionalArea,
ControllingObjectClass,
@ObjectModel.text.association:null
OrderType,
ResponsibleCostCenter,
InternalOrderResponsibleUser,
case _InternalOrderType.CommitmentsMgmtActvtnStatus
when '' then cast( '' as fins_co_io_obligo )
when '1' then cast( 'X' as fins_co_io_obligo )
end as CommitmentsMgmtActvtnStatus,
case substring(CostCollector, 1, 1)
when '1'
then cast( '' as erloese )
when '2'
then cast( 'X' as erloese )
end as RevenuePostingIsAllowed,
@ObjectModel.text.association:null
_SystemStatus.ControllingObjectStatus,
_SystemStatus._Text[1: Language = $session.system_language].SystemStatusShortName as IntOrderSystemStatusShortName,
_SystemStatus._Text[1: Language = $session.system_language].StatusName as InternalOrderSystemStatusName,
case _InternalOrderIsLocked.StatusIsInactive
when 'X' then cast ('' as fco_io_lock preserving type )
when '' then cast ('X' as fco_io_lock preserving type )
else cast ('' as fco_io_lock preserving type )
end as InternalOrderIsLocked,
case _IntOrdSettlementRuleIsCreated.StatusIsInactive
when 'X' then cast ('' as fco_io_settl_rule_created preserving type )
when '' then cast ('X' as fco_io_settl_rule_created preserving type )
else cast ('' as fco_io_settl_rule_created preserving type )
end as IntOrdSettlementRuleIsCreated,
TaxJurisdiction,
/* Associations */
_ActualPostedCostCenter,
_BasicSettlementGLAccount,
_CompanyCode,
_ConditionApplication,
_ConditionUsage,
_ControllingArea,
_ControllingAreaText,
_ControllingObjectClass,
_CostCenter,
_CostCenterData,
_CostingSheetProcedure,
_EnvrnmtlInvestmentReason,
_FunctionalArea,
_InternalOrderType,
_InternalOrderTypeText,
_IntOrderSettlementCostElement,
_InvestmentObjectScale,
_InvestmentProfile,
_InvestmentReason,
_JntIntrstBillgClass,
_JntIntrstBillgSubclass,
_JntVntrEquityTypeMaster,
_JointVentureRecovery,
_Location,
_LocationPlant,
_LogicalSystem,
_OrderProcessingGroup,
_ProfitCenter,
_RequestingCompanyCode,
_RequestingCostCenter,
_RequestingOrder,
_ResultsAnalysisKey,
_ResponsibleUser,
_CreatedByUser,
_LastChangedByUser,
_CurRespCostCenterText,
_CurRequestingCostCenterText,
_CurCostCenterDataText,
_SystemStatus,
_WBSElementBasicData,
_Currency,
_OrderCategory,
_Plant,
_BusinessArea,
_CurProfitCenterText,
_CurActualPostedCostCenterText,
_InternalOrderIsLocked,
_IntOrdSettlementRuleIsCreated,
_IntOrdDeletionFlagIsSet,
_IntOrdIsMarkedForDeletion,
_InternalOrderSystemStatusTP,
_IntOrdUnnumberedUserStatusTP,
_IntOrderNumberedUserStatusTP,
_IntOrdOverallSystemStatusTP,
_IntOrdLongDescriptionDraftTP,
_TaxJurisdiction
}
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