C_BE_BOPRevnCostWthCrrtnItmQ

DDL: C_BE_BOPREVNCOSTWTHCRRTNITMQ SQL: CBEBOPRCIWCIQ Type: view CONSUMPTION Package: GLO_FIN_IS_BOP_BE

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)

SourceAliasJoin Type
C_BE_BOPRevnCostWthCrrtnItmC C_BE_BOPRevnCostWthCrrtnItmC from

Annotations (11)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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
;