C_BE_BOPRevnCostWthCrrtnItmQ
BE BOP Revn Cost Item With Corrections - Query
C_BE_BOPRevnCostWthCrrtnItmQ is a Consumption CDS View that provides data about "BE BOP Revn Cost Item With Corrections - Query" in SAP S/4HANA. It reads from 1 data source (C_BE_BOPRevnCostWthCrrtnItmC) and exposes 48 fields with key fields BOPRptgCntry, BOPForm, BOPFormItem, BOPPartnerCntry, StatryRptgEntity. Part of development package GLO_FIN_IS_BOP_BE.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| C_BE_BOPRevnCostWthCrrtnItmC | C_BE_BOPRevnCostWthCrrtnItmC | from |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CBEBOPRCIWCIQ | view | |
| EndUserText.label | BE BOP Revn Cost Item With Corrections - 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 (48)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BOPRptgCntry | C_BE_BOPRevnCostWthCrrtnItmC | BOPRptgCntry | Reporting Ctry/Reg. |
| KEY | BOPForm | C_BE_BOPRevnCostWthCrrtnItmC | BOPForm | Form |
| KEY | BOPFormItem | C_BE_BOPRevnCostWthCrrtnItmC | BOPFormItem | Form Item |
| KEY | BOPPartnerCntry | C_BE_BOPRevnCostWthCrrtnItmC | BOPPartnerCntry | Country/Reg. |
| KEY | StatryRptgEntity | C_BE_BOPRevnCostWthCrrtnItmC | StatryRptgEntity | Reporting Entity |
| KEY | StatryRptCategory | C_BE_BOPRevnCostWthCrrtnItmC | StatryRptCategory | Report ID |
| KEY | StatryRptRunID | C_BE_BOPRevnCostWthCrrtnItmC | StatryRptRunID | Report Run ID |
| KEY | Ledger | C_BE_BOPRevnCostWthCrrtnItmC | Ledger | Ledger |
| KEY | SourceLedger | C_BE_BOPRevnCostWthCrrtnItmC | SourceLedger | Source Ledger |
| KEY | CompanyCode | C_BE_BOPRevnCostWthCrrtnItmC | CompanyCode | Receiver Company Code |
| KEY | AccountingDocument | C_BE_BOPRevnCostWthCrrtnItmC | AccountingDocument | Journal Entry |
| KEY | FiscalYear | C_BE_BOPRevnCostWthCrrtnItmC | FiscalYear | G/L Fiscal Year |
| KEY | LedgerGLLineItem | C_BE_BOPRevnCostWthCrrtnItmC | LedgerGLLineItem | Journal Entry Item |
| KEY | CADocument | C_BE_BOPRevnCostWthCrrtnItmC | CADocument | CA Document No. |
| KEY | CAGLItemNumber | C_BE_BOPRevnCostWthCrrtnItmC | CAGLItemNumber | Item |
| KEY | CompanyCodeCountry | C_BE_BOPRevnCostWthCrrtnItmC | CompanyCodeCountry | Reporting Ctry/Reg. |
| AccountingDocumentItem | C_BE_BOPRevnCostWthCrrtnItmC | AccountingDocumentItem | Posting View Item | |
| CAReconciliationKey | C_BE_BOPRevnCostWthCrrtnItmC | CAReconciliationKey | Reconcil. Key | |
| BusinessPartner | C_BE_BOPRevnCostWthCrrtnItmC | BusinessPartner | Issuing Authority | |
| CADocumentType | C_BE_BOPRevnCostWthCrrtnItmC | CADocumentType | Document Type | |
| PostingDate | C_BE_BOPRevnCostWthCrrtnItmC | PostingDate | Posting Date for GR | |
| ClearingDate | C_BE_BOPRevnCostWthCrrtnItmC | ClearingDate | Clearing Date | |
| ChartOfAccounts | C_BE_BOPRevnCostWthCrrtnItmC | ChartOfAccounts | Node Class | |
| GLAccount | C_BE_BOPRevnCostWthCrrtnItmC | GLAccount | General Ledger | |
| TaxCode | C_BE_BOPRevnCostWthCrrtnItmC | TaxCode | Tax Code | |
| AccountingDocumentType | C_BE_BOPRevnCostWthCrrtnItmC | AccountingDocumentType | Journal Entry Type | |
| IsEUTriangularDeal | C_BE_BOPRevnCostWthCrrtnItmC | IsEUTriangularDeal | Is EU Triangular Deal | |
| SpecialGLCode | C_BE_BOPRevnCostWthCrrtnItmC | SpecialGLCode | Special G/L Ind | |
| DebitCreditCode | C_BE_BOPRevnCostWthCrrtnItmC | DebitCreditCode | Single-Character Flag | |
| TransactionCurrency | C_BE_BOPRevnCostWthCrrtnItmC | TransactionCurrency | Transaction Currency | |
| AmountInTransactionCurrency | C_BE_BOPRevnCostWthCrrtnItmC | AmountInTransactionCurrency | Pt Crcy Amt | |
| DebitAmountInTransCrcy | C_BE_BOPRevnCostWthCrrtnItmC | DebitAmountInTransCrcy | Debit Amt in DC | |
| CreditAmountInTransCrcy | C_BE_BOPRevnCostWthCrrtnItmC | CreditAmountInTransCrcy | Credit Amt in DC | |
| CompanyCodeCurrency | C_BE_BOPRevnCostWthCrrtnItmC | CompanyCodeCurrency | Local Currency | |
| AmountInCompanyCodeCurrency | C_BE_BOPRevnCostWthCrrtnItmC | AmountInCompanyCodeCurrency | Local Crcy Amt | |
| DebitAmountInCoCodeCrcy | C_BE_BOPRevnCostWthCrrtnItmC | DebitAmountInCoCodeCrcy | Debit Amount in Company Code Currency | |
| CreditAmountInCoCodeCrcy | C_BE_BOPRevnCostWthCrrtnItmC | CreditAmountInCoCodeCrcy | Credit Amount in Company Code Currency | |
| ExportAmountInCompanyCodeCrcy | C_BE_BOPRevnCostWthCrrtnItmC | ExportAmountInCompanyCodeCrcy | ||
| ImportAmountInCompanyCodeCrcy | C_BE_BOPRevnCostWthCrrtnItmC | ImportAmountInCompanyCodeCrcy | ||
| ClearingJournalEntry | C_BE_BOPRevnCostWthCrrtnItmC | ClearingJournalEntry | Clrng doc. | |
| ClearingJournalEntryFiscalYear | C_BE_BOPRevnCostWthCrrtnItmC | ClearingJournalEntryFiscalYear | Fiscal Year of Clearing Journal Entry | |
| CAClearingAccountingDocument | C_BE_BOPRevnCostWthCrrtnItmC | CAClearingAccountingDocument | Clearing Doc. | |
| FinancialAccountType | C_BE_BOPRevnCostWthCrrtnItmC | FinancialAccountType | Fin. Account Type | |
| OffsettingAccountType | C_BE_BOPRevnCostWthCrrtnItmC | OffsettingAccountType | Offset Acct Type | |
| OffsettingAccount | C_BE_BOPRevnCostWthCrrtnItmC | OffsettingAccount | Offsetting Acct | |
| PartnerCompany | C_BE_BOPRevnCostWthCrrtnItmC | PartnerCompany | Trading Partner | |
| Customer | C_BE_BOPRevnCostWthCrrtnItmC | Customer | Sold-to Party | |
| Supplier | C_BE_BOPRevnCostWthCrrtnItmC | 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_BE_BOPRevnCostWthCrrtnItmQ.
-- 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: CBEBOPRCIWCIQ
CREATE VIEW C_BE_BOPRevnCostWthCrrtnItmQ AS
SELECT
C_BE_BOPRevnCostWthCrrtnItmC.BOPRptgCntry AS BOPRptgCntry,
C_BE_BOPRevnCostWthCrrtnItmC.BOPForm AS BOPForm,
C_BE_BOPRevnCostWthCrrtnItmC.BOPFormItem AS BOPFormItem,
C_BE_BOPRevnCostWthCrrtnItmC.BOPPartnerCntry AS BOPPartnerCntry,
C_BE_BOPRevnCostWthCrrtnItmC.StatryRptgEntity AS StatryRptgEntity,
C_BE_BOPRevnCostWthCrrtnItmC.StatryRptCategory AS StatryRptCategory,
C_BE_BOPRevnCostWthCrrtnItmC.StatryRptRunID AS StatryRptRunID,
C_BE_BOPRevnCostWthCrrtnItmC.Ledger AS Ledger,
C_BE_BOPRevnCostWthCrrtnItmC.SourceLedger AS SourceLedger,
C_BE_BOPRevnCostWthCrrtnItmC.CompanyCode AS CompanyCode,
C_BE_BOPRevnCostWthCrrtnItmC.AccountingDocument AS AccountingDocument,
C_BE_BOPRevnCostWthCrrtnItmC.FiscalYear AS FiscalYear,
C_BE_BOPRevnCostWthCrrtnItmC.LedgerGLLineItem AS LedgerGLLineItem,
C_BE_BOPRevnCostWthCrrtnItmC.CADocument AS CADocument,
C_BE_BOPRevnCostWthCrrtnItmC.CAGLItemNumber AS CAGLItemNumber,
C_BE_BOPRevnCostWthCrrtnItmC.CompanyCodeCountry AS CompanyCodeCountry,
C_BE_BOPRevnCostWthCrrtnItmC.AccountingDocumentItem AS AccountingDocumentItem,
C_BE_BOPRevnCostWthCrrtnItmC.CAReconciliationKey AS CAReconciliationKey,
C_BE_BOPRevnCostWthCrrtnItmC.BusinessPartner AS BusinessPartner,
C_BE_BOPRevnCostWthCrrtnItmC.CADocumentType AS CADocumentType,
C_BE_BOPRevnCostWthCrrtnItmC.PostingDate AS PostingDate,
C_BE_BOPRevnCostWthCrrtnItmC.ClearingDate AS ClearingDate,
C_BE_BOPRevnCostWthCrrtnItmC.ChartOfAccounts AS ChartOfAccounts,
C_BE_BOPRevnCostWthCrrtnItmC.GLAccount AS GLAccount,
C_BE_BOPRevnCostWthCrrtnItmC.TaxCode AS TaxCode,
C_BE_BOPRevnCostWthCrrtnItmC.AccountingDocumentType AS AccountingDocumentType,
C_BE_BOPRevnCostWthCrrtnItmC.IsEUTriangularDeal AS IsEUTriangularDeal,
C_BE_BOPRevnCostWthCrrtnItmC.SpecialGLCode AS SpecialGLCode,
C_BE_BOPRevnCostWthCrrtnItmC.DebitCreditCode AS DebitCreditCode,
C_BE_BOPRevnCostWthCrrtnItmC.TransactionCurrency AS TransactionCurrency,
C_BE_BOPRevnCostWthCrrtnItmC.AmountInTransactionCurrency AS AmountInTransactionCurrency,
C_BE_BOPRevnCostWthCrrtnItmC.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
C_BE_BOPRevnCostWthCrrtnItmC.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
C_BE_BOPRevnCostWthCrrtnItmC.CompanyCodeCurrency AS CompanyCodeCurrency,
C_BE_BOPRevnCostWthCrrtnItmC.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
C_BE_BOPRevnCostWthCrrtnItmC.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
C_BE_BOPRevnCostWthCrrtnItmC.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
C_BE_BOPRevnCostWthCrrtnItmC.ExportAmountInCompanyCodeCrcy AS ExportAmountInCompanyCodeCrcy,
C_BE_BOPRevnCostWthCrrtnItmC.ImportAmountInCompanyCodeCrcy AS ImportAmountInCompanyCodeCrcy,
C_BE_BOPRevnCostWthCrrtnItmC.ClearingJournalEntry AS ClearingJournalEntry,
C_BE_BOPRevnCostWthCrrtnItmC.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
C_BE_BOPRevnCostWthCrrtnItmC.CAClearingAccountingDocument AS CAClearingAccountingDocument,
C_BE_BOPRevnCostWthCrrtnItmC.FinancialAccountType AS FinancialAccountType,
C_BE_BOPRevnCostWthCrrtnItmC.OffsettingAccountType AS OffsettingAccountType,
C_BE_BOPRevnCostWthCrrtnItmC.OffsettingAccount AS OffsettingAccount,
C_BE_BOPRevnCostWthCrrtnItmC.PartnerCompany AS PartnerCompany,
C_BE_BOPRevnCostWthCrrtnItmC.Customer AS Customer,
C_BE_BOPRevnCostWthCrrtnItmC.Supplier AS Supplier
FROM C_BE_BOPRevnCostWthCrrtnItmC
;
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