CE3E_B1 SAP (Model Bank) Table details

Dictionary Type: Table
Description: Model Bank




ABAP Code to SELECT data from CE3E_B1
Related tables to CE3E_B1
Access table CE3E_B1




Table field list including key, data, relationships and ABAP select examples

CE3E_B1 is a standard SAP Table which is used to store Model Bank data and is available within R/3 SAP systems depending on the version and release level.

The CE3E_B1 table consists of various fields, each holding specific information or linking keys about Model Bank data available in SAP. These include PAOBJNR (Profitability Segment Number (CO-PA)), PALEDGER (Currency type for an operating concern), VRGAR (Record Type), PLIKZ (Plan/Actual Indicator).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CE3E_B1 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PALEDGERCurrency type for an operating concern LEDBOCHAR2TKELLEDBOLEDBO
VRGARRecord Type RKE_VRGARCHAR1TVGAVRGARVGA
PLIKZPlan/Actual Indicator PLIKZCHAR1PLIKZ
VERSIPlan version (CO-PA) RKEVERSICHAR3TKVSALPHACOVERSIPVS
PERBLFiscal year/period block JAHRPERBLNUMC7PERI7JAHRPER
PASUBNRProfitability segment changes (CO-PA) RKESUBNRNUMC4RKESUBNR
PAPAOBJNRPartner profitability segment number (CO-PA) RKEPOBJNUMC10RKEOBJNR
PAPASUBNRChanges to partner profitability segments (CO-PA) RKEPSUBNRNUMC4RKESUBNR
HRKFTOrigins (CO-PA) RKEHERKCHAR4RKEHERK
UPDATDate of Last Change LAEDADATS8DATUM
USNAMLast changed by AENNMCHAR12USNAM
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
REC_WAERSCurrency of the data record RKE_REC_WAERSCUKY5Assigned to domainWAERS
TIMESTMPTime created (Greenwich Meantime) RKE_HZSTMPDEC16RKE_TSTMP
BDSVOL001Average Volume JBBDSVOLCURR17(2) WERTV9
BDSEFK001Periodic Effective Capital JBBDSEFKCURR17(2) WERTV9
BZINBE001Interest Revenue JBBZINBECURR17(2) WERTV9
BOPPBE001Opportunity Income from Transaction Currency Yield Curve JBBOPPBECURR17(2) WERTV9
BOPPHW001Opportunity Income from Local Currency Yield Curve JBBOPPHWCURR17(2) WERTV9
BZINKO001Net Interest Margin Contribution JBBZINKOCURR17(2) WERTV9
BMARBW001NPV Margin JBBMARBWCURR17(2) WERTV9
BABRBW001Settlement NPV JBBABRBWCURR17(2) WERTV9
BDIFBW001Residual Margin for Regular Withdrawal JBBDIFBWCURR17(2) WERTV9
BWTBBW001NPV of Currency Translation Contribution JBBWTBBWCURR17(2) WERTV9
BDSKBW001NPV of Average Effective Committed Capital JBBDSKBWCURR17(2) WERTV9
BMKVOL001Market Volume on Costing Key Date JBBMKVOLCURR17(2) WERTV9
BMKVLD001Average market volume JBBMKVLDCURR17(2) WERTV9
BOPVOL001Opportunity Volume on Costing Key Date JBBOPVOLCURR17(2) WERTV9
BVERKM001Market Value of Sales in the Period JBBVERKMCURR17(2) WERTV9
BKAUFM001Market Value of Purchases in Period JBBKAUFMCURR17(2) WERTV9
BRKUGW001Realized Price Gains JBBRKUGWCURR17(2) WERTV9
BRKDGW001Realized Foreign Exchange Gains JBBRKDGWCURR17(2) WERTV9
BRKUVL001Realized Price Losses JBBRKUVLCURR17(2) WERTV9
BRKDVL001Realized Foreign Exchange Losses JBBRKDVLCURR17(2) WERTV9
BSKUGW001Unrealized Price Gains JBBSKUGWCURR17(2) WERTV9
BSKDGW001Unrealized Foreign Exchange Gains JBBSKDGWCURR17(2) WERTV9
BSKUVL001Unrealized Price Losses JBBSKUVLCURR17(2) WERTV9
BSKDVL001Unrealized Foreign Exchange Losses JBBSKDVLCURR17(2) WERTV9
BOPKOS001Opportunity Expense/Revenue in Own-Account Trading JBBOPKOSCURR17(2) WERTV9
BHKOBE001Trading Terms Contribution JBBHKOBECURR17(2) WERTV9
AGESCH001Number of Single Transactions JBAGESCHQUAN13(3) MENGE
BERTRZ001Own-account revenues JBBERTRZCURR17(2) WERTV9
BZINAG001Interest expense JBBZINAGCURR17(2) WERTV9
BOPPAG001Opportunity Cost from Transaction Currency Yield Curve JBBOPPAGCURR17(2) WERTV9
BOPPAH001Opportunity Cost from Local Currency Yield Curve JBBOPPAHCURR17(2) WERTV9
VVAZAK001Diff.com/settl.calc. RKESVVAZAKCURR17(2) WERTV9
VVAZNK001Difference: Commitment/Postcalculation RKESVVAZNKCURR17(2) WERTV9
VVBEVP001Valuation Result for Previous Period RKESVVBEVPCURR17(2) WERTV9
VVDKOI001Direct Costs (Actual) RKESVVDKOICURR17(2) WERTV9
VVEKKB001Net Present Value Equity Costs RKESVVEKKBCURR17(2) WERTV9
VVEKKO001Equity Costs RKESVVEKKOCURR17(2) WERTV9
VVGKZU001Overhead RKESVVGKZUCURR17(2) WERTV9
VVIKPC001Indir. costs PC RKESVVIKPCCURR17(2) WERTV9
VVIKRE001Indir. costs rest RKESVVIKRECURR17(2) WERTV9
VVLIKO001Liquidity costs RKESVVLIKOCURR17(2) WERTV9
VVMRKO001Reserve Requirement Costs RKESVVMRKOCURR17(2) WERTV9
VVPROA001Commission paid RKESVVPROACURR17(2) WERTV9
VVPROB001Commission NPV RKESVVPROBCURR17(2) WERTV9
VVPROE001Commission earned RKESVVPROECURR17(2) WERTV9
VVRIKB001NPV stand.risk costs RKESVVRIKBCURR17(2) WERTV9
VVRIKO001Stand. risk costs RKESVVRIKOCURR17(2) WERTV9
VVRKOI001Risk costs (actual) RKESVVRKOICURR17(2) WERTV9
VVSTKO001Stand. unit costs RKESVVSTKOCURR17(2) WERTV9

Key field Non-key field



How do I retrieve data from SAP table CE3E_B1 using ABAP code

The following ABAP code Example will allow you to do a basic selection on CE3E_B1 to SELECT all data from the table
DATA: WA_CE3E_B1 TYPE CE3E_B1.

SELECT SINGLE *
FROM CE3E_B1
INTO CORRESPONDING FIELDS OF WA_CE3E_B1
WHERE...

How to access SAP table CE3E_B1

Within an ECC or HANA version of SAP you can also view further information about CE3E_B1 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!