Deprecated
This CDS view is deprecated in S/4HANA. Use P_purgdocconf instead. View all deprecated CDS views →

P_SuplrConfItems

DDL: P_SUPLRCONFITEMS SQL: PSUPLRCONFITEMS Type: view CONSUMPTION
36 Fields 2 Data Sources 2 Associations

Private View for Visual Filters

P_SuplrConfItems is a Consumption CDS View that provides data about "Private View for Visual Filters" in SAP S/4HANA. It reads from 2 data sources (P_PurgDocSuplrConfQtyAggrgn, P_PurgDocSuplrConf) and exposes 36 fields with key fields PurchasingDocument, PurchasingDocumentItem. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_PurgDocSuplrConfQtyAggrgn _ekes left_outer
P_PurgDocSuplrConf _eket from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[1..1] C_PurchasingDocStatus _PDStatus _PDStatus.PurchaseOrder = $projection.PurchasingDocument

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PSUPLRCONFITEMS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Private View for Visual Filters view
VDM.viewType #CONSUMPTION view
VDM.private true view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor P_purgdocconf view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument P_PurgDocSuplrConf PurchasingDocumentNumber Purchasing Document
KEY PurchasingDocumentItem P_PurgDocSuplrConf PurchasingDocumentItemNumber Purchasing Doc. Item
ScheduleLine P_PurgDocSuplrConf ScheduleLine Schedule Line
AccountAssignmentCategory P_PurgDocSuplrConf AccountAssignmentCategory Acct Assgmt Cat
CompanyCodeName P_PurgDocSuplrConf CompanyCodeName Company Name
PurchasingGroup P_PurgDocSuplrConf PurchasingGroup Purchasing Group
ConfirmationControl P_PurgDocSuplrConf ConfirmationControl Conf. Control
PurchasingOrganization P_PurgDocSuplrConf PurchasingOrganization Purchasing Organization
PurchasingDocumentType P_PurgDocSuplrConf PurchasingDocumentType RFQ Type
DocumentDate P_PurgDocSuplrConf DocumentDate Journal Entry Date
DelivDateCategory P_PurgDocSuplrConf DelivDateCategory Delivery Date
Supplier P_PurgDocSuplrConf Supplier Supplier
DocumentCurrency P_PurgDocSuplrConf DocumentCurrency Document Currency
SupplierName P_PurgDocSuplrConf SupplierName Supplier Name
PurchasingDocumentCategory P_PurgDocSuplrConf PurchasingDocumentCategory Doc. Category
OrderQuantity P_PurgDocSuplrConf OrderQuantity Quantity
NetAmount P_PurgDocSuplrConf NetAmount Stated Amount
PurchasingDocumentDeletionCode P_PurgDocSuplrConf PurchasingDocumentDeletionCode Del. Indicator
CompanyCode P_PurgDocSuplrConf CompanyCode Receiver Company Code
PurchasingDocumentItemCategory P_PurgDocSuplrConf PurchasingDocumentItemCategory Item Category
MaterialNumber P_PurgDocSuplrConf MaterialNumber Material
ShortText P_PurgDocSuplrConf ShortText Text
Plant P_PurgDocSuplrConf Plant Valuation Area
OrderUnit P_PurgDocSuplrConf OrderUnit Commercial
CummulativeSheduleQuantity P_PurgDocSuplrConf CummulativeSheduleQuantity
DeliveryDate P_PurgDocSuplrConf ItemDeliveryDate Delivery Date
SupplierConfirmationCategory P_PurgDocSuplrConf SupplierConfirmationCategory Confirm. Cat.
OrderedQuantity
CommittedQuantity
BalanceQuantity
KeyDate P_PurgDocSuplrConf KeyDate Maturity Key Date
PurchasingDocumentStatusName _PDStatus PurchasingDocumentStatusName
PurchaseOrderType _PDStatus PurchaseOrderType PO Type
SupplierAccountGroup _Supplier SupplierAccountGroup Account group
AuthorizationGroup _Supplier AuthorizationGroup AuthorizGroup
_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_SuplrConfItems.
-- 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: PSUPLRCONFITEMS

CREATE VIEW P_SuplrConfItems AS
SELECT
  _eket.PurchasingDocumentNumber AS PurchasingDocument,
  _eket.PurchasingDocumentItemNumber AS PurchasingDocumentItem,
  _eket.ScheduleLine AS ScheduleLine,
  _eket.AccountAssignmentCategory AS AccountAssignmentCategory,
  _eket.CompanyCodeName AS CompanyCodeName,
  _eket.PurchasingGroup AS PurchasingGroup,
  _eket.ConfirmationControl AS ConfirmationControl,
  _eket.PurchasingOrganization AS PurchasingOrganization,
  _eket.PurchasingDocumentType AS PurchasingDocumentType,
  _eket.DocumentDate AS DocumentDate,
  _eket.DelivDateCategory AS DelivDateCategory,
  _eket.Supplier AS Supplier,
  _eket.DocumentCurrency AS DocumentCurrency,
  _eket.SupplierName AS SupplierName,
  _eket.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _eket.OrderQuantity AS OrderQuantity,
  _eket.NetAmount AS NetAmount,
  _eket.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  _eket.CompanyCode AS CompanyCode,
  _eket.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _eket.MaterialNumber AS MaterialNumber,
  _eket.ShortText AS ShortText,
  _eket.Plant AS Plant,
  _eket.OrderUnit AS OrderUnit,
  _eket.CummulativeSheduleQuantity AS CummulativeSheduleQuantity,
  _eket.ItemDeliveryDate AS DeliveryDate,
  _eket.SupplierConfirmationCategory AS SupplierConfirmationCategory,
  cast(_eket.ScheduledQuantity as abap.quan(13)) AS OrderedQuantity,
  _ekes.CommittedQuantity - _eket.CummulativeSheduleQuantity AS CommittedQuantity,
  cast(_eket.ScheduledQuantity + (_ekes.CommittedQuantity - _eket.CummulativeSheduleQuantity) as abap.quan(13)) AS BalanceQuantity,
  _eket.KeyDate AS KeyDate,
  _PDStatus.PurchasingDocumentStatusName AS PurchasingDocumentStatusName,
  _PDStatus.PurchaseOrderType AS PurchaseOrderType,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.AuthorizationGroup AS AuthorizationGroup
FROM P_PurgDocSuplrConf AS _eket
LEFT OUTER JOIN P_PurgDocSuplrConfQtyAggrgn AS _ekes ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN C_PurchasingDocStatus AS _PDStatus ON _PDStatus.PurchaseOrder = PurchasingDocument  -- association [1..1]
;

Learn More