P_PurchDocFiltered

DDL: P_PURCHDOCFILTERED SQL: PPURCHDOCFLTR Type: view CONSUMPTION
8 Fields 1 Data Sources

Purchasing Document filtered by date

P_PurchDocFiltered is a Consumption CDS View that provides data about "Purchasing Document filtered by date" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocument) and exposes 8 fields with key field PurchasingDocument.

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocument PurchDoc from

Parameters (2)

NameTypeDefault
P_StartDate vdm_validitystart
P_EndDate vdm_validityend

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPURCHDOCFLTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
EndUserText.label Purchasing Document filtered by date view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentCategory I_PurchasingDocument PurchasingDocumentCategory Doc. Category
DocumentCurrency I_PurchasingDocument DocumentCurrency Document Currency
PurchasingDocumentOrderDate I_PurchasingDocument PurchasingDocumentOrderDate PO Date
PurchasingGroup I_PurchasingDocument PurchasingGroup Purchasing Group
CompanyCode I_PurchasingDocument CompanyCode Receiver Company Code
PurchasingOrganization I_PurchasingDocument PurchasingOrganization Purchasing Organization
_PurchasingDocumentCategory _PurchasingDocumentCategory

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 P_PurchDocFiltered.
-- 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: PPURCHDOCFLTR
-- Parameters: P_StartDate : vdm_validitystart, P_EndDate : vdm_validityend

CREATE VIEW P_PurchDocFiltered AS
SELECT
  PurchasingDocument,
  PurchDoc.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchDoc.DocumentCurrency AS DocumentCurrency,
  PurchDoc.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  PurchDoc.PurchasingGroup AS PurchasingGroup,
  PurchDoc.CompanyCode AS CompanyCode,
  PurchDoc.PurchasingOrganization AS PurchasingOrganization
FROM I_PurchasingDocument AS PurchDoc
;

Learn More