P_PurOrdServiceEntryItem

DDL: P_PURORDSERVICEENTRYITEM SQL: PPURORDSERENTI Type: view CONSUMPTION

P_PurOrdServiceEntryItem is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_ServiceEntrySheetItem) and exposes 7 fields with key fields PurchaseOrder, PurchaseOrderItem, ServiceEntrySheet, ServiceEntrySheetItem.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceEntrySheetItem ServiceEntry from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPURORDSERENTI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY ServiceEntrySheet ServiceEntrySheet
KEY ServiceEntrySheetItem ServiceEntrySheetItem
Currency Currency
NetAmount NetAmount
ServicePerformanceDate ServicePerformanceDate 
@AbapCatalog.sqlViewName: 'PPURORDSERENTI'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK

@VDM.private: true
@VDM.viewType: #CONSUMPTION
define view P_PurOrdServiceEntryItem 
as select from I_ServiceEntrySheetItem as ServiceEntry  
{
    key PurchaseOrder,
    key PurchaseOrderItem,
    key ServiceEntrySheet,
    key ServiceEntrySheetItem,   
    
    Currency,
    NetAmount,
    ServicePerformanceDate
    
    
}
where CreationDateTime > 0.0
and IsDeleted = '' and ParentObjectIsDeleted = ''           //3043508

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

Learn More