P_PurDocItemCurConv

DDL: P_PURDOCITEMCURCONV SQL: PURDOCITEMCUR Type: view CONSUMPTION
28 Fields 3 Data Sources

Purchase Document with Currency Conversion for dates

P_PurDocItemCurConv is a Consumption CDS View that provides data about "Purchase Document with Currency Conversion for dates" in SAP S/4HANA. It reads from 3 data sources (I_CalendarDate, I_PurchasingDocument, I_PurchasingDocumentItem) and exposes 28 fields with key fields PurchasingDocument, PurchasingDocumentItem.

Data Sources (3)

SourceAliasJoin Type
I_CalendarDate Calendar inner
I_PurchasingDocument PurchaseDoc inner
I_PurchasingDocumentItem PurchaseDocItem from

Parameters (1)

NameTypeDefault
P_DisplayCurrency displaycurrency

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PURDOCITEMCUR view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchase Document with Currency Conversion for dates view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocumentItem PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
PurchasingDocumentItemNo
PurchasingDocumentOrderDate I_PurchasingDocument PurchasingDocumentOrderDate PO Date
PurchasingOrganization
PurchasingGroup I_PurchasingDocument PurchasingGroup Purchasing Group
PurchasingGroupName
CompanyCode I_PurchasingDocumentItem CompanyCode Receiver Company Code
Supplier I_PurchasingDocument Supplier Supplier
SupplierCountry
Material I_PurchasingDocumentItem Material Vehicle Model
Plant I_PurchasingDocumentItem Plant Valuation Area
MaterialGroup I_PurchasingDocumentItem MaterialGroup Product Group
PurchasingDocumentCategory I_PurchasingDocument PurchasingDocumentCategory Doc. Category
DocumentCurrency I_PurchasingDocumentItem DocumentCurrency Document Currency
PurchaseContract I_PurchasingDocumentItem PurchaseContract Purchasing Doc.
ProfitCenter I_PurchasingDocumentItem ProfitCenter Profit Center
OrderPriceUnit I_PurchasingDocumentItem OrderPriceUnit Order Price Un.
AccountAssignmentCategory
PurchasingDocumentOrigin I_PurchasingDocument PurchasingDocumentOrigin Status
CreatedByUser I_PurchasingDocument CreatedByUser User Name
MultipleAcctAssgmtDistribution I_PurchasingDocumentItem MultipleAcctAssgmtDistribution Distribution
DisplayCurrency
CalendarYear I_CalendarDate CalendarYear Year
CalendarMonth I_CalendarDate CalendarMonth Calendar Month
CalendarQuarter I_CalendarDate CalendarQuarter Calendar Quarter
CalendarWeek I_CalendarDate CalendarWeek Calendar Week
_Supplier _Supplier

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_PurDocItemCurConv.
-- 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: PURDOCITEMCUR
-- Parameters: P_DisplayCurrency : displaycurrency

CREATE VIEW P_PurDocItemCurConv AS
SELECT
  PurchaseDocItem.PurchasingDocument AS PurchasingDocument,
  PurchaseDocItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  CONCAT( PurchaseDocItem.PurchasingDocument , PurchaseDocItem.PurchasingDocumentItem ) AS PurchasingDocumentItemNo,
  PurchaseDoc.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  cast( PurchaseDoc.PurchasingOrganization as mm_a_purg_org ) AS PurchasingOrganization,
  PurchaseDoc.PurchasingGroup AS PurchasingGroup,
  cast(PurchaseDoc._PurchasingGroup.PurchasingGroupName as mm_a_purg_grp_name ) AS PurchasingGroupName,
  PurchaseDocItem.CompanyCode AS CompanyCode,
  PurchaseDoc.Supplier AS Supplier,
  cast( PurchaseDoc._Supplier._StandardAddress.Country as mm_a_supplier_country ) AS SupplierCountry,
  PurchaseDocItem.Material AS Material,
  PurchaseDocItem.Plant AS Plant,
  PurchaseDocItem.MaterialGroup AS MaterialGroup,
  PurchaseDoc.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchaseDocItem.DocumentCurrency AS DocumentCurrency,
  PurchaseDocItem.PurchaseContract AS PurchaseContract,
  PurchaseDocItem.ProfitCenter AS ProfitCenter,
  PurchaseDocItem.OrderPriceUnit AS OrderPriceUnit,
  PurchaseDocItem. AccountAssignmentCategory AS AccountAssignmentCategory,
  PurchaseDoc.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  PurchaseDoc.CreatedByUser AS CreatedByUser,
  PurchaseDocItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  :P_DisplayCurrency AS DisplayCurrency,
  Calendar.CalendarYear AS CalendarYear,
  Calendar.CalendarMonth AS CalendarMonth,
  Calendar.CalendarQuarter AS CalendarQuarter,
  Calendar.CalendarWeek AS CalendarWeek
FROM I_PurchasingDocumentItem AS PurchaseDocItem
INNER JOIN I_PurchasingDocument AS PurchaseDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_CalendarDate AS Calendar ON /* join condition not captured in parsed metadata */
;

Learn More