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

I_MPCustomerClearedItem

DDL: I_MPCUSTOMERCLEAREDITEM SQL: IMPCUSTCLEARITEM Type: view BASIC
11 Fields 2 Data Sources

Master Project Accounting Customer Cleared Item

I_MPCustomerClearedItem is a Basic CDS View that provides data about "Master Project Accounting Customer Cleared Item" in SAP S/4HANA. It reads from 2 data sources (P_MPCustomerClearedItem, I_BillingDocument) and exposes 11 fields.

Data Sources (2)

SourceAliasJoin Type
P_MPCustomerClearedItem AccountClearedItem from
I_BillingDocument Invoice inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMPCUSTCLEARITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Master Project Accounting Customer Cleared Item view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_PurchaseOrderHistory view

Fields (11)

KeyFieldSource TableSource FieldDescription
SalesDocument P_MPCustomerClearedItem vbel2 Sales Document
SalesDocumentItem P_MPCustomerClearedItem posn2 Item
ClearingDate P_MPCustomerClearedItem augdt Clearing
ClearingAccountingDocument P_MPCustomerClearedItem augbl Clrng doc.
AccountingDocument P_MPCustomerClearedItem belnr SD Document
Currency P_MPCustomerClearedItem waers Transaction Currency
ReferenceDocument P_MPCustomerClearedItem xblnr Reference
BillingDocument P_MPCustomerClearedItem vbeln SD Sched. Agmt
PurchasingDocumentAmount P_MPCustomerClearedItem wrbtr Gross Amount
TaxAmount P_MPCustomerClearedItem wmwst Tax Amount
SDDocumentCategory I_BillingDocument SDDocumentCategory Document Cat.

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_MPCustomerClearedItem.
-- 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: IMPCUSTCLEARITEM

CREATE VIEW I_MPCustomerClearedItem AS
SELECT
  AccountClearedItem.vbel2 AS SalesDocument,
  AccountClearedItem.posn2 AS SalesDocumentItem,
  AccountClearedItem.augdt AS ClearingDate,
  AccountClearedItem.augbl AS ClearingAccountingDocument,
  AccountClearedItem.belnr AS AccountingDocument,
  AccountClearedItem.waers AS Currency,
  AccountClearedItem.xblnr AS ReferenceDocument,
  AccountClearedItem.vbeln AS BillingDocument,
  AccountClearedItem.wrbtr AS PurchasingDocumentAmount,
  AccountClearedItem.wmwst AS TaxAmount,
  Invoice.SDDocumentCategory AS SDDocumentCategory
FROM P_MPCustomerClearedItem AS AccountClearedItem
INNER JOIN I_BillingDocument AS Invoice ON /* join condition not captured in parsed metadata */
;

Learn More