P_JrnlEntrItmToBOPFormItm12

DDL: P_JRNLENTRITMTOBOPFORMITM12 SQL: PJEBOPFI12 Type: view COMPOSITE Package: GLO_FIN_IS_BOP_GEN
21 Fields 1 Data Sources 3 Associations

Journal Entry Item To BOP Form Item (Helper)

P_JrnlEntrItmToBOPFormItm12 is a Composite CDS View that provides data about "Journal Entry Item To BOP Form Item (Helper)" in SAP S/4HANA. It reads from 1 data source (P_JrnlEntrItmToBOPFormItm11) and exposes 21 fields with key fields Ledger, SourceLedger, CompanyCode, AccountingDocument, FiscalYear. It has 3 associations to related views. Part of development package GLO_FIN_IS_BOP_GEN.

Data Sources (1)

SourceAliasJoin Type
P_JrnlEntrItmToBOPFormItm11 m11 from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_OneTimeAccountBP _OneTimeAccountBP itm.CompanyCode = _OneTimeAccountBP.CompanyCode and itm.FiscalYear = _OneTimeAccountBP.FiscalYear and itm.AccountingDocument = _OneTimeAccountBP.AccountingDocument and itm.AccountingDocumentItem = _OneTimeAccountBP.AccountingDocumentItem
[0..1] I_Supplier _Supplier ( itm.OffsettingAccount = _Supplier.Supplier and itm.OffsettingAccountType = 'K' ) or ( itm.Supplier = _Supplier.Supplier and FinancialAccountType = 'K' )
[0..1] I_Customer _Customer ( itm.OffsettingAccount = _Customer.Customer and itm.OffsettingAccountType = 'D' ) or ( itm.Customer = _Customer.Customer and FinancialAccountType = 'D' )

Annotations (6)

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

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Ledger itm Ledger Ledger
KEY SourceLedger itm SourceLedger Source Ledger
KEY CompanyCode itm CompanyCode Receiver Company Code
KEY AccountingDocument itm AccountingDocument Journal Entry
KEY FiscalYear itm FiscalYear G/L Fiscal Year
KEY LedgerGLLineItem itm LedgerGLLineItem Journal Entry Item
KEY BOPRptgCntry P_JrnlEntrItmToBOPFormItm11 BOPRptgCntry Reporting Ctry/Reg.
KEY BOPForm P_JrnlEntrItmToBOPFormItm11 BOPForm Form
CompanyCodeCountry P_JrnlEntrItmToBOPFormItm11 CompanyCodeCountry Reporting Ctry/Reg.
CountryendasBOPPartnerCntry
ChartOfAccounts itm ChartOfAccounts Node Class
GLAccount itm GLAccount General Ledger
TaxCode itm TaxCode Tax Code
AccountingDocumentType itm AccountingDocumentType Journal Entry Type
IsEUTriangularDeal fje IsEUTriangularDeal Is EU Triangular Deal
UniqueAcctgDocClrgDate fje UniqueAcctgDocClrgDate
HasUniqueClrgDate fje HasUniqueClrgDate
PurchasingDocument itm PurchasingDocument Purchasing Document
PurchasingDocumentItem itm PurchasingDocumentItem Purchasing Doc. Item
AccountAssignmentNumber itm AccountAssignmentNumber Account Assgmt No.
TransactionTypeDetermination itm TransactionTypeDetermination Transaction Key

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_JrnlEntrItmToBOPFormItm12.
-- 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: PJEBOPFI12

CREATE VIEW P_JrnlEntrItmToBOPFormItm12 AS
SELECT
  itm.Ledger AS Ledger,
  itm.SourceLedger AS SourceLedger,
  itm.CompanyCode AS CompanyCode,
  itm.AccountingDocument AS AccountingDocument,
  itm.FiscalYear AS FiscalYear,
  itm.LedgerGLLineItem AS LedgerGLLineItem,
  m11.BOPRptgCntry AS BOPRptgCntry,
  m11.BOPForm AS BOPForm,
  m11.CompanyCodeCountry AS CompanyCodeCountry,
  case when ( fje.UniqueAcctgDocBPCntry <> '' and fje.UniqueAcctgDocBPCntry is not null ) then fje.UniqueAcctgDocBPCntry when _Supplier.IsOneTimeAccount = 'X' or _Customer.IsOneTimeAccount = 'X' then _OneTimeAccountBP.Country else coalesce(_Supplier.Country, _Customer.Country) end as BOPPartnerCntry AS CountryendasBOPPartnerCntry,
  itm.ChartOfAccounts AS ChartOfAccounts,
  itm.GLAccount AS GLAccount,
  itm.TaxCode AS TaxCode,
  itm.AccountingDocumentType AS AccountingDocumentType,
  fje.IsEUTriangularDeal AS IsEUTriangularDeal,
  fje.UniqueAcctgDocClrgDate AS UniqueAcctgDocClrgDate,
  fje.HasUniqueClrgDate AS HasUniqueClrgDate,
  itm.PurchasingDocument AS PurchasingDocument,
  itm.PurchasingDocumentItem AS PurchasingDocumentItem,
  itm.AccountAssignmentNumber AS AccountAssignmentNumber,
  itm.TransactionTypeDetermination AS TransactionTypeDetermination
FROM P_JrnlEntrItmToBOPFormItm11 AS m11
LEFT OUTER JOIN I_OneTimeAccountBP AS _OneTimeAccountBP ON itm.CompanyCode = _OneTimeAccountBP.CompanyCode AND itm.FiscalYear = _OneTimeAccountBP.FiscalYear AND itm.AccountingDocument = _OneTimeAccountBP.AccountingDocument AND itm.AccountingDocumentItem = _OneTimeAccountBP.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON ( itm.OffsettingAccount = _Supplier.Supplier AND itm.OffsettingAccountType = 'K' ) OR ( itm.Supplier = _Supplier.Supplier AND FinancialAccountType = 'K' )  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON ( itm.OffsettingAccount = _Customer.Customer AND itm.OffsettingAccountType = 'D' ) OR ( itm.Customer = _Customer.Customer AND FinancialAccountType = 'D' )  -- association [0..1]
;

Learn More