R_InternalOrderSystemStatusTP
Internal order system status
R_InternalOrderSystemStatusTP is a Transactional CDS View that provides data about "Internal order system status" in SAP S/4HANA. It reads from 1 data source (P_InternalOrderSystemStatus) and exposes 13 fields with key fields InternalOrder, InternalOrderDraftInternalUUID, SystemStatus.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_InternalOrderSystemStatus | P_InternalOrderSystemStatus | from |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Internal order system status | view |
Fields (13)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InternalOrder | InternalOrder | ||
| KEY | InternalOrderDraftInternalUUID | |||
| KEY | SystemStatus | SystemStatus | ||
| SystemStatusShortName | SystemStatusShortName | |||
| SystemStatusName | SystemStatusName | |||
| InternalOrderStatusPlannedDate | InternalOrderStatusPlannedDate | |||
| InternalOrderStatusReachedDate | InternalOrderStatusReachedDate | |||
| ControllingObject | ControllingObject | |||
| LastChangedByUser | LastChangedByUser | |||
| IsActive | ||||
| IntOrdSystemStatusCriticality | IntOrdSystemStatusCriticality | |||
| _InternalOrderTP | _InternalOrderTP | |||
| _LastChangedByUser | _LastChangedByUser |
@ObjectModel: {
usageType: {
serviceQuality: #C,
sizeCategory: #L,
dataClass: #MIXED
}
}
@VDM: {
viewType: #TRANSACTIONAL,
lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #CHECK,
privilegedAssociations: ['_LastChangedByUser']
}
@EndUserText.label: 'Internal order system status'
define view entity R_InternalOrderSystemStatusTP
as select from P_InternalOrderSystemStatus
association to parent R_InternalOrderTP as _InternalOrderTP on $projection.InternalOrder = _InternalOrderTP.InternalOrder
and $projection.InternalOrderDraftInternalUUID = _InternalOrderTP.InternalOrderDraftInternalUUID
{
key InternalOrder,
key cast('00000000000000000000000000000000' as sysuuid_c32) as InternalOrderDraftInternalUUID,
@ObjectModel.text.association:null
key SystemStatus,
SystemStatusShortName,
SystemStatusName,
InternalOrderStatusPlannedDate,
InternalOrderStatusReachedDate,
ControllingObject,
LastChangedByUser,
cast ('' as fin_io_status_is_active) as IsActive,
IntOrdSystemStatusCriticality,
// cast( '0' as fin_io_status_criticality preserving type ) as IntOrdSystemStatusCriticality,
_InternalOrderTP,
_LastChangedByUser
}
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