C_PT_BOPRptdDocumentItemC

DDL: C_PT_BOPRPTDDOCUMENTITEMC Type: view_entity CONSUMPTION Package: GLO_FIN_IS_BOP_PT
32 Fields 1 Data Sources 1 Associations

BOP PT Reported line items - Cube

C_PT_BOPRptdDocumentItemC is a Consumption CDS View (Cube) that provides data about "BOP PT Reported line items - Cube" in SAP S/4HANA. It reads from 1 data source (P_PT_BOPRptdDocItmDerived) and exposes 32 fields with key fields CompanyCode, FiscalYear, AccountingDocument, InvoiceReference, InvoiceReferenceFiscalYear. It has 1 association to related views. Part of development package GLO_FIN_IS_BOP_PT.

Data Sources (1)

SourceAliasJoin Type
P_PT_BOPRptdDocItmDerived PaymentLineItems from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_StRpJournalEntryLog _ReportedItemsLog $projection.CompanyCode = _ReportedItemsLog.CompanyCode and $projection.AccountingDocument = _ReportedItemsLog.AccountingDocument and $projection.FiscalYear = _ReportedItemsLog.FiscalYear

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
EndUserText.label BOP PT Reported line items - Cube view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_PT_BOPRptdDocItmDerived CompanyCode Receiver Company Code
KEY FiscalYear P_PT_BOPRptdDocItmDerived FiscalYear G/L Fiscal Year
KEY AccountingDocument P_PT_BOPRptdDocItmDerived AccountingDocument Journal Entry
KEY InvoiceReference P_PT_BOPRptdDocItmDerived InvoiceReference Invoice Reference
KEY InvoiceReferenceFiscalYear P_PT_BOPRptdDocItmDerived InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
KEY InvoiceItemReference P_PT_BOPRptdDocItmDerived InvoiceItemReference Item
KEY StatryRptCategory _ReportedItemsLog StatryRptCategory Report ID
KEY StatryRptgEntity _ReportedItemsLog StatryRptgEntity Reporting Entity
KEY StatryRptRunID _ReportedItemsLog StatryRptRunID Report Run ID
FinancialAccountType P_PT_BOPRptdDocItmDerived FinancialAccountType Fin. Account Type
AccountingDocumentType P_PT_BOPRptdDocItmDerived AccountingDocumentType Journal Entry Type
PostingDate P_PT_BOPRptdDocItmDerived Postingdate Posting Date for GR
GLAccount P_PT_BOPRptdDocItmDerived GLAccount General Ledger
DocumentDate P_PT_BOPRptdDocItmDerived DocumentDate Journal Entry Date
Customer P_PT_BOPRptdDocItmDerived Customer Sold-to Party
Supplier P_PT_BOPRptdDocItmDerived Supplier Supplier
DebitCreditCode P_PT_BOPRptdDocItmDerived DebitCreditCode Single-Character Flag
WithholdingTaxAmount P_PT_BOPRptdDocItmDerived WithholdingTaxAmount Withholding Tax Amt
CashDiscountAmount P_PT_BOPRptdDocItmDerived CashDiscountAmount CD Amount
AmountInReportingCurrency P_PT_BOPRptdDocItmDerived AmountInReportingCurrency
AmountInTransactionCurrency P_PT_BOPRptdDocItmDerived AmountInTransactionCurrency Pt Crcy Amt
HouseBank P_PT_BOPRptdDocItmDerived HouseBank House Bank
HouseBankAccount P_PT_BOPRptdDocItmDerived HouseBankAccount House Bank Account
VATRegistration P_PT_BOPRptdDocItmDerived VATRegistration VAT Registration No.
StateCentralBankPaymentReason P_PT_BOPRptdDocItmDerived StateCentralBankPaymentReason SCB Ind.
TransactionCurrency P_PT_BOPRptdDocItmDerived TransactionCurrency Transaction Currency
StateCentralBankPaytRsnDesc P_PT_BOPRptdDocItmDerived StateCentralBankPaytRsnDesc
PT_BOPAccountType P_PT_BOPRptdDocItmDerived PT_BOPAccountType
ReviewComment P_PT_BOPRptdDocItmDerived ReviewComment
BankCountry
PT_BOPCtptyCountryISOCode
PT_BOPBankNumber

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 C_PT_BOPRptdDocumentItemC.
-- 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 C_PT_BOPRptdDocumentItemC AS
SELECT
  PaymentLineItems.CompanyCode AS CompanyCode,
  PaymentLineItems.FiscalYear AS FiscalYear,
  PaymentLineItems.AccountingDocument AS AccountingDocument,
  PaymentLineItems.InvoiceReference AS InvoiceReference,
  PaymentLineItems.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  PaymentLineItems.InvoiceItemReference AS InvoiceItemReference,
  _ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  _ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  _ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  PaymentLineItems.FinancialAccountType AS FinancialAccountType,
  PaymentLineItems.AccountingDocumentType AS AccountingDocumentType,
  PaymentLineItems.Postingdate AS PostingDate,
  PaymentLineItems.GLAccount AS GLAccount,
  PaymentLineItems.DocumentDate AS DocumentDate,
  PaymentLineItems.Customer AS Customer,
  PaymentLineItems.Supplier AS Supplier,
  PaymentLineItems.DebitCreditCode AS DebitCreditCode,
  PaymentLineItems.WithholdingTaxAmount AS WithholdingTaxAmount,
  PaymentLineItems.CashDiscountAmount AS CashDiscountAmount,
  PaymentLineItems.AmountInReportingCurrency AS AmountInReportingCurrency,
  PaymentLineItems.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  PaymentLineItems.HouseBank AS HouseBank,
  PaymentLineItems.HouseBankAccount AS HouseBankAccount,
  PaymentLineItems.VATRegistration AS VATRegistration,
  PaymentLineItems.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  PaymentLineItems.TransactionCurrency AS TransactionCurrency,
  PaymentLineItems.StateCentralBankPaytRsnDesc AS StateCentralBankPaytRsnDesc,
  PaymentLineItems.PT_BOPAccountType AS PT_BOPAccountType,
  PaymentLineItems.ReviewComment AS ReviewComment,
  cast(PaymentLineItems.BankCountryIsoCode as banks) AS BankCountry,
  cast(Country.CountryThreeLetterISOCode as fiappt_pais_contraparte ) AS PT_BOPCtptyCountryISOCode,
  cast(PaymentLineItems.PT_BOPBankNumber as fiappt_bankid) AS PT_BOPBankNumber
FROM P_PT_BOPRptdDocItmDerived AS PaymentLineItems
LEFT OUTER JOIN I_StRpJournalEntryLog AS _ReportedItemsLog ON CompanyCode = _ReportedItemsLog.CompanyCode AND AccountingDocument = _ReportedItemsLog.AccountingDocument AND FiscalYear = _ReportedItemsLog.FiscalYear  -- association [0..*]
;

Learn More