C_BE_BOPRevnCostWthCrrtnItmC

DDL: C_BE_BOPREVNCOSTWTHCRRTNITMC Type: view_entity CONSUMPTION

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)

SourceAliasJoin Type
I_BOPRevnCostItmToFormItemC I_BOPRevnCostItmToFormItemC from
P_BE_BOPFormItemWithCorrection P_BE_BOPFormItemWithCorrection inner

Annotations (11)

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

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