C_BE_BOPRevnCostWthCrrtnItmC
BE BOP Revn Cost Item With Corrections - Cube
C_BE_BOPRevnCostWthCrrtnItmC is a Consumption CDS View (Cube) that provides data about "BE BOP Revn Cost Item With Corrections - Cube" in SAP S/4HANA. It reads from 2 data sources (I_BOPRevnCostItmToFormItemC, P_BE_BOPFormItemWithCorrection) and exposes 48 fields with key fields Ledger, SourceLedger, CompanyCode, AccountingDocument, FiscalYear.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_BOPRevnCostItmToFormItemC | I_BOPRevnCostItmToFormItemC | from |
| P_BE_BOPFormItemWithCorrection | P_BE_BOPFormItemWithCorrection | inner |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | BE BOP Revn Cost Item With Corrections - Cube | view | |
| VDM.viewType | #CONSUMPTION | 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 (48)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Ledger | I_BOPRevnCostItmToFormItemC | Ledger | Ledger |
| KEY | SourceLedger | I_BOPRevnCostItmToFormItemC | SourceLedger | Source Ledger |
| KEY | CompanyCode | I_BOPRevnCostItmToFormItemC | CompanyCode | Receiver Company Code |
| KEY | AccountingDocument | I_BOPRevnCostItmToFormItemC | AccountingDocument | Journal Entry |
| KEY | FiscalYear | I_BOPRevnCostItmToFormItemC | FiscalYear | G/L Fiscal Year |
| KEY | LedgerGLLineItem | I_BOPRevnCostItmToFormItemC | LedgerGLLineItem | Journal Entry Item |
| KEY | CADocument | I_BOPRevnCostItmToFormItemC | CADocument | CA Document No. |
| KEY | CAGLItemNumber | I_BOPRevnCostItmToFormItemC | CAGLItemNumber | Item |
| KEY | BOPForm | I_BOPRevnCostItmToFormItemC | BOPForm | Form |
| KEY | BOPRptgCntry | I_BOPRevnCostItmToFormItemC | BOPRptgCntry | Reporting Ctry/Reg. |
| KEY | BOPFormItem | P_BE_BOPFormItemWithCorrection | BOPFormItem | Form Item |
| KEY | CompanyCodeCountry | I_BOPRevnCostItmToFormItemC | CompanyCodeCountry | Reporting Ctry/Reg. |
| KEY | StatryRptgEntity | I_BOPRevnCostItmToFormItemC | StatryRptgEntity | Reporting Entity |
| KEY | StatryRptCategory | I_BOPRevnCostItmToFormItemC | StatryRptCategory | Report ID |
| KEY | StatryRptRunID | I_BOPRevnCostItmToFormItemC | StatryRptRunID | Report Run ID |
| AccountingDocumentItem | I_BOPRevnCostItmToFormItemC | AccountingDocumentItem | Posting View Item | |
| CAReconciliationKey | I_BOPRevnCostItmToFormItemC | CAReconciliationKey | Reconcil. Key | |
| BusinessPartner | I_BOPRevnCostItmToFormItemC | BusinessPartner | Issuing Authority | |
| CADocumentType | I_BOPRevnCostItmToFormItemC | CADocumentType | Document Type | |
| PostingDate | I_BOPRevnCostItmToFormItemC | PostingDate | Posting Date for GR | |
| ClearingDate | I_BOPRevnCostItmToFormItemC | ClearingDate | Clearing Date | |
| ChartOfAccounts | I_BOPRevnCostItmToFormItemC | ChartOfAccounts | Node Class | |
| GLAccount | I_BOPRevnCostItmToFormItemC | GLAccount | General Ledger | |
| TaxCode | I_BOPRevnCostItmToFormItemC | TaxCode | Tax Code | |
| AccountingDocumentType | I_BOPRevnCostItmToFormItemC | AccountingDocumentType | Journal Entry Type | |
| IsEUTriangularDeal | I_BOPRevnCostItmToFormItemC | IsEUTriangularDeal | Is EU Triangular Deal | |
| SpecialGLCode | I_BOPRevnCostItmToFormItemC | SpecialGLCode | Special G/L Ind | |
| DebitCreditCode | I_BOPRevnCostItmToFormItemC | DebitCreditCode | Single-Character Flag | |
| TransactionCurrency | I_BOPRevnCostItmToFormItemC | TransactionCurrency | Transaction Currency | |
| AmountInTransactionCurrency | I_BOPRevnCostItmToFormItemC | AmountInTransactionCurrency | Pt Crcy Amt | |
| DebitAmountInTransCrcy | I_BOPRevnCostItmToFormItemC | DebitAmountInTransCrcy | Debit Amt in DC | |
| CreditAmountInTransCrcy | I_BOPRevnCostItmToFormItemC | CreditAmountInTransCrcy | Credit Amt in DC | |
| CompanyCodeCurrency | I_BOPRevnCostItmToFormItemC | CompanyCodeCurrency | Local Currency | |
| AmountInCompanyCodeCurrency | I_BOPRevnCostItmToFormItemC | AmountInCompanyCodeCurrency | Local Crcy Amt | |
| DebitAmountInCoCodeCrcy | I_BOPRevnCostItmToFormItemC | DebitAmountInCoCodeCrcy | Debit Amount in Company Code Currency | |
| CreditAmountInCoCodeCrcy | I_BOPRevnCostItmToFormItemC | CreditAmountInCoCodeCrcy | Credit Amount in Company Code Currency | |
| ExportAmountInCompanyCodeCrcy | I_BOPRevnCostItmToFormItemC | ExportAmountInCompanyCodeCrcy | ||
| ImportAmountInCompanyCodeCrcy | I_BOPRevnCostItmToFormItemC | ImportAmountInCompanyCodeCrcy | ||
| ClearingJournalEntry | I_BOPRevnCostItmToFormItemC | ClearingJournalEntry | Clrng doc. | |
| ClearingJournalEntryFiscalYear | I_BOPRevnCostItmToFormItemC | ClearingJournalEntryFiscalYear | Fiscal Year of Clearing Journal Entry | |
| CAClearingAccountingDocument | I_BOPRevnCostItmToFormItemC | CAClearingAccountingDocument | Clearing Doc. | |
| FinancialAccountType | I_BOPRevnCostItmToFormItemC | FinancialAccountType | Fin. Account Type | |
| OffsettingAccountType | I_BOPRevnCostItmToFormItemC | OffsettingAccountType | Offset Acct Type | |
| OffsettingAccount | I_BOPRevnCostItmToFormItemC | OffsettingAccount | Offsetting Acct | |
| PartnerCompany | I_BOPRevnCostItmToFormItemC | PartnerCompany | Trading Partner | |
| Customer | I_BOPRevnCostItmToFormItemC | Customer | Sold-to Party | |
| Supplier | I_BOPRevnCostItmToFormItemC | Supplier | Supplier | |
| BOPPartnerCntry | I_BOPRevnCostItmToFormItemC | BOPPartnerCntry | Country/Reg. |
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_BE_BOPRevnCostWthCrrtnItmC.
-- 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_BE_BOPRevnCostWthCrrtnItmC AS
SELECT
I_BOPRevnCostItmToFormItemC.Ledger AS Ledger,
I_BOPRevnCostItmToFormItemC.SourceLedger AS SourceLedger,
I_BOPRevnCostItmToFormItemC.CompanyCode AS CompanyCode,
I_BOPRevnCostItmToFormItemC.AccountingDocument AS AccountingDocument,
I_BOPRevnCostItmToFormItemC.FiscalYear AS FiscalYear,
I_BOPRevnCostItmToFormItemC.LedgerGLLineItem AS LedgerGLLineItem,
I_BOPRevnCostItmToFormItemC.CADocument AS CADocument,
I_BOPRevnCostItmToFormItemC.CAGLItemNumber AS CAGLItemNumber,
I_BOPRevnCostItmToFormItemC.BOPForm AS BOPForm,
I_BOPRevnCostItmToFormItemC.BOPRptgCntry AS BOPRptgCntry,
P_BE_BOPFormItemWithCorrection.BOPFormItem AS BOPFormItem,
I_BOPRevnCostItmToFormItemC.CompanyCodeCountry AS CompanyCodeCountry,
I_BOPRevnCostItmToFormItemC.StatryRptgEntity AS StatryRptgEntity,
I_BOPRevnCostItmToFormItemC.StatryRptCategory AS StatryRptCategory,
I_BOPRevnCostItmToFormItemC.StatryRptRunID AS StatryRptRunID,
I_BOPRevnCostItmToFormItemC.AccountingDocumentItem AS AccountingDocumentItem,
I_BOPRevnCostItmToFormItemC.CAReconciliationKey AS CAReconciliationKey,
I_BOPRevnCostItmToFormItemC.BusinessPartner AS BusinessPartner,
I_BOPRevnCostItmToFormItemC.CADocumentType AS CADocumentType,
I_BOPRevnCostItmToFormItemC.PostingDate AS PostingDate,
I_BOPRevnCostItmToFormItemC.ClearingDate AS ClearingDate,
I_BOPRevnCostItmToFormItemC.ChartOfAccounts AS ChartOfAccounts,
I_BOPRevnCostItmToFormItemC.GLAccount AS GLAccount,
I_BOPRevnCostItmToFormItemC.TaxCode AS TaxCode,
I_BOPRevnCostItmToFormItemC.AccountingDocumentType AS AccountingDocumentType,
I_BOPRevnCostItmToFormItemC.IsEUTriangularDeal AS IsEUTriangularDeal,
I_BOPRevnCostItmToFormItemC.SpecialGLCode AS SpecialGLCode,
I_BOPRevnCostItmToFormItemC.DebitCreditCode AS DebitCreditCode,
I_BOPRevnCostItmToFormItemC.TransactionCurrency AS TransactionCurrency,
I_BOPRevnCostItmToFormItemC.AmountInTransactionCurrency AS AmountInTransactionCurrency,
I_BOPRevnCostItmToFormItemC.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
I_BOPRevnCostItmToFormItemC.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
I_BOPRevnCostItmToFormItemC.CompanyCodeCurrency AS CompanyCodeCurrency,
I_BOPRevnCostItmToFormItemC.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
I_BOPRevnCostItmToFormItemC.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
I_BOPRevnCostItmToFormItemC.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
I_BOPRevnCostItmToFormItemC.ExportAmountInCompanyCodeCrcy AS ExportAmountInCompanyCodeCrcy,
I_BOPRevnCostItmToFormItemC.ImportAmountInCompanyCodeCrcy AS ImportAmountInCompanyCodeCrcy,
I_BOPRevnCostItmToFormItemC.ClearingJournalEntry AS ClearingJournalEntry,
I_BOPRevnCostItmToFormItemC.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
I_BOPRevnCostItmToFormItemC.CAClearingAccountingDocument AS CAClearingAccountingDocument,
I_BOPRevnCostItmToFormItemC.FinancialAccountType AS FinancialAccountType,
I_BOPRevnCostItmToFormItemC.OffsettingAccountType AS OffsettingAccountType,
I_BOPRevnCostItmToFormItemC.OffsettingAccount AS OffsettingAccount,
I_BOPRevnCostItmToFormItemC.PartnerCompany AS PartnerCompany,
I_BOPRevnCostItmToFormItemC.Customer AS Customer,
I_BOPRevnCostItmToFormItemC.Supplier AS Supplier,
I_BOPRevnCostItmToFormItemC.BOPPartnerCntry AS BOPPartnerCntry
FROM I_BOPRevnCostItmToFormItemC
INNER JOIN P_BE_BOPFormItemWithCorrection ON /* join condition not captured in parsed metadata */
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA