SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

116 columns | Print definition?ERP 6.0  | COMPANY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/NS_LOCKDefine Namespace4COMPANYCompany requesting the locknvarchar500
2/OPT/VIM_STG_LIFTable: Staging data - Vendor master for ICC9COMPANYName 1nvarchar350
3/SAPPSSRM/THRESLThresholds14COMPANYCompany Codenvarchar140
4/SMD/MD_____00ZDSID-Tabelle fuer Accts rble pled.ind.3COMPANYCompany Codenvarchar40
5/XLSO/APPR_REQMaintain Approval Settings for Company Booking and Cancellat3COMPANYCustomer Numbernvarchar100
6/XLSO/BOOK_APPRMaintain System-wide Booking Approval Time2COMPANYCustomer Numbernvarchar100
7/XLSO/COMP_INVCustomizing for Company Billing Due List (Combined Invoice)2COMPANYCustomer Numbernvarchar100
8/XLSO/CORR_COMPxLSO Correspondence types system wide2COMPANYCustomer Numbernvarchar100
9/XLSO/PMAIL_COMPCompany wise periodic mail settings2COMPANYCustomer Numbernvarchar100
10BBPC_AVL_DETDefine Sourcing using Supplier List2COMPANYCompany in MarketSet Procurementnvarchar100
11BBPC_PDMSG_CUSBBP: Settings for Customizeable Messages5COMPANYCompany in MarketSet Procurementnvarchar100
12BBPC_PDMSG_XMLBBP: Settings for XML Message Control5COMPANYCompany in MarketSet Procurementnvarchar100
13BBPD_ARCH_RESIArchiving of EBP Documents Resididence Times2COMPANYCompany in MarketSet Procurementnvarchar100
14BBPD_TREX_INDEXBBP TREX Indexes: Assign Business Object -> TREX Indexes3COMPANYCompanynvarchar140
15BBP_DET_ACCOUNTDetermination G/L Account by Product Categories2COMPANYCompany in MarketSet Procurementnvarchar100
16BBP_LOCMAPMapping Table Business Partner --> System --> Location6COMPANYCompany in E-Procurementnvarchar100
17ECPAO_COMPANYEC Company2COMPANYEC Company IDnvarchar200
18ECPAO_COMPANY_TTEC Company Text3COMPANYEC Company IDnvarchar200
19ECPAO_EE_INVTInventory of Employees Replicated2COMPANYEC Company IDnvarchar200
20ECPAO_FLDEC Template Field Mapping2COMPANYEC Company IDnvarchar200
21ECPAO_MAPENTY_TTValue Mapper Entity Text Table3COMPANYEC Company IDnvarchar200
22ECPAO_MAP_ENTITYValue Mapper Entity Table2COMPANYEC Company IDnvarchar200
23ECPAO_TEMPL_SETEmployee Central Template Group Set4COMPANYEC Company IDnvarchar200
24ECPAO_VALUE_MAPValue Mapping Table2COMPANYEC Company IDnvarchar200
25ECPAO_VALUE_MAPCValue Mapping Table (Country Specific)2COMPANYEC Company IDnvarchar200
26GRACCOMPANYCompany2COMPANYCompanynvarchar100
27GRACCOMPANYTCompany text3COMPANYCompanynvarchar100
28GRACFUNCTAREAFunctional Area Table3COMPANYCompanynvarchar100
29GRACREQUSERADRUser Communication Fields6COMPANYCompanynvarchar420
30GRACRLCOMPANYRole Company3COMPANYCompanynvarchar100
31J_5K_LFCL2COMPANYnvarchar40
32ODFIN_MAP_BUKRSKey Mapping Company - Company Code3COMPANYChar 20nvarchar200
33ZCUSTOMERMOBILETable to store information about recorded customers5COMPANYName of companynvarchar300
TOPALE Integration Technology
34EDIPHONETelephony Data for Partner Profiles13COMPANYCompany (for telephony)nvarchar550
TOPBasic Functions
35LECI_EVENT_DATAActivity Data Within the Check-in/Check-out Process24COMPANYCompany namenvarchar500
TOPBSI
36BTXCOMPBSI: Tax Company Code2COMPANYBSI: Tax Company Codenvarchar110
37BTXCOMP_OBSI: Tax Company Code1COMPANYBSI: Tax Company Codenvarchar110
38BTXRATEBSI: Tax Rates per Company Based on Degree of Experience2COMPANYBSI: Tax Company Codenvarchar110
39BTXRATE_OBSI: Tax Rates per Company Based on Degree of Experience1COMPANYBSI: Tax Company Codenvarchar110
40T5UTH_OTax Number <-> BSI Tax Interface3COMPANYBSI: Tax Company Codenvarchar110
TOPCentral Part of Product Master
41COMC_VALAREA_R3Valuation Areas in R/34COMPANYCompany Codenvarchar40
TOPCheck Input
42OIUCI_DOCSIncoming Checks - Generated/Booked Documents7COMPANYOrganization level 1 number (Company Code)nvarchar30
TOPCommunication Services Mail, Fax, SMS, Telephony
43SPH_USNOLISAPphone: Telephone number list for each user7COMPANYSAPphone: Companynvarchar550
TOPCross-Application Components
44J_5KFH_CLFORMCMPLegal forms in company2COMPANYCompany Codenvarchar40
45J_5KFH_LFHDRLegal form header2COMPANYCompany Codenvarchar40
TOPDealer Portal
46/SAPDII/SPPARTICTable of Articles4COMPANY30 Charactersnvarchar300
TOPDepreciation Simulation
47IMCCIM Summarization: Characteristics that are master data10COMPANYCompanynvarchar60
48IMCEMIM Summarization: Measures2COMPANYCompanynvarchar60
49IMCEMTIM Summarization: Texts for measures3COMPANYCompanynvarchar60
50IMCERIM Summarization: Appropriation requests2COMPANYCompanynvarchar60
51IMCERTIM Summarization: Texts for appropriation requests3COMPANYCompanynvarchar60
TOPE-Recruiting
52T77RCFBRANCHCOMPAssignment of Branches to Companies2COMPANYHolding Companiesnvarchar80
53T77RCF_ACT2FORMAssignment of Forms to Activity Types3COMPANYHolding Companiesnvarchar80
54T77RCF_COMPANYCompanies of a Holding2COMPANYHolding Companiesnvarchar80
55T77RCF_CS_S2SFDefinition SF from Service, Recipient Category and Company3COMPANYHolding Companiesnvarchar80
TOPFinancial Accounting
56J_1GJOURNAL1Journals10COMPANYPrint company code datanvarchar10
57TCESSIONAccounts Receivable Pledging2COMPANYCompany Codenvarchar40
58TCESSIONTTexts for Accounts Receivable Pledging3COMPANYCompany Codenvarchar40
TOPGL transfer
59TBKKC_BUKRSBCA Locally Duplicated Values for Corresponding FI11COMPANYCompanynvarchar60
TOPImplementation Guide
60TRESSPProject Resources5COMPANYCompany of Team Membernvarchar350
TOPJoint Venture und Production Sharing Accounting
61T8J6EJV Master Data JIB Subclass B Codes2COMPANYCompany Codenvarchar40
62T8J6FJV JIB Subclass B Codes Text Table3COMPANYCompany Codenvarchar40
63T8J6GJV JIB Account Mapping for Non-AFE2COMPANYCompany Codenvarchar40
64T8J6HJV JIB Account Mapping and Class2COMPANYCompany Codenvarchar40
65T8J6IJV JIB Class and Account Mapping2COMPANYCompany Codenvarchar40
66T8J6JJV JIB Account Mapping for AFE2COMPANYCompany Codenvarchar40
67T8JOH_ACSET_LISTList of account sets for each base amount condition2COMPANYCompany Codenvarchar40
68T8JOH_BASE_CONDTConditions used to capture base amount to calculate overhead2COMPANYCompany Codenvarchar40
69T8JOH_COMPLEX_FTable of Complex Formulas in Overhead Organizer2COMPANYCompany Codenvarchar40
70T8JOH_CONDT_TEXTBase amount condition text for overhead organizer3COMPANYCompany Codenvarchar40
71T8JOH_COSET_LISTList of cost object sets for each base amount condition2COMPANYCompany Codenvarchar40
72T8JOH_COST_OBJSTable of cost centers, projects and orders for each overhead2COMPANYCompany Codenvarchar40
73T8JOH_FMULA_TEXTText table for Overhead Organizer formulas3COMPANYCompany Codenvarchar40
74T8JOH_FORMULASFormulas used by each overhead in Overhead Organizer2COMPANYCompany Codenvarchar40
75T8JOH_FORMULA_TXFormula text for Overhead Organizer3COMPANYCompany Codenvarchar40
76T8JOH_JOASList of JOA level parameters in Overhead Organizer2COMPANYCompany Codenvarchar40
77T8JOH_KEYLISTSList of overhead characters for each overhead key2COMPANYCompany Codenvarchar40
78T8JOH_KEYTEXTText table for overhead keys3COMPANYCompany Codenvarchar40
79T8JOH_KEYWORDSList of keywords used to capture the cost objects for users2COMPANYCompany Codenvarchar40
80T8JOH_OHLISTSList of overheads defined in Overhead Organizer2COMPANYCompany Codenvarchar40
81T8JOH_OHTEXTText for each overhead key in different languages3COMPANYCompany Codenvarchar40
82T8JOH_OH_DETAILSOverhead general detail2COMPANYCompany Codenvarchar40
83T8JOH_OVERHEADSList of all overheads in each company2COMPANYCompany Codenvarchar40
84T8JOH_PERCENT_FTable of Percentage Formulas in Overhead Organizer2COMPANYCompany Codenvarchar40
85T8JOH_RUNSList of run information for each <company, joa>2COMPANYCompany Codenvarchar40
86T8JOH_STEPRATE_FTable of Step Rate Formulas in Overhead Organizer2COMPANYCompany Codenvarchar40
87T8JOH_STTRATIO_FTable of Statistical Ratio Formulas in Overhead Organizer2COMPANYCompany Codenvarchar40
88T8JOH_VENTURESList of Venture Level parameters in Overhead Organizer2COMPANYCompany Codenvarchar40
TOPLegal Case Management for ILM
89LHM_CASE_ATTRTable with Additional Attributes for Legal Hold Cases3COMPANYCompany Namenvarchar800
90SLHM_CASE_HEADLegal Hold Management - Cases (Header Data)7COMPANYCompany Namenvarchar800
TOPLocalization
91J_3R_CAUTHOutput control for Goods Withholding Authorization2COMPANYCompany Codenvarchar40
92J_3R_CLFORMCMPLegal forms in company2COMPANYCompany Codenvarchar40
93J_3R_LFHDRLegal form header2COMPANYCompany Codenvarchar40
94J_VE_INCWTMaintain Withholding Tax Payment Details2COMPANYCompany Codenvarchar40
TOPMaterials Management
95J_5KFH_CAUTHOutput control for Goods Withholding Authorization2COMPANYCompany Codenvarchar40
96J_5KMH_CAUTHOutput control for Goods Withholding Authorization2COMPANYCompany Codenvarchar40
TOPRevenue
97OIUAR_BAL_TRFRAccounts Receivable Balance Transfer4COMPANYOrganization level 1 number (Company Code)nvarchar30
98OIUAR_REC_BALAccounts Receivable Balance3COMPANYOrganization level 1 number (Company Code)nvarchar30
99OIUAR_REC_BAL_HAccounts Receivable Balance History3COMPANYOrganization level 1 number (Company Code)nvarchar30
100OIUAR_WO_CONFIGAccounts Receivable Writeoff Configuration2COMPANYOrganization level 1 number (Company Code)nvarchar30
TOPSAP Note Assistant
101SCWB_RFC_GEN_EXCSIDs where automatic RFC destination generation is disabled2COMPANY30 Charactersnvarchar300
TOPStakeholder Relationship Management
102USS_COMP_FIGSKey Figures Related to Company4COMPANYCompanynvarchar100
103USS_CUST_TABLESRM: Customizing Table3COMPANYStakeholdernvarchar100
TOPTax Reporting
104OIUX4_BALANCETaxes Payable Balance2COMPANYOrganization level 1 number (Company Code)nvarchar30
105OIUX4_BALANCE_HTaxes Payable Balance History2COMPANYOrganization level 1 number (Company Code)nvarchar30
106OIUX4_BAL_CTGZNTaxes Payable Balance Categorization2COMPANYOrganization level 1 number (Company Code)nvarchar30
107OIUX4_COMMENTSTaxes Payable Comments2COMPANYOrganization level 1 number (Company Code)nvarchar30
108OIUX4_RESP_IDTaxes Payable Responsibility ID2COMPANYOrganization level 1 number (Company Code)nvarchar30
109OIUX4_WO_SETUPTaxes Payable Writeoff Configuration2COMPANYOrganization level 1 number (Company Code)nvarchar30
TOPTravel Expenses
110PTRV_RECDETAILParticipant(s) in Entertainment Receipts12COMPANYCompanynvarchar300
TOPUSA
111BTXEMPTBSI: Employee tax results4COMPANYBSI: Tax Company Codenvarchar110
112T5UTHTax Number <-> BSI Tax Interface3COMPANYBSI: Tax Company Codenvarchar110
TOPUser and Authorization Management
113USCOMPANYCompany in user's address2COMPANYCompany address, cross-system keynvarchar420
114USCOMPANYSShadow table for USCOMPANY3COMPANYCompany address, cross-system keynvarchar420
115USZBVPROTCCUA: Protocols of the Distribution of Company Addresses2COMPANYCompany address, cross-system keynvarchar420
116USZBVSYSCCUA: Assignment of Systems to Company Addresses2COMPANYCompany address, cross-system keynvarchar420