P_PT_BOPMiscellaneousDocItem

DDL: P_PT_BOPMISCELLANEOUSDOCITEM Type: view_entity COMPOSITE Package: GLO_FIN_IS_BOP_PT
39 Fields 2 Data Sources

Select others line item for BOP portugal

P_PT_BOPMiscellaneousDocItem is a Composite CDS View that provides data about "Select others line item for BOP portugal" in SAP S/4HANA. It reads from 2 data sources (P_PT_BOPAccountingDocumentItem, P_PT_BOPAcctgDocItmMinimum) and exposes 39 fields with key fields CompanyCode, FiscalYear, AccountingDocument, InvoiceReference, InvoiceReferenceFiscalYear. Part of development package GLO_FIN_IS_BOP_PT.

Data Sources (2)

SourceAliasJoin Type
P_PT_BOPAccountingDocumentItem PaymentItem inner
P_PT_BOPAcctgDocItmMinimum PaymentMin inner

Annotations (7)

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

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode InvoiceItem CompanyCode Receiver Company Code
KEY FiscalYear InvoiceItem FiscalYear G/L Fiscal Year
KEY AccountingDocument InvoiceItem AccountingDocument Journal Entry
KEY InvoiceReference InvoiceItem AccountingDocument Journal Entry
KEY InvoiceReferenceFiscalYear InvoiceItem FiscalYear G/L Fiscal Year
KEY InvoiceItemReference InvoiceItem AccountingDocumentItem Posting View Item
FinancialAccountType InvoiceItem FinancialAccountType Fin. Account Type
ClearingJournalEntry InvoiceItem ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear InvoiceItem ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
ClearingItem InvoiceItem ClearingItem Clearing Item
AccountingDocumentType P_PT_BOPAccountingDocumentItem AccountingDocumentType Journal Entry Type
Postingdate P_PT_BOPAccountingDocumentItem Postingdate Posting Date for GR
DocumentDate P_PT_BOPAccountingDocumentItem DocumentDate Journal Entry Date
GLAccount P_PT_BOPAccountingDocumentItem GLAccount General Ledger
Customer P_PT_BOPAccountingDocumentItem Customer Sold-to Party
Supplier P_PT_BOPAccountingDocumentItem Supplier Supplier
CompanyCodeCurrency InvoiceItem CompanyCodeCurrency Local Currency
TransactionCurrency InvoiceItem TransactionCurrency Transaction Currency
HouseBank P_PT_BOPAccountingDocumentItem HouseBank House Bank
HouseBankAccount P_PT_BOPAccountingDocumentItem HouseBankAccount House Bank Account
SupplierCountry P_PT_BOPAccountingDocumentItem SupplierCountry
CustomerCountry P_PT_BOPAccountingDocumentItem CustomerCountry
OneTimeVendor P_PT_BOPAccountingDocumentItem OneTimeVendor
OneTimeCustomer P_PT_BOPAccountingDocumentItem OneTimeCustomer
OneTimeCountry P_PT_BOPAccountingDocumentItem OneTimeCountry
PT_BOPBankNumber P_PT_BOPAccountingDocumentItem PT_BOPBankNumber
BankCountryIsoCode P_PT_BOPAccountingDocumentItem BankCountryIsoCode
PT_BOPAccountType P_PT_BOPAccountingDocumentItem PT_BOPAccountType
FollowOnDocumentType P_PT_BOPAccountingDocumentItem FollowOnDocumentType Follow-On Document Type
IsSalesRelated P_PT_BOPAccountingDocumentItem IsSalesRelated Is Sales Related
DebitCreditCode InvoiceItem DebitCreditCode Single-Character Flag
StateCentralBankPaymentReason P_PT_BOPAccountingDocumentItem StateCentralBankPaymentReason SCB Ind.
StateCentralBankPaytRsnDesc P_PT_BOPAccountingDocumentItem StateCentralBankPaytRsnDesc
VATRegistration P_PT_BOPAccountingDocumentItem VATRegistration VAT Registration No.
VATRegistrationCountry P_PT_BOPAccountingDocumentItem VATRegistrationCountry CtryRgnSlsTxNo.
AmountInCompanyCodeCurrency
WithholdingTaxAmount
CashDiscountAmount
AmountInTransactionCurrency

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_BOPMiscellaneousDocItem.
-- 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_BOPMiscellaneousDocItem AS
SELECT
  InvoiceItem.CompanyCode AS CompanyCode,
  InvoiceItem.FiscalYear AS FiscalYear,
  InvoiceItem.AccountingDocument AS AccountingDocument,
  InvoiceItem.AccountingDocument AS InvoiceReference,
  InvoiceItem.FiscalYear AS InvoiceReferenceFiscalYear,
  InvoiceItem.AccountingDocumentItem AS InvoiceItemReference,
  InvoiceItem.FinancialAccountType AS FinancialAccountType,
  InvoiceItem.ClearingJournalEntry AS ClearingJournalEntry,
  InvoiceItem.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  InvoiceItem.ClearingItem AS ClearingItem,
  PaymentItem.AccountingDocumentType AS AccountingDocumentType,
  PaymentItem.Postingdate AS Postingdate,
  PaymentItem.DocumentDate AS DocumentDate,
  PaymentItem.GLAccount AS GLAccount,
  PaymentItem.Customer AS Customer,
  PaymentItem.Supplier AS Supplier,
  InvoiceItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  InvoiceItem.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,
  PaymentItem.OneTimeCountry 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,
  InvoiceItem.DebitCreditCode AS DebitCreditCode,
  PaymentItem.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  PaymentItem.StateCentralBankPaytRsnDesc AS StateCentralBankPaytRsnDesc,
  PaymentItem.VATRegistration AS VATRegistration,
  PaymentItem.VATRegistrationCountry AS VATRegistrationCountry,
  abs(InvoiceItem.AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  abs(InvoiceItem.WithholdingTaxAmount) AS WithholdingTaxAmount,
  abs(InvoiceItem.CashDiscountAmount) AS CashDiscountAmount,
  abs(InvoiceItem.AmountInTransactionCurrency) AS AmountInTransactionCurrency
INNER JOIN P_PT_BOPAcctgDocItmMinimum AS PaymentMin ON /* join condition not captured in parsed metadata */
INNER JOIN P_PT_BOPAccountingDocumentItem AS PaymentItem ON /* join condition not captured in parsed metadata */
;

Learn More