P_JrnlEntrItmToBOPFormItm

DDL: P_JRNLENTRITMTOBOPFORMITM SQL: PJEBOPFI Type: view COMPOSITE Package: GLO_FIN_IS_BOP_GEN
81 Fields

Journal Entry Item To BOP Form Item

P_JrnlEntrItmToBOPFormItm is a Composite CDS View that provides data about "Journal Entry Item To BOP Form Item" in SAP S/4HANA. Part of development package GLO_FIN_IS_BOP_GEN.

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PJEBOPFI view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (81)

KeyFieldSource TableSource FieldDescription
KEY Ledger m21 Ledger Ledger
KEY SourceLedger m21 SourceLedger Source Ledger
KEY CompanyCode m21 CompanyCode Receiver Company Code
KEY AccountingDocument m21 AccountingDocument Journal Entry
KEY FiscalYear m21 FiscalYear G/L Fiscal Year
KEY LedgerGLLineItem m21 LedgerGLLineItem Journal Entry Item
KEY BOPRptgCntry BOPRptgCntry Reporting Ctry/Reg.
KEY BOPForm BOPForm Form
KEY BOPFormItem BOPFormItem Form Item
CompanyCodeCountry m21 CompanyCodeCountry Reporting Ctry/Reg.
BOPPartnerCntry m21 BOPPartnerCntry Country/Reg.
IsEUTriangularDeal m21 IsEUTriangularDeal Is EU Triangular Deal
UniqueAcctgDocClrgDate m21 UniqueAcctgDocClrgDate
HasUniqueClrgDate m21 HasUniqueClrgDate
PostingDate itm PostingDate Posting Date for GR
FiscalYearVariant itm FiscalYearVariant FY Variant
ChartOfAccounts itm ChartOfAccounts Node Class
GLAccount itm GLAccount General Ledger
TaxCode itm TaxCode Tax Code
AccountingDocumentType itm AccountingDocumentType Journal Entry Type
SpecialGLCode itm SpecialGLCode Special G/L Ind
DebitCreditCode itm DebitCreditCode Single-Character Flag
TransactionCurrency itm TransactionCurrency Transaction Currency
AmountInTransactionCurrency itm AmountInTransactionCurrency Pt Crcy Amt
DebitAmountInTransCrcy itm DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy itm CreditAmountInTransCrcy Credit Amt in DC
CompanyCodeCurrency itm CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency itm AmountInCompanyCodeCurrency Local Crcy Amt
DebitAmountInCoCodeCrcy itm DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy itm CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
ClearingDate itm ClearingDate Clearing Date
ClearingAccountingDocument itm ClearingAccountingDocument Clearing Journal Entry
ClearingDocFiscalYear itm ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
IsReversal itm IsReversal Reversal doc.
IsReversed itm IsReversed Reversed?
FinancialAccountType itm FinancialAccountType Fin. Account Type
Customer itm Customer Sold-to Party
Supplier itm Supplier Supplier
OffsettingAccountType itm OffsettingAccountType Offset Acct Type
OffsettingAccount itm OffsettingAccount Offsetting Acct
Ledger Ledger
KEY SourceLedger m32 SourceLedger Source Ledger
KEY CompanyCode m32 CompanyCode Receiver Company Code
KEY AccountingDocument m32 AccountingDocument Journal Entry
KEY FiscalYear m32 FiscalYear G/L Fiscal Year
KEY LedgerGLLineItem m32 LedgerGLLineItem Journal Entry Item
KEY BOPRptgCntry BOPRptgCntry Reporting Ctry/Reg.
KEY BOPForm BOPForm Form
KEY BOPFormItem BOPFormItem Form Item
CompanyCodeCountry m32 CompanyCodeCountry Reporting Ctry/Reg.
BOPPartnerCntry m32 BOPPartnerCntry Country/Reg.
IsEUTriangularDeal m32 IsEUTriangularDeal Is EU Triangular Deal
UniqueAcctgDocClrgDate m32 UniqueAcctgDocClrgDate
HasUniqueClrgDate m32 HasUniqueClrgDate
PostingDate itm PostingDate Posting Date for GR
FiscalYearVariant itm FiscalYearVariant FY Variant
ChartOfAccounts itm ChartOfAccounts Node Class
GLAccount itm GLAccount General Ledger
TaxCode itm TaxCode Tax Code
AccountingDocumentType itm AccountingDocumentType Journal Entry Type
SpecialGLCode itm SpecialGLCode Special G/L Ind
DebitCreditCode itm DebitCreditCode Single-Character Flag
TransactionCurrency itm TransactionCurrency Transaction Currency
AmountInTransactionCurrency itm AmountInTransactionCurrency Pt Crcy Amt
DebitAmountInTransCrcy itm DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy itm CreditAmountInTransCrcy Credit Amt in DC
CompanyCodeCurrency itm CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency itm AmountInCompanyCodeCurrency Local Crcy Amt
DebitAmountInCoCodeCrcy itm DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy itm CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
ClearingDate itm ClearingDate Clearing Date
ClearingAccountingDocument itm ClearingAccountingDocument Clearing Journal Entry
ClearingDocFiscalYear itm ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
IsReversal itm IsReversal Reversal doc.
IsReversed itm IsReversed Reversed?
FinancialAccountType itm FinancialAccountType Fin. Account Type
Customer itm Customer Sold-to Party
Supplier itm Supplier Supplier
OffsettingAccountType itm OffsettingAccountType Offset Acct Type
OffsettingAccount itm OffsettingAccount Offsetting Acct
PartnerCompany itm PartnerCompany Trading Partner

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 P_JrnlEntrItmToBOPFormItm.
-- 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: PJEBOPFI

