P_PT_BOPPartialPaymentItem

DDL: P_PT_BOPPARTIALPAYMENTITEM Type: view_entity COMPOSITE
36 Fields 1 Data Sources

P_PT_BOPPartialPaymentItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 36 fields with key fields CompanyCode, FiscalYear, AccountingDocument, InvoiceReference, InvoiceReferenceFiscalYear.

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem InvoiceItem inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode PaymentItem CompanyCode Receiver Company Code
KEY FiscalYear PaymentItem FiscalYear G/L Fiscal Year
KEY AccountingDocument PaymentItem AccountingDocument Journal Entry
KEY InvoiceReference PaymentItem InvoiceReference Invoice Reference
KEY InvoiceReferenceFiscalYear PaymentItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
KEY InvoiceItemReference PaymentItem InvoiceItemReference Item
FinancialAccountType PaymentItem FinancialAccountType Fin. Account Type
ClearingJournalEntry PaymentItem ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear PaymentItem ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
ClearingItem PaymentItem ClearingItem Clearing Item
AccountingDocumentType PaymentItem AccountingDocumentType Journal Entry Type
Postingdate PaymentItem Postingdate Posting Date for GR
GLAccount PaymentItem GLAccount General Ledger
DocumentDate PaymentItem DocumentDate Journal Entry Date
Customer PaymentItem Customer Sold-to Party
Supplier PaymentItem Supplier Supplier
DebitCreditCode PaymentItem DebitCreditCode Single-Character Flag
CompanyCodeCurrency PaymentItem CompanyCodeCurrency Local Currency
TransactionCurrency PaymentItem TransactionCurrency Transaction Currency
HouseBank PaymentItem HouseBank House Bank
HouseBankAccount PaymentItem HouseBankAccount House Bank Account
SupplierCountry PaymentItem SupplierCountry
CustomerCountry PaymentItem CustomerCountry
OneTimeVendor PaymentItem OneTimeVendor
OneTimeCustomer PaymentItem OneTimeCustomer
OneTimeCountry
PT_BOPBankNumber PaymentItem PT_BOPBankNumber
BankCountryIsoCode PaymentItem BankCountryIsoCode
PT_BOPAccountType PaymentItem PT_BOPAccountType
FollowOnDocumentType PaymentItem FollowOnDocumentType Follow-On Document Type
IsSalesRelated PaymentItem IsSalesRelated Is Sales Related
VATRegistrationendasVATRegistration
AmountInCompanyCodeCurrency PaymentItem AmountInCompanyCodeCurrency Local Crcy Amt
WithholdingTaxAmount PaymentItem WithholdingTaxAmount Withholding Tax Amt
CashDiscountAmount PaymentItem CashDiscountAmount CD Amount
AmountInTransactionCurrency PaymentItem AmountInTransactionCurrency Pt Crcy Amt

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_BOPPartialPaymentItem.
-- 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.

CREATE VIEW P_PT_BOPPartialPaymentItem AS
SELECT
  PaymentItem.CompanyCode AS CompanyCode,
  PaymentItem.FiscalYear AS FiscalYear,
  PaymentItem.AccountingDocument AS AccountingDocument,
  PaymentItem.InvoiceReference AS InvoiceReference,
  PaymentItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  PaymentItem.InvoiceItemReference AS InvoiceItemReference,
  PaymentItem.FinancialAccountType AS FinancialAccountType,
  PaymentItem.ClearingJournalEntry AS ClearingJournalEntry,
  PaymentItem.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  PaymentItem.ClearingItem AS ClearingItem,
  PaymentItem.AccountingDocumentType AS AccountingDocumentType,
  PaymentItem.Postingdate AS Postingdate,
  PaymentItem.GLAccount AS GLAccount,
  PaymentItem.DocumentDate AS DocumentDate,
  PaymentItem.Customer AS Customer,
  PaymentItem.Supplier AS Supplier,
  PaymentItem.DebitCreditCode AS DebitCreditCode,
  PaymentItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  PaymentItem.TransactionCurrency AS TransactionCurrency,
  PaymentItem.HouseBank AS HouseBank,
  PaymentItem.HouseBankAccount AS HouseBankAccount,
  PaymentItem.SupplierCountry AS SupplierCountry,
  PaymentItem.CustomerCountry AS CustomerCountry,
  PaymentItem.OneTimeVendor AS OneTimeVendor,
  PaymentItem.OneTimeCustomer AS OneTimeCustomer,
  InvoiceItem._OneTimeAccountBP.Country AS OneTimeCountry,
  PaymentItem.PT_BOPBankNumber AS PT_BOPBankNumber,
  PaymentItem.BankCountryIsoCode AS BankCountryIsoCode,
  PaymentItem.PT_BOPAccountType AS PT_BOPAccountType,
  PaymentItem.FollowOnDocumentType AS FollowOnDocumentType,
  PaymentItem.IsSalesRelated AS IsSalesRelated,
  case when InvoiceItem.VATRegistration <> '' then InvoiceItem.VATRegistration else PaymentItem.VATRegistration end as VATRegistration AS VATRegistrationendasVATRegistration,
  PaymentItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  PaymentItem.WithholdingTaxAmount AS WithholdingTaxAmount,
  PaymentItem.CashDiscountAmount AS CashDiscountAmount,
  PaymentItem.AmountInTransactionCurrency AS AmountInTransactionCurrency
INNER JOIN I_OperationalAcctgDocItem AS InvoiceItem ON /* join condition not captured in parsed metadata */
;

Learn More