C_WrkOrdForOPg

DDL: C_WRKORDFOROPG SQL: CWRKORDDET Type: view CONSUMPTION

Work Order Details for Object Page

C_WrkOrdForOPg is a Consumption CDS View that provides data about "Work Order Details for Object Page" in SAP S/4HANA. It reads from 2 data sources (I_ServicePerformerToSuplr, I_Supplier) and exposes 9 fields with key fields Person, BusinessPartnerSupplier, EndDate.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_ServicePerformerToSuplr supplier from
I_Supplier supplierdet left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CWRKORDDET view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Work Order Details for Object Page view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Person I_ServicePerformerToSuplr Person
KEY BusinessPartnerSupplier I_ServicePerformerToSuplr BusinessPartnerSupplier Supplier
KEY EndDate I_ServicePerformerToSuplr EndDate End Date
SupplierName I_Supplier SupplierName
StartDate I_ServicePerformerToSuplr StartDate Start Date
Supplier
RelationshipCategory I_ServicePerformerToSuplr RelationshipCategory
_ServicePerformer _ServicePerformer
_BusinessPartnerSupplier _BusinessPartnerSupplier 
@AbapCatalog.sqlViewName: 'CWRKORDDET'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Work Order Details for Object Page'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.personalData.blocking: #REQUIRED
define view C_WrkOrdForOPg
  as select from    I_ServicePerformerToSuplr as supplier
    left outer join I_Supplier                as supplierdet on supplier.BusinessPartnerSupplier = supplierdet.Supplier
{
      @UI.hidden: true
  key supplier.Person,
      @UI.lineItem:{ position: 10, value: 'BusinessPartnerSupplier', label: 'Supplier', importance: #HIGH, type: #WITH_URL, url: 'Supplier'  }
      @EndUserText.label: 'Supplier'
  key supplier.BusinessPartnerSupplier,
      @UI.lineItem:[{ position: 40, importance: #HIGH}]
      @EndUserText.label: 'End Date'
  key supplier.EndDate,
      @UI.lineItem:[{ position: 20, importance: #HIGH}]
      supplierdet.SupplierName,
      //supplierdet.BusinessPartnerName,

      @UI.lineItem:[{ position: 30, importance: #HIGH}]
      @EndUserText.label: 'Start Date'
      supplier.StartDate,
      @UI.hidden: true
      concat( '#Supplier-displayFactSheet?Supplier=', BusinessPartnerSupplier) as Supplier ,
      @UI.hidden: true
      supplier.RelationshipCategory                                            as RelationshipCategory,
      /* Associations */
      _ServicePerformer,
      _BusinessPartnerSupplier

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEPERFORMERTOSUPLR",
"I_SUPPLIER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER"
],
"BASE":
[
"I_SERVICEPERFORMERTOSUPLR"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More