CREATE VIEW P_JrnlEntrItmToBOPFormItm AS
SELECT
  m21.Ledger AS Ledger,
  m21.SourceLedger AS SourceLedger,
  m21.CompanyCode AS CompanyCode,
  m21.AccountingDocument AS AccountingDocument,
  m21.FiscalYear AS FiscalYear,
  m21.LedgerGLLineItem AS LedgerGLLineItem,
  BOPRptgCntry,
  BOPForm,
  BOPFormItem,
  m21.CompanyCodeCountry AS CompanyCodeCountry,
  m21.BOPPartnerCntry AS BOPPartnerCntry,
  m21.IsEUTriangularDeal AS IsEUTriangularDeal,
  m21.UniqueAcctgDocClrgDate AS UniqueAcctgDocClrgDate,
  m21.HasUniqueClrgDate AS HasUniqueClrgDate,
  itm.PostingDate AS PostingDate,
  itm.FiscalYearVariant AS FiscalYearVariant,
  itm.ChartOfAccounts AS ChartOfAccounts,
  itm.GLAccount AS GLAccount,
  itm.TaxCode AS TaxCode,
  itm.AccountingDocumentType AS AccountingDocumentType,
  itm.SpecialGLCode AS SpecialGLCode,
  itm.DebitCreditCode AS DebitCreditCode,
  itm.TransactionCurrency AS TransactionCurrency,
  itm.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  itm.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  itm.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  itm.CompanyCodeCurrency AS CompanyCodeCurrency,
  itm.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  itm.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  itm.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  itm.ClearingDate AS ClearingDate,
  itm.ClearingAccountingDocument AS ClearingAccountingDocument,
  itm.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  itm.IsReversal AS IsReversal,
  itm.IsReversed AS IsReversed,
  itm.FinancialAccountType AS FinancialAccountType,
  itm.Customer AS Customer,
  itm.Supplier AS Supplier,
  itm.OffsettingAccountType AS OffsettingAccountType,
  itm.OffsettingAccount AS OffsettingAccount,
  itm.PartnerCompany AS PartnerCompany
;

Learn More