I_BOPRevnCostItmToFormItemC

DDL: I_BOPREVNCOSTITMTOFORMITEMC Type: view_entity COMPOSITE
43 Fields

Revn Cost Item to BOP Form Item - Cube

I_BOPRevnCostItmToFormItemC is a Composite CDS View (Cube) that provides data about "Revn Cost Item to BOP Form Item - Cube" in SAP S/4HANA.

Annotations (11)

NameValueLevelField
EndUserText.label Revn Cost Item to BOP Form Item - Cube view
VDM.viewType #COMPOSITE 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 (43)

KeyFieldSource TableSource FieldDescription
KEY Ledger P_BOPRevnCostItemToFormItemU Ledger Ledger
KEY SourceLedger P_BOPRevnCostItemToFormItemU SourceLedger Source Ledger
KEY CompanyCode P_BOPRevnCostItemToFormItemU CompanyCode Receiver Company Code
KEY AccountingDocument P_BOPRevnCostItemToFormItemU AccountingDocument Journal Entry
KEY FiscalYear P_BOPRevnCostItemToFormItemU FiscalYear G/L Fiscal Year
KEY LedgerGLLineItem P_BOPRevnCostItemToFormItemU LedgerGLLineItem Journal Entry Item
KEY CADocument P_BOPRevnCostItemToFormItemU CADocument CA Document No.
KEY CAGLItemNumber P_BOPRevnCostItemToFormItemU CAGLItemNumber Item
KEY BOPForm P_BOPRevnCostItemToFormItemU BOPForm Form
KEY BOPRptgCntry P_BOPRevnCostItemToFormItemU BOPRptgCntry Reporting Ctry/Reg.
KEY BOPFormItem P_BOPRevnCostItemToFormItemU BOPFormItem Form Item
KEY CompanyCodeCountry P_BOPRevnCostItemToFormItemU CompanyCodeCountry Reporting Ctry/Reg.
KEY StatryRptgEntity P_BOPRevnCostItemToFormItemU StatryRptgEntity Reporting Entity
KEY StatryRptCategory P_BOPRevnCostItemToFormItemU StatryRptCategory Report ID
KEY StatryRptRunID P_BOPRevnCostItemToFormItemU StatryRptRunID Report Run ID
AccountingDocumentItem P_BOPRevnCostItemToFormItemU AccountingDocumentItem Posting View Item
CAReconciliationKey P_BOPRevnCostItemToFormItemU CAReconciliationKey Reconcil. Key
BusinessPartner P_BOPRevnCostItemToFormItemU BusinessPartner Issuing Authority
CADocumentType P_BOPRevnCostItemToFormItemU CADocumentType Document Type
PostingDate P_BOPRevnCostItemToFormItemU PostingDate Posting Date for GR
ClearingDate P_BOPRevnCostItemToFormItemU ClearingDate Clearing Date
ChartOfAccounts P_BOPRevnCostItemToFormItemU ChartOfAccounts Node Class
GLAccount P_BOPRevnCostItemToFormItemU GLAccount General Ledger
TaxCode P_BOPRevnCostItemToFormItemU TaxCode Tax Code
AccountingDocumentType P_BOPRevnCostItemToFormItemU AccountingDocumentType Journal Entry Type
IsEUTriangularDeal P_BOPRevnCostItemToFormItemU IsEUTriangularDeal Is EU Triangular Deal
SpecialGLCode P_BOPRevnCostItemToFormItemU SpecialGLCode Special G/L Ind
DebitCreditCode P_BOPRevnCostItemToFormItemU DebitCreditCode Single-Character Flag
TransactionCurrency P_BOPRevnCostItemToFormItemU TransactionCurrency Transaction Currency
AmountInTransactionCurrency P_BOPRevnCostItemToFormItemU AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency P_BOPRevnCostItemToFormItemU CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency P_BOPRevnCostItemToFormItemU AmountInCompanyCodeCurrency Local Crcy Amt
BOPImprtExprtFinAccountType
ClearingJournalEntry P_BOPRevnCostItemToFormItemU ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear P_BOPRevnCostItemToFormItemU ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
CAClearingAccountingDocument P_BOPRevnCostItemToFormItemU CAClearingAccountingDocument Clearing Doc.
FinancialAccountType P_BOPRevnCostItemToFormItemU FinancialAccountType Fin. Account Type
OffsettingAccountType P_BOPRevnCostItemToFormItemU OffsettingAccountType Offset Acct Type
OffsettingAccount P_BOPRevnCostItemToFormItemU OffsettingAccount Offsetting Acct
PartnerCompany P_BOPRevnCostItemToFormItemU PartnerCompany Trading Partner
Customer P_BOPRevnCostItemToFormItemU Customer Sold-to Party
Supplier P_BOPRevnCostItemToFormItemU Supplier Supplier
BOPPartnerCntry

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 I_BOPRevnCostItmToFormItemC.
-- 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 I_BOPRevnCostItmToFormItemC AS
SELECT
  P_BOPRevnCostItemToFormItemU.Ledger AS Ledger,
  P_BOPRevnCostItemToFormItemU.SourceLedger AS SourceLedger,
  P_BOPRevnCostItemToFormItemU.CompanyCode AS CompanyCode,
  P_BOPRevnCostItemToFormItemU.AccountingDocument AS AccountingDocument,
  P_BOPRevnCostItemToFormItemU.FiscalYear AS FiscalYear,
  P_BOPRevnCostItemToFormItemU.LedgerGLLineItem AS LedgerGLLineItem,
  P_BOPRevnCostItemToFormItemU.CADocument AS CADocument,
  P_BOPRevnCostItemToFormItemU.CAGLItemNumber AS CAGLItemNumber,
  P_BOPRevnCostItemToFormItemU.BOPForm AS BOPForm,
  P_BOPRevnCostItemToFormItemU.BOPRptgCntry AS BOPRptgCntry,
  P_BOPRevnCostItemToFormItemU.BOPFormItem AS BOPFormItem,
  P_BOPRevnCostItemToFormItemU.CompanyCodeCountry AS CompanyCodeCountry,
  P_BOPRevnCostItemToFormItemU.StatryRptgEntity AS StatryRptgEntity,
  P_BOPRevnCostItemToFormItemU.StatryRptCategory AS StatryRptCategory,
  P_BOPRevnCostItemToFormItemU.StatryRptRunID AS StatryRptRunID,
  P_BOPRevnCostItemToFormItemU.AccountingDocumentItem AS AccountingDocumentItem,
  P_BOPRevnCostItemToFormItemU.CAReconciliationKey AS CAReconciliationKey,
  P_BOPRevnCostItemToFormItemU.BusinessPartner AS BusinessPartner,
  P_BOPRevnCostItemToFormItemU.CADocumentType AS CADocumentType,
  P_BOPRevnCostItemToFormItemU.PostingDate AS PostingDate,
  P_BOPRevnCostItemToFormItemU.ClearingDate AS ClearingDate,
  P_BOPRevnCostItemToFormItemU.ChartOfAccounts AS ChartOfAccounts,
  P_BOPRevnCostItemToFormItemU.GLAccount AS GLAccount,
  P_BOPRevnCostItemToFormItemU.TaxCode AS TaxCode,
  P_BOPRevnCostItemToFormItemU.AccountingDocumentType AS AccountingDocumentType,
  P_BOPRevnCostItemToFormItemU.IsEUTriangularDeal AS IsEUTriangularDeal,
  P_BOPRevnCostItemToFormItemU.SpecialGLCode AS SpecialGLCode,
  P_BOPRevnCostItemToFormItemU.DebitCreditCode AS DebitCreditCode,
  P_BOPRevnCostItemToFormItemU.TransactionCurrency AS TransactionCurrency,
  P_BOPRevnCostItemToFormItemU.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_BOPRevnCostItemToFormItemU.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_BOPRevnCostItemToFormItemU.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  cast( P_BOPRevnCostItemToFormItemU.ImportExportFinancialAccType as glo_bopimpexpfinacctyp ) AS BOPImprtExprtFinAccountType,
  P_BOPRevnCostItemToFormItemU.ClearingJournalEntry AS ClearingJournalEntry,
  P_BOPRevnCostItemToFormItemU.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  P_BOPRevnCostItemToFormItemU.CAClearingAccountingDocument AS CAClearingAccountingDocument,
  P_BOPRevnCostItemToFormItemU.FinancialAccountType AS FinancialAccountType,
  P_BOPRevnCostItemToFormItemU.OffsettingAccountType AS OffsettingAccountType,
  P_BOPRevnCostItemToFormItemU.OffsettingAccount AS OffsettingAccount,
  P_BOPRevnCostItemToFormItemU.PartnerCompany AS PartnerCompany,
  P_BOPRevnCostItemToFormItemU.Customer AS Customer,
  P_BOPRevnCostItemToFormItemU.Supplier AS Supplier,
  cast( P_BOPRevnCostItemToFormItemU.BOPPartnerCntry as land1 preserving type ) AS BOPPartnerCntry
;

Learn More