C_BOPRblsPyblsItmToFormItemQ

DDL: C_BOPRBLSPYBLSITMTOFORMITEMQ SQL: CBOPRPIFIQ Type: view CONSUMPTION
49 Fields 1 Data Sources

Rbls Pybls Item to BOP Form Item - Query

C_BOPRblsPyblsItmToFormItemQ is a Consumption CDS View that provides data about "Rbls Pybls Item to BOP Form Item - Query" in SAP S/4HANA. It reads from 1 data source (I_BOPRblsPyblsItmToFormItemC) and exposes 49 fields with key fields BOPRptgCntry, BOPForm, BOPFormItem, BOPPartnerCntry, StatryRptgEntity.

Data Sources (1)

SourceAliasJoin Type
I_BOPRblsPyblsItmToFormItemC I_BOPRblsPyblsItmToFormItemC from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CBOPRPIFIQ view
EndUserText.label Rbls Pybls Item to BOP Form Item - Query view
VDM.viewType #CONSUMPTION view
Analytics.query true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY 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

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY BOPRptgCntry I_BOPRblsPyblsItmToFormItemC BOPRptgCntry Reporting Ctry/Reg.
KEY BOPForm I_BOPRblsPyblsItmToFormItemC BOPForm Form
KEY BOPFormItem I_BOPRblsPyblsItmToFormItemC BOPFormItem Form Item
KEY BOPPartnerCntry I_BOPRblsPyblsItmToFormItemC BOPPartnerCntry Country/Reg.
KEY StatryRptgEntity I_BOPRblsPyblsItmToFormItemC StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_BOPRblsPyblsItmToFormItemC StatryRptCategory Report ID
KEY StatryRptRunID I_BOPRblsPyblsItmToFormItemC StatryRptRunID Report Run ID
KEY CompanyCode I_BOPRblsPyblsItmToFormItemC CompanyCode Receiver Company Code
KEY AccountingDocument I_BOPRblsPyblsItmToFormItemC AccountingDocument Journal Entry
KEY FiscalYear I_BOPRblsPyblsItmToFormItemC FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_BOPRblsPyblsItmToFormItemC AccountingDocumentItem Posting View Item
KEY CADocument I_BOPRblsPyblsItmToFormItemC CADocument CA Document No.
KEY CASubItemNumber I_BOPRblsPyblsItmToFormItemC CASubItemNumber Subitem
KEY CABPItemNumber I_BOPRblsPyblsItmToFormItemC CABPItemNumber Item
KEY CARepetitionItemNumber I_BOPRblsPyblsItmToFormItemC CARepetitionItemNumber Repetition Item
KEY CAItemIsOffsetting I_BOPRblsPyblsItmToFormItemC CAItemIsOffsetting CA Item Offset.
KEY CAItemIsDoubtful I_BOPRblsPyblsItmToFormItemC CAItemIsDoubtful CA Item Doubt.
KEY CompanyCodeCountry I_BOPRblsPyblsItmToFormItemC CompanyCodeCountry Reporting Ctry/Reg.
KEY PostingDate I_BOPRblsPyblsItmToFormItemC PostingDate Posting Date for GR
CAReconciliationKey I_BOPRblsPyblsItmToFormItemC CAReconciliationKey Reconcil. Key
BusinessPartner I_BOPRblsPyblsItmToFormItemC BusinessPartner Issuing Authority
CADocumentType I_BOPRblsPyblsItmToFormItemC CADocumentType Document Type
ClearingDate I_BOPRblsPyblsItmToFormItemC ClearingDate Clearing Date
ChartOfAccounts I_BOPRblsPyblsItmToFormItemC ChartOfAccounts Node Class
GLAccount I_BOPRblsPyblsItmToFormItemC GLAccount General Ledger
TaxCode I_BOPRblsPyblsItmToFormItemC TaxCode Tax Code
AccountingDocumentType I_BOPRblsPyblsItmToFormItemC AccountingDocumentType Journal Entry Type
IsEUTriangularDeal I_BOPRblsPyblsItmToFormItemC IsEUTriangularDeal Is EU Triangular Deal
SpecialGLCode I_BOPRblsPyblsItmToFormItemC SpecialGLCode Special G/L Ind
DebitCreditCode I_BOPRblsPyblsItmToFormItemC DebitCreditCode Single-Character Flag
TransactionCurrency I_BOPRblsPyblsItmToFormItemC TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_BOPRblsPyblsItmToFormItemC AmountInTransactionCurrency Pt Crcy Amt
DebitAmountInTransCrcy I_BOPRblsPyblsItmToFormItemC DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy I_BOPRblsPyblsItmToFormItemC CreditAmountInTransCrcy Credit Amt in DC
CompanyCodeCurrency I_BOPRblsPyblsItmToFormItemC CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_BOPRblsPyblsItmToFormItemC AmountInCompanyCodeCurrency Local Crcy Amt
DebitAmountInCoCodeCrcy I_BOPRblsPyblsItmToFormItemC DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy I_BOPRblsPyblsItmToFormItemC CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
ExportAmountInCompanyCodeCrcy I_BOPRblsPyblsItmToFormItemC ExportAmountInCompanyCodeCrcy
ImportAmountInCompanyCodeCrcy I_BOPRblsPyblsItmToFormItemC ImportAmountInCompanyCodeCrcy
ClearingJournalEntry I_BOPRblsPyblsItmToFormItemC ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear I_BOPRblsPyblsItmToFormItemC ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
CAClearingAccountingDocument I_BOPRblsPyblsItmToFormItemC CAClearingAccountingDocument Clearing Doc.
FinancialAccountType I_BOPRblsPyblsItmToFormItemC FinancialAccountType Fin. Account Type
OffsettingAccountType I_BOPRblsPyblsItmToFormItemC OffsettingAccountType Offset Acct Type
OffsettingAccount I_BOPRblsPyblsItmToFormItemC OffsettingAccount Offsetting Acct
PartnerCompany I_BOPRblsPyblsItmToFormItemC PartnerCompany Trading Partner
Customer I_BOPRblsPyblsItmToFormItemC Customer Sold-to Party
Supplier I_BOPRblsPyblsItmToFormItemC Supplier Supplier

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_BOPRblsPyblsItmToFormItemQ.
-- 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: CBOPRPIFIQ

