Deprecated
This CDS view is deprecated in S/4HANA. Use C_BOPRblsPyblsItmToFormItemQ instead. View all deprecated CDS views →

C_JrnlEntrItmToBOPFormItmQry

DDL: C_JRNLENTRITMTOBOPFORMITMQRY SQL: CJEBOPFIQRY Type: view CONSUMPTION Package: GLO_FIN_IS_BOP_GEN
48 Fields 1 Data Sources

Journal Entry Item To BOP Form Item Query

C_JrnlEntrItmToBOPFormItmQry is a Consumption CDS View that provides data about "Journal Entry Item To BOP Form Item Query" in SAP S/4HANA. It reads from 1 data source (I_JrnlEntrItmToBOPFormItmCube) and exposes 48 fields with key fields BOPRptgCntry, BOPForm, BOPPartnerCntry, BOPFormItem, StatryRptCategory. Part of development package GLO_FIN_IS_BOP_GEN.

Data Sources (1)

SourceAliasJoin Type
I_JrnlEntrItmToBOPFormItmCube I_JrnlEntrItmToBOPFormItmCube from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CJEBOPFIQRY view
EndUserText.label Journal Entry Item To BOP Form Item Query view
VDM.viewType #CONSUMPTION view
Analytics.query true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED 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
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_BOPRblsPyblsItmToFormItemQ view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY BOPRptgCntry BOPRptgCntry Reporting Ctry/Reg.
KEY BOPForm BOPForm Form
KEY BOPPartnerCntry BOPPartnerCntry Country/Reg.
KEY BOPFormItem BOPFormItem Form Item
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptRunID StatryRptRunID Report Run ID
KEY Ledger Ledger Ledger
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY CADocument CADocumentNumber FICA Document Number
KEY CASubItemNumber CASubItemNumber FICA SUB Item Number
KEY CABPItemNumber CABPItemNumber FICA BP Item Number
KEY CAGLItemNumber CAGLItemNumber FICA GL Item Number
CAReconciliationKey CAReconciliationKey Reconcil. Key
BusinessPartner BusinessPartner Issuing Authority
CADocumentType CADocumentType FICA Document Type
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
ChartOfAccounts ChartOfAccounts Node Class
GLAccount GLAccount General Ledger
TaxCode TaxCode Tax Code
AccountingDocumentType AccountingDocumentType Journal Entry Type
SpecialGLCode SpecialGLCode Special G/L Ind
DebitCreditCode DebitCreditCode Single-Character Flag
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
DebitAmountInTransCrcy DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy CreditAmountInTransCrcy Credit Amt in DC
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
PostingDate PostingDate Posting Date for GR
FinancialAccountType FinancialAccountType Fin. Account Type
Customer Customer Sold-to Party
Supplier Supplier Supplier
OffsettingAccountType OffsettingAccountType Offset Acct Type
OffsettingAccount OffsettingAccount Offsetting Acct
PartnerCompany PartnerCompany Trading Partner
ClearingDate ClearingDate Clearing Date
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
CAClearingAccountingDocument CAClearingAccountingDocument FICA Clearing Document
ClearingDocFiscalYear ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?

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_JrnlEntrItmToBOPFormItmQry.
-- 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: CJEBOPFIQRY

CREATE VIEW C_JrnlEntrItmToBOPFormItmQry AS
SELECT
  BOPRptgCntry,
  BOPForm,
  BOPPartnerCntry,
  BOPFormItem,
  StatryRptCategory,
  StatryRptgEntity,
  StatryRptRunID,
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  CADocumentNumber AS CADocument,
  CASubItemNumber,
  CABPItemNumber,
  CAGLItemNumber,
  CAReconciliationKey,
  BusinessPartner,
  CADocumentType,
  CompanyCodeCountry,
  ChartOfAccounts,
  GLAccount,
  TaxCode,
  AccountingDocumentType,
  SpecialGLCode,
  DebitCreditCode,
  TransactionCurrency,
  AmountInTransactionCurrency,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  PostingDate,
  FinancialAccountType,
  Customer,
  Supplier,
  OffsettingAccountType,
  OffsettingAccount,
  PartnerCompany,
  ClearingDate,
  ClearingAccountingDocument,
  CAClearingAccountingDocument,
  ClearingDocFiscalYear,
  IsReversal,
  IsReversed
FROM I_JrnlEntrItmToBOPFormItmCube
;

Learn More