I_BOPRblsPyblsItmToFormItemC

DDL: I_BOPRBLSPYBLSITMTOFORMITEMC Type: view_entity COMPOSITE
43 Fields

Rbls Pybls Item to BOP Form Item - Cube

I_BOPRblsPyblsItmToFormItemC is a Composite CDS View (Cube) that provides data about "Rbls Pybls Item to BOP Form Item - Cube" in SAP S/4HANA.

Annotations (11)

NameValueLevelField
EndUserText.label Rbls Pybls Item to BOP Form Item - Cube view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (43)

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

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 I_BOPRblsPyblsItmToFormItemC.
-- 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 I_BOPRblsPyblsItmToFormItemC AS
SELECT
  P_BOPRblsPyblsItemToFormItemU.CompanyCode AS CompanyCode,
  P_BOPRblsPyblsItemToFormItemU.AccountingDocument AS AccountingDocument,
  P_BOPRblsPyblsItemToFormItemU.FiscalYear AS FiscalYear,
  P_BOPRblsPyblsItemToFormItemU.AccountingDocumentItem AS AccountingDocumentItem,
  P_BOPRblsPyblsItemToFormItemU.CADocument AS CADocument,
  P_BOPRblsPyblsItemToFormItemU.CASubItemNumber AS CASubItemNumber,
  P_BOPRblsPyblsItemToFormItemU.CABPItemNumber AS CABPItemNumber,
  P_BOPRblsPyblsItemToFormItemU.CARepetitionItemNumber AS CARepetitionItemNumber,
  P_BOPRblsPyblsItemToFormItemU.CAItemIsOffsetting AS CAItemIsOffsetting,
  P_BOPRblsPyblsItemToFormItemU.CAItemIsDoubtful AS CAItemIsDoubtful,
  P_BOPRblsPyblsItemToFormItemU.BOPForm AS BOPForm,
  P_BOPRblsPyblsItemToFormItemU.BOPRptgCntry AS BOPRptgCntry,
  P_BOPRblsPyblsItemToFormItemU.BOPFormItem AS BOPFormItem,
  P_BOPRblsPyblsItemToFormItemU.CompanyCodeCountry AS CompanyCodeCountry,
  P_BOPRblsPyblsItemToFormItemU.StatryRptgEntity AS StatryRptgEntity,
  P_BOPRblsPyblsItemToFormItemU.StatryRptCategory AS StatryRptCategory,
  P_BOPRblsPyblsItemToFormItemU.StatryRptRunID AS StatryRptRunID,
  P_BOPRblsPyblsItemToFormItemU.PostingDate AS PostingDate,
  P_BOPRblsPyblsItemToFormItemU.CAReconciliationKey AS CAReconciliationKey,
  P_BOPRblsPyblsItemToFormItemU.BusinessPartner AS BusinessPartner,
  P_BOPRblsPyblsItemToFormItemU.CADocumentType AS CADocumentType,
  P_BOPRblsPyblsItemToFormItemU.ClearingDate AS ClearingDate,
  P_BOPRblsPyblsItemToFormItemU.ChartOfAccounts AS ChartOfAccounts,
  P_BOPRblsPyblsItemToFormItemU.GLAccount AS GLAccount,
  P_BOPRblsPyblsItemToFormItemU.TaxCode AS TaxCode,
  P_BOPRblsPyblsItemToFormItemU.AccountingDocumentType AS AccountingDocumentType,
  P_BOPRblsPyblsItemToFormItemU.IsEUTriangularDeal AS IsEUTriangularDeal,
  P_BOPRblsPyblsItemToFormItemU.SpecialGLCode AS SpecialGLCode,
  P_BOPRblsPyblsItemToFormItemU.DebitCreditCode AS DebitCreditCode,
  P_BOPRblsPyblsItemToFormItemU.TransactionCurrency AS TransactionCurrency,
  P_BOPRblsPyblsItemToFormItemU.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_BOPRblsPyblsItemToFormItemU.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_BOPRblsPyblsItemToFormItemU.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_BOPRblsPyblsItemToFormItemU.ClearingJournalEntry AS ClearingJournalEntry,
  P_BOPRblsPyblsItemToFormItemU.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  P_BOPRblsPyblsItemToFormItemU.CAClearingAccountingDocument AS CAClearingAccountingDocument,
  P_BOPRblsPyblsItemToFormItemU.FinancialAccountType AS FinancialAccountType,
  P_BOPRblsPyblsItemToFormItemU.OffsettingAccountType AS OffsettingAccountType,
  P_BOPRblsPyblsItemToFormItemU.OffsettingAccount AS OffsettingAccount,
  P_BOPRblsPyblsItemToFormItemU.PartnerCompany AS PartnerCompany,
  P_BOPRblsPyblsItemToFormItemU.Customer AS Customer,
  P_BOPRblsPyblsItemToFormItemU.Supplier AS Supplier,
  cast( P_BOPRblsPyblsItemToFormItemU.BOPPartnerCntry as land1 preserving type ) AS BOPPartnerCntry
;

Learn More