I_FldLogsPurchaseOrderVH

DDL: I_FLDLOGSPURCHASEORDERVH SQL: IFLPOVH Type: view COMPOSITE Package: ODATA_FLOG_PROCESS_RECEIPTS
11 Fields 2 Data Sources 1 OData Services

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. It is exposed through 1 OData service (ASQL_F5082). Part of development package ODATA_FLOG_PROCESS_RECEIPTS.

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

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F5082 ASQL_F5082 C2 NOT_RELEASED

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder PurchasingDocument Purchasing Document
Supplier PurchaseOrder Supplier Supplier
PurchasingGroup PurchaseOrder PurchasingGroup Purchasing Group
CompanyCode PurchaseOrder CompanyCode Receiver Company Code
ReleaseIsNotCompleted PurchaseOrder ReleaseIsNotCompleted Subj.to Release
PurchasingCompletenessStatus PurchaseOrder PurchasingCompletenessStatus Incomplete
PurchasingDocumentType PurchaseOrder PurchasingDocumentType RFQ Type
PurchasingDocumentOrigin PurchaseOrder PurchasingDocumentOrigin Status
PurchasingDocumentCategory PurchaseOrder PurchasingDocumentCategory Doc. Category
PurchasingOrganization PurchaseOrder PurchasingOrganization Purchasing Organization
IsEndOfPurposeBlocked PurchaseOrder IsEndOfPurposeBlocked Busin. Purp. Cmpltd.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_FldLogsPurchaseOrderVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFLPOVH

CREATE VIEW I_FldLogsPurchaseOrderVH AS
SELECT
  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 AS PurchasingDocumentType,
  PurchaseOrder.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  PurchaseOrder.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
INNER JOIN I_PurchasingDocumentItem AS _PurchaseOrderItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_FldLogsAllPlantsVH AS _FldLogsAllPlants ON /* join condition not captured in parsed metadata */
;

Learn More