CREATE VIEW C_BOPRblsPyblsItmToFormItemQ AS
SELECT
  I_BOPRblsPyblsItmToFormItemC.BOPRptgCntry AS BOPRptgCntry,
  I_BOPRblsPyblsItmToFormItemC.BOPForm AS BOPForm,
  I_BOPRblsPyblsItmToFormItemC.BOPFormItem AS BOPFormItem,
  I_BOPRblsPyblsItmToFormItemC.BOPPartnerCntry AS BOPPartnerCntry,
  I_BOPRblsPyblsItmToFormItemC.StatryRptgEntity AS StatryRptgEntity,
  I_BOPRblsPyblsItmToFormItemC.StatryRptCategory AS StatryRptCategory,
  I_BOPRblsPyblsItmToFormItemC.StatryRptRunID AS StatryRptRunID,
  I_BOPRblsPyblsItmToFormItemC.CompanyCode AS CompanyCode,
  I_BOPRblsPyblsItmToFormItemC.AccountingDocument AS AccountingDocument,
  I_BOPRblsPyblsItmToFormItemC.FiscalYear AS FiscalYear,
  I_BOPRblsPyblsItmToFormItemC.AccountingDocumentItem AS AccountingDocumentItem,
  I_BOPRblsPyblsItmToFormItemC.CADocument AS CADocument,
  I_BOPRblsPyblsItmToFormItemC.CASubItemNumber AS CASubItemNumber,
  I_BOPRblsPyblsItmToFormItemC.CABPItemNumber AS CABPItemNumber,
  I_BOPRblsPyblsItmToFormItemC.CARepetitionItemNumber AS CARepetitionItemNumber,
  I_BOPRblsPyblsItmToFormItemC.CAItemIsOffsetting AS CAItemIsOffsetting,
  I_BOPRblsPyblsItmToFormItemC.CAItemIsDoubtful AS CAItemIsDoubtful,
  I_BOPRblsPyblsItmToFormItemC.CompanyCodeCountry AS CompanyCodeCountry,
  I_BOPRblsPyblsItmToFormItemC.PostingDate AS PostingDate,
  I_BOPRblsPyblsItmToFormItemC.CAReconciliationKey AS CAReconciliationKey,
  I_BOPRblsPyblsItmToFormItemC.BusinessPartner AS BusinessPartner,
  I_BOPRblsPyblsItmToFormItemC.CADocumentType AS CADocumentType,
  I_BOPRblsPyblsItmToFormItemC.ClearingDate AS ClearingDate,
  I_BOPRblsPyblsItmToFormItemC.ChartOfAccounts AS ChartOfAccounts,
  I_BOPRblsPyblsItmToFormItemC.GLAccount AS GLAccount,
  I_BOPRblsPyblsItmToFormItemC.TaxCode AS TaxCode,
  I_BOPRblsPyblsItmToFormItemC.AccountingDocumentType AS AccountingDocumentType,
  I_BOPRblsPyblsItmToFormItemC.IsEUTriangularDeal AS IsEUTriangularDeal,
  I_BOPRblsPyblsItmToFormItemC.SpecialGLCode AS SpecialGLCode,
  I_BOPRblsPyblsItmToFormItemC.DebitCreditCode AS DebitCreditCode,
  I_BOPRblsPyblsItmToFormItemC.TransactionCurrency AS TransactionCurrency,
  I_BOPRblsPyblsItmToFormItemC.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_BOPRblsPyblsItmToFormItemC.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  I_BOPRblsPyblsItmToFormItemC.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  I_BOPRblsPyblsItmToFormItemC.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_BOPRblsPyblsItmToFormItemC.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_BOPRblsPyblsItmToFormItemC.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  I_BOPRblsPyblsItmToFormItemC.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  I_BOPRblsPyblsItmToFormItemC.ExportAmountInCompanyCodeCrcy AS ExportAmountInCompanyCodeCrcy,
  I_BOPRblsPyblsItmToFormItemC.ImportAmountInCompanyCodeCrcy AS ImportAmountInCompanyCodeCrcy,
  I_BOPRblsPyblsItmToFormItemC.ClearingJournalEntry AS ClearingJournalEntry,
  I_BOPRblsPyblsItmToFormItemC.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  I_BOPRblsPyblsItmToFormItemC.CAClearingAccountingDocument AS CAClearingAccountingDocument,
  I_BOPRblsPyblsItmToFormItemC.FinancialAccountType AS FinancialAccountType,
  I_BOPRblsPyblsItmToFormItemC.OffsettingAccountType AS OffsettingAccountType,
  I_BOPRblsPyblsItmToFormItemC.OffsettingAccount AS OffsettingAccount,
  I_BOPRblsPyblsItmToFormItemC.PartnerCompany AS PartnerCompany,
  I_BOPRblsPyblsItmToFormItemC.Customer AS Customer,
  I_BOPRblsPyblsItmToFormItemC.Supplier AS Supplier
FROM I_BOPRblsPyblsItmToFormItemC
;

Learn More