C_CH_BOPRevnCostWthMetaDataC

DDL: C_CH_BOPREVNCOSTWTHMETADATAC Type: view_entity CONSUMPTION

CH BOP Item With ToC Meta Data - Cube

C_CH_BOPRevnCostWthMetaDataC is a Consumption CDS View (Cube) that provides data about "CH BOP Item With ToC Meta Data - Cube" in SAP S/4HANA. It reads from 1 data source (I_BOPRevnCostItmToFormItemC) and exposes 50 fields with key fields Ledger, SourceLedger, CompanyCode, AccountingDocument, FiscalYear.

Data Sources (1)

SourceAliasJoin Type
I_BOPRevnCostItmToFormItemC I_BOPRevnCostItmToFormItemC from

Annotations (11)

NameValueLevelField
EndUserText.label CH BOP Item With ToC Meta Data - 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 (50)

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 I_BOPRevnCostItmToFormItemC BOPFormItem Form Item
KEY BOPPartnerCntry I_BOPRevnCostItmToFormItemC BOPPartnerCntry Country/Reg.
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
DebitCreditCode I_BOPRevnCostItmToFormItemC DebitCreditCode Single-Character Flag
CH_BOPTechnicalField1 I_CH_BOPFormItemToMetaData CH_BOPTechnicalField1
CH_BOPTechnicalField2 I_CH_BOPFormItemToMetaData CH_BOPTechnicalField2
CH_BOPTechnicalField3 I_CH_BOPFormItemToMetaData CH_BOPTechnicalField3
CH_BOPTechnicalNode1 I_CH_BOPFormItemToMetaData CH_BOPTechnicalNode1
CH_BOPTechnicalNode2 I_CH_BOPFormItemToMetaData CH_BOPTechnicalNode2
CH_BOPTransactionGroup I_CH_BOPFormItemToMetaData CH_BOPTransactionGroup
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
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
DebitAmountInCoCodeCrcy I_BOPRevnCostItmToFormItemC DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy I_BOPRevnCostItmToFormItemC CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
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
ImportAmountInCompanyCodeCrcy I_BOPRevnCostItmToFormItemC ImportAmountInCompanyCodeCrcy
ExportAmountInCompanyCodeCrcy I_BOPRevnCostItmToFormItemC ExportAmountInCompanyCodeCrcy
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

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_CH_BOPRevnCostWthMetaDataC.
-- 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_CH_BOPRevnCostWthMetaDataC 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,
  I_BOPRevnCostItmToFormItemC.BOPFormItem AS BOPFormItem,
  I_BOPRevnCostItmToFormItemC.BOPPartnerCntry AS BOPPartnerCntry,
  I_BOPRevnCostItmToFormItemC.CompanyCodeCountry AS CompanyCodeCountry,
  I_BOPRevnCostItmToFormItemC.StatryRptgEntity AS StatryRptgEntity,
  I_BOPRevnCostItmToFormItemC.StatryRptCategory AS StatryRptCategory,
  I_BOPRevnCostItmToFormItemC.StatryRptRunID AS StatryRptRunID,
  I_BOPRevnCostItmToFormItemC.DebitCreditCode AS DebitCreditCode,
  I_CH_BOPFormItemToMetaData.CH_BOPTechnicalField1 AS CH_BOPTechnicalField1,
  I_CH_BOPFormItemToMetaData.CH_BOPTechnicalField2 AS CH_BOPTechnicalField2,
  I_CH_BOPFormItemToMetaData.CH_BOPTechnicalField3 AS CH_BOPTechnicalField3,
  I_CH_BOPFormItemToMetaData.CH_BOPTechnicalNode1 AS CH_BOPTechnicalNode1,
  I_CH_BOPFormItemToMetaData.CH_BOPTechnicalNode2 AS CH_BOPTechnicalNode2,
  I_CH_BOPFormItemToMetaData.CH_BOPTransactionGroup AS CH_BOPTransactionGroup,
  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.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.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  I_BOPRevnCostItmToFormItemC.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  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.ImportAmountInCompanyCodeCrcy AS ImportAmountInCompanyCodeCrcy,
  I_BOPRevnCostItmToFormItemC.ExportAmountInCompanyCodeCrcy AS ExportAmountInCompanyCodeCrcy,
  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
FROM I_BOPRevnCostItmToFormItemC
;