I_FldLogsPurchaseOrderVH

DDL: I_FLDLOGSPURCHASEORDERVH SQL: IFLPOVH Type: view COMPOSITE

Field Logistics : Process Receipts PO Value Help

I_FldLogsPurchaseOrderVH is a Composite CDS View that provides data about "Field Logistics : Process Receipts PO Value Help" in SAP S/4HANA. It reads from 2 data sources (I_FldLogsAllPlantsVH, I_PurchasingDocumentItem) and exposes 11 fields with key field PurchaseOrder.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_FldLogsAllPlantsVH _FldLogsAllPlants inner
I_PurchasingDocumentItem _PurchaseOrderItem inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFLPOVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Field Logistics : Process Receipts PO Value Help view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder PurchasingDocument
Supplier PurchaseOrder Supplier
PurchasingGroup PurchaseOrder PurchasingGroup
CompanyCode PurchaseOrder CompanyCode
ReleaseIsNotCompleted PurchaseOrder ReleaseIsNotCompleted
PurchasingCompletenessStatus PurchaseOrder PurchasingCompletenessStatus
PurchasingDocumentType PurchaseOrder PurchasingDocumentType
PurchasingDocumentOrigin PurchaseOrder PurchasingDocumentOrigin
PurchasingDocumentCategory PurchaseOrder PurchasingDocumentCategory
PurchasingOrganization PurchaseOrder PurchasingOrganization
IsEndOfPurposeBlocked PurchaseOrder IsEndOfPurposeBlocked 
@AbapCatalog.sqlViewName: 'IFLPOVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Field Logistics : Process Receipts PO Value Help'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.dataCategory: #VALUE_HELP
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_FldLogsPurchaseOrderVH
  as select distinct from   I_PurchasingDocument      as PurchaseOrder
  // Item

    inner join I_PurchasingDocumentItem  as _PurchaseOrderItem on PurchaseOrder.PurchasingDocument = _PurchaseOrderItem.PurchasingDocument
  // FL Plants Only

    inner join              I_FldLogsAllPlantsVH as _FldLogsAllPlants  on _PurchaseOrderItem.Plant = _FldLogsAllPlants.Plant

{

  key PurchaseOrder.PurchasingDocument                as PurchaseOrder,
      PurchaseOrder.Supplier                     as Supplier,
      PurchaseOrder.PurchasingGroup              as PurchasingGroup,
      PurchaseOrder.CompanyCode                  as CompanyCode,
      PurchaseOrder.ReleaseIsNotCompleted        as ReleaseIsNotCompleted,
      PurchaseOrder.PurchasingCompletenessStatus as PurchasingCompletenessStatus,
      PurchaseOrder.PurchasingDocumentType,
      PurchaseOrder.PurchasingDocumentOrigin,
      PurchaseOrder.PurchasingDocumentCategory,
      PurchaseOrder.PurchasingOrganization,
      PurchaseOrder.IsEndOfPurposeBlocked
}
//where

//  (

//       PurchaseOrder.IsEndOfPurposeBlocked <> 'X'

//    or PurchaseOrder.IsEndOfPurposeBlocked is null

//  )

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

Learn More