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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

30 columns | Print definition?ERP 6.0  | VERSNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1NNL_ZH308_V9_R02ZH308 V09 Record02 Soll Daten9VERSNRnvarchar150
2NNL_ZH308_V9_R04ZH308 V09 Record04 Soll Daten14VERSNRnvarchar150
3NNL_ZH308_V9_R06ZH308 V09 Record06 Soll Daten15VERSNRnvarchar150
4NNL_ZH308_V9_R16ZH308 V09 Record16 Soll Daten16VERSNRnvarchar150
TOPAssortment List
5WBBHAssortment list header4VERSNRAssortment list version no.nvarchar60
6WBBLAssort. list control break4VERSNRAssortment list version no.nvarchar60
7WBBPAssortment list item5VERSNRAssortment list version no.nvarchar60
8WBB_SAVE2Temporary Assortment List Objects: Store-Specific36VERSNRAssortment list version no.nvarchar60
TOPClass Builder
9SEOCLASSEXRemote info classes/interfaces3VERSNRNatural Numberint100
TOPContract Accounts Receivable and Payable
10FKK_IP_DEACT_DBInstallment Plan Deactivation History7VERSNRVersion Numbernvarchar30
TOPIntegrated Product and Process Engineering
11CPVSTAiPPE Customizing: Partner Products Time Analysis3VERSNRVersion Numbertinyint30
TOPPackage Tools
12AKB_TRANS_CHECKObsolete: Compatibility Control1VERSNRVersion Management: Version Numbernvarchar50
TOPProfile Maintenance
13TPFESPrototype: Table for profile parameters2VERSNRVersion Numbernvarchar60
14TPFETTable of profile parameters2VERSNRVersion Numbernvarchar60
15TPFHSPrototype: Profile header, administration data for profiles2VERSNRVersion Numbernvarchar60
16TPFHTProfile header, administration data for profiles in DB2VERSNRVersion Numbernvarchar60
TOPSAP Healthcare - Industry-Specific Components for Hospitals
17NLVERKRechnungregister-kopf5VERSNRIS-H: Verzekeringsnummer van de patiëntnvarchar200
TOPSwitzerland
18T5C67Employer Data for Overall Monthly Report (Fam.Rel.Bonus Reg)3VERSNRHR-CH: Insured person number / customer numbernvarchar150
19T5CSAHR-CH: Payroll unit UVG8VERSNRHR-CH: Insured person number / customer numbernvarchar150
20T5CSBHR-CH: Payroll unit: Social Funds7VERSNRHR-CH: Insured person number / customer numbernvarchar150
21T5CSCHR-CH: Payroll Unit: Voluntary Accident Insurance8VERSNRHR-CH: Insured person number / customer numbernvarchar150
22T5CSDHR-CH: Payroll Unit - Sickness Indemnity Insurance8VERSNRHR-CH: Insured person number / customer numbernvarchar150
23T5CSEHR-CH: Payroll unit: NBU additional insurance8VERSNRHR-CH: Insured person number / customer numbernvarchar150
24T5CSKHR-CH: PAyroll Unit Compensation Fund VD7VERSNRHR-CH: Insured person number / customer numbernvarchar150
25T5CSMHR-CH: Payroll Unit BVG ELM6VERSNRHR-CH: BVG Insurance Number/Customer Number ELMnvarchar150
26T5CSXHR-CH: Payroll unit: Customer insurance 18VERSNRHR-CH: Insured person number / customer numbernvarchar150
27T5CSYHR-CH: Payroll unit: Customer insurance 28VERSNRHR-CH: Insured person number / customer numbernvarchar150
28T5CSZHR-CH: Payroll unit: Customer insurance 38VERSNRHR-CH: Insured person number / customer numbernvarchar150
29T5CZ1HR-CH: Payroll Unit: Family-Related Bonuses10VERSNRHR-CH: Insured person number / customer numbernvarchar150
TOPTranslation Tools
30LXE_TAB_TESTTest Table2VERSNRnvarchar50