I_FldLogsRetServicePurOrdVH

DDL: I_FLDLOGSRETSERVICEPURORDVH SQL: IFLOGRETSRVCPO Type: view COMPOSITE

Service PO F4 Help for FL Returns

I_FldLogsRetServicePurOrdVH is a Composite CDS View that provides data about "Service PO F4 Help for FL Returns" in SAP S/4HANA. It reads from 3 data sources (I_PurchasingInfoRecord, I_PurchaseOrder, I_PurchasingDocumentItem) and exposes 19 fields.

3 data source(s) 19 fields

Data Sources (3)

SourceAliasJoin Type
I_PurchasingInfoRecord _InfoRec inner
I_PurchaseOrder _POHeader inner
I_PurchasingDocumentItem POItem from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IFLOGRETSRVCPO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Service PO F4 Help for FL Returns view
ObjectModel.dataCategory #VALUE_HELP view

Fields (19)

KeyFieldSource TableSource FieldDescription
PurchaseOrder I_PurchaseOrder PurchaseOrder
PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem
Supplier I_PurchaseOrder Supplier
Plant I_PurchasingDocumentItem Plant
ExpectedOverallLimitAmount I_PurchasingDocumentItem ExpectedOverallLimitAmount
OverallLimitAmount I_PurchasingDocumentItem OverallLimitAmount
DocumentCurrency I_PurchaseOrder DocumentCurrency
Material I_PurchasingInfoRecord Material
PurchasingInfoRecord I_PurchasingInfoRecord PurchasingInfoRecord
PurgDocProductType I_PurchasingDocumentItem ProductType
_Supplier I_PurchaseOrder _Supplier
_DocumentCurrency I_PurchaseOrder _DocumentCurrency
_ProductType I_PurchasingDocumentItem _ProductType
_Plant I_PurchasingDocumentItem _Plant
_Material I_PurchasingInfoRecord _Material
IsEndOfPurposeBlocked I_PurchaseOrder IsEndOfPurposeBlocked
PurchasingDocumentCategory I_PurchasingDocumentItem PurchasingDocumentCategory
PurchasingDocument I_PurchasingDocumentItem PurchasingDocument
_PurchasingDocument I_PurchasingDocumentItem _PurchasingDocument 
@AbapCatalog.sqlViewName: 'IFLOGRETSRVCPO'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Service PO F4 Help for FL Returns'
@ObjectModel.dataCategory: #VALUE_HELP

define view I_FldLogsRetServicePurOrdVH
  as select from I_PurchasingDocumentItem as POItem
    inner join   I_PurchaseOrder          as _POHeader on _POHeader.PurchaseOrder = POItem.PurchasingDocument
    inner join   I_PurchasingInfoRecord   as _InfoRec  on _InfoRec.Supplier = _POHeader.Supplier

{
  _POHeader.PurchaseOrder,
  POItem.PurchasingDocumentItem,
  _POHeader.Supplier,
  POItem.Plant,
  @Semantics.amount.currencyCode: 'DocumentCurrency'
  POItem.ExpectedOverallLimitAmount,
  @Semantics.amount.currencyCode: 'DocumentCurrency'
  POItem.OverallLimitAmount,
  @Semantics.currencyCode: true
  _POHeader.DocumentCurrency,
  _InfoRec.Material,
  _InfoRec.PurchasingInfoRecord,
  POItem.ProductType as PurgDocProductType,
  _POHeader._Supplier,
  _POHeader._DocumentCurrency,
  POItem._ProductType,
  POItem._Plant,
  _InfoRec._Material,
  _POHeader.IsEndOfPurposeBlocked,
  POItem.PurchasingDocumentCategory,
  POItem.PurchasingDocument,
  POItem._PurchasingDocument
}

where
      _InfoRec.PurchasingInfoRecord <> ' '
  and POItem.ProductType            =  '2'
//  and _POHeader.IsEndOfPurposeBlocked =  ''

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDER",
"I_PURCHASINGDOCUMENTITEM",
"I_PURCHASINGINFORECORD"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_MATERIAL",
"I_PLANT",
"I_PRODUCTTYPECODE",
"I_PURCHASINGDOCUMENT",
"I_SUPPLIER"
],
"BASE":
[
"I_PURCHASEORDER",
"I_PURCHASINGDOCUMENTITEM",
"I_PURCHASINGINFORECORD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More