P_PT_DocItemPartner

DDL: P_PT_DOCITEMPARTNER SQL: PTDOCITEMPARTER Type: view CONSUMPTION
27 Fields 2 Data Sources

View to select all partner and customer line item

P_PT_DocItemPartner is a Consumption CDS View that provides data about "View to select all partner and customer line item" in SAP S/4HANA. It reads from 2 data sources (I_AccountingDocument, I_OperationalAcctgDocItem) and exposes 27 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem.

Data Sources (2)

SourceAliasJoin Type
I_AccountingDocument H inner
I_OperationalAcctgDocItem I from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PTDOCITEMPARTER view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.preserveKey true view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
AbapCatalog.compiler.compareFilter true view
EndUserText.label View to select all partner and customer line item view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
ClearingDate I_OperationalAcctgDocItem ClearingDate Clearing Date
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
Customer I_OperationalAcctgDocItem Customer Sold-to Party
Supplier I_OperationalAcctgDocItem Supplier Supplier
DocumentDate I_OperationalAcctgDocItem DocumentDate Journal Entry Date
DebitCreditCode I_OperationalAcctgDocItem DebitCreditCode Single-Character Flag
WithholdingTaxCode I_OperationalAcctgDocItem WithholdingTaxCode WTax Code
BalanceTransactionCurrency I_OperationalAcctgDocItem BalanceTransactionCurrency Currency
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency Transaction Currency
IsSalesRelated I_OperationalAcctgDocItem IsSalesRelated Is Sales Related
IsUsedInPaymentTransaction I_OperationalAcctgDocItem IsUsedInPaymentTransaction Is Used In Payment Transaction
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
VATRegistration I_OperationalAcctgDocItem VATRegistration VAT Registration No.
CompanyCodeCurrency I_AccountingDocument CompanyCodeCurrency Local Currency
ExchangeRate I_AccountingDocument ExchangeRate Exchange rate
AccountingDocumentType I_AccountingDocument AccountingDocumentType Journal Entry Type
SupplierVATRegistration _Supplier VATRegistration VAT Registration No.
CustomerVATRegistration _Customer VATRegistration VAT Registration No.
VATRegistrationCountry
SupplierVATRegistrationCountry
CustomerVATRegistrationCountry
OneTimeVendor _Supplier IsOneTimeAccount One-time acct
OneTimeCustomer _Customer IsOneTimeAccount One-time acct

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_PT_DocItemPartner.
-- 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: PTDOCITEMPARTER

CREATE VIEW P_PT_DocItemPartner AS
SELECT
  I.CompanyCode AS CompanyCode,
  I.FiscalYear AS FiscalYear,
  I.AccountingDocument AS AccountingDocument,
  I.AccountingDocumentItem AS AccountingDocumentItem,
  I.ClearingDate AS ClearingDate,
  I.PostingDate AS PostingDate,
  I.Customer AS Customer,
  I.Supplier AS Supplier,
  I.DocumentDate AS DocumentDate,
  I.DebitCreditCode AS DebitCreditCode,
  I.WithholdingTaxCode AS WithholdingTaxCode,
  I.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  I.TransactionCurrency AS TransactionCurrency,
  I.IsSalesRelated AS IsSalesRelated,
  I.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  I.FinancialAccountType AS FinancialAccountType,
  I.VATRegistration AS VATRegistration,
  H.CompanyCodeCurrency AS CompanyCodeCurrency,
  H.ExchangeRate AS ExchangeRate,
  H.AccountingDocumentType AS AccountingDocumentType,
  _Supplier.VATRegistration AS SupplierVATRegistration,
  _Customer.VATRegistration AS CustomerVATRegistration,
  left(I.VATRegistration, 2) AS VATRegistrationCountry,
  left(_Supplier.VATRegistration, 2) AS SupplierVATRegistrationCountry,
  left(_Customer.VATRegistration, 2) AS CustomerVATRegistrationCountry,
  _Supplier.IsOneTimeAccount AS OneTimeVendor,
  _Customer.IsOneTimeAccount AS OneTimeCustomer
FROM I_OperationalAcctgDocItem AS I
INNER JOIN I_AccountingDocument AS H ON /* join condition not captured in parsed metadata */
;

Learn More