C_MaintOrderSubOperationTP_2
Maint Order SubOperation Details View
C_MaintOrderSubOperationTP_2 is a Consumption CDS View that provides data about "Maint Order SubOperation Details View" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderSubOperation) and exposes 16 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MaintenanceOrderSubOperation | I_MaintenanceOrderSubOperation | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_PersonWorkAgreement_1 | _PersonWorkAgreement | $projection.OperationPersonResponsible = _PersonWorkAgreement.PersonWorkAgreement |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CMAINTORDSUBOP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| VDM.viewType | #CONSUMPTION | view | |
| EndUserText.label | Maint Order SubOperation Details View | view |
Fields (16)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaintenanceOrder | MaintenanceOrder | ||
| KEY | MaintenanceOrderOperation | |||
| KEY | MaintenanceOrderSubOperation | |||
| MaintOrderOperationLongText | Long Text | |||
| OperationHasLongText | OperationHasLongText | |||
| WorkCenter | _WorkCenter | WorkCenter | ||
| WorkCenterText | ||||
| OperationPersonResponsible | OperationPersonResponsible | |||
| PersonFullName | _PersonWorkAgreement | PersonFullName | ||
| OperationPlannedWork | _OperationPlanningValues | OperationPlannedWork | ||
| OperationPlannedWorkUnit | _OperationPlanningValues | OperationPlannedWorkUnit | ||
| MaintOrderOperationInternalID | MaintOrderOperationInternalID | |||
| OperationSupplier | OperationSupplier | |||
| _MaintenanceOrder | _MaintenanceOrder | |||
| _PersonResponsible | _PersonResponsible | |||
| _Supplier | _Supplier |
@AbapCatalog.sqlViewName: 'CMAINTORDSUBOP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM: {
viewType: #CONSUMPTION
}
@EndUserText.label: 'Maint Order SubOperation Details View'
define view C_MaintOrderSubOperationTP_2
as select from I_MaintenanceOrderSubOperation
association [0..1] to I_PersonWorkAgreement_1 as _PersonWorkAgreement on $projection.OperationPersonResponsible = _PersonWorkAgreement.PersonWorkAgreement
{
key MaintenanceOrder,
key cast(MaintenanceOrderOperation as maintenanceorderoperation preserving type) as MaintenanceOrderOperation,
@UI.lineItem: [{position: 10, label: 'Suboperation' }]
key cast(MaintenanceOrderSubOperation as maintenanceorderoperation preserving type) as MaintenanceOrderSubOperation,
@EndUserText.label: 'Long Text'
@UI.lineItem: [{position: 20}]
@Semantics.text: true
cast (' ' as abap.sstring( 1333 )) as MaintOrderOperationLongText,
@UI.hidden: true
OperationHasLongText,
@UI.lineItem: [{position: 30, label: 'Work Center' }]
@ObjectModel.text.element: ['WorkCenterText']
_WorkCenter.WorkCenter,
_WorkCenter._Text[1:Language=$session.system_language].WorkCenterText,
@ObjectModel.text.element: ['PersonFullName']
@UI.lineItem: [{position: 40, label: 'Assigned To' }]
OperationPersonResponsible,
_PersonWorkAgreement.PersonFullName,
@UI.lineItem: [{position: 50, label: 'Planned Work' }]
_OperationPlanningValues.OperationPlannedWork,
_OperationPlanningValues.OperationPlannedWorkUnit,
@Consumption.hidden: true
MaintOrderOperationInternalID,
@Consumption.hidden: true
OperationSupplier,
_MaintenanceOrder,
_PersonResponsible,
_Supplier
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDERSUBOPERATION",
"I_MAINTORDEROPERPLANNINGVALUES",
"I_PERSONWORKAGREEMENT_1",
"I_WORKCENTER",
"I_WORKCENTERTEXT"
],
"ASSOCIATED":
[
"I_MAINTENANCEORDER",
"I_PERSONWORKAGREEMENT_1",
"I_SUPPLIER"
],
"BASE":
[
"I_MAINTENANCEORDERSUBOPERATION"
],
"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