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

84 columns | Print definition?ERP 6.0  | SECTN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1J_3R_INV26_SETTable Grouping of General Ledger Accounts4SECTNSection typesnvarchar20
2P2RB_BEEVLPayroll Results: Belgium table for Evaluation20SECTNForms: Sectionnvarchar40
3P2RF_FMDPayroll results: Master data10SECTNSection (labor court elections)nvarchar10
4T5BSDOG0SDoG: Historical and External Data4SECTNForms: Sectionnvarchar40
5T5BSDOGSSDoG: Sections2SECTNForms: Sectionnvarchar40
6T5BSDOGSTSDoG: Sections Text3SECTNForms: Sectionnvarchar40
7T5BSDOGSWSDoG: Sections (SAP entries)1SECTNForms: Sectionnvarchar40
8T5BSDOGSWTSDoG: Sections Text (SAP entries)2SECTNForms: Sectionnvarchar40
9T5F99FCDForms: Code list (by type)4SECTNForms: Sectionnvarchar40
10T5F99FCDTForms: Code Value List Text4SECTNForms: Sectionnvarchar40
11T5F99FEForms: Error code list4SECTNForms: Sectionnvarchar40
12T5F99FETForms: Error code list TEXT4SECTNForms: Sectionnvarchar40
13T5F99FMAPMapping table for declarations4SECTNForms: Sectionnvarchar40
14T5F99FMAPSMapping table for declarations (system table)3SECTNForms: Sectionnvarchar40
15T5F99FSCForms: Sections - Country Additional Data4SECTNForms: Sectionnvarchar40
16T5FDSNABCATAbsence categories for DSN5SECTNnvarchar40
17T5FDSNCONDIDSN: Definitions of conditions4SECTNForms: Sectionnvarchar40
18T5FDSNCOTISDSN: contributions parameter setting3SECTNForms: Sectionnvarchar40
19T5FDSNCOTIS2DSN: contributions parameter setting3SECTNForms: Sectionnvarchar40
20T5FDSNSECTNDSN: references classes for section3SECTNForms: Sectionnvarchar40
21T5FDSNSECVIDSN : Section to hide to end-user3SECTNSectionnvarchar40
22T5FDSNTDCPSECTNAssignment of DAQ section to parameter set1SECTNForms: Sectionnvarchar40
23T5FDSN_GEN_SECTNDSN: Generated sections5SECTNForms: Sectionnvarchar40
24T5FITCORRCorrections infotype, presetting table7SECTNSectionnvarchar40
25T5FITCORRCCorrections infotype, presetting table8SECTNSectionnvarchar40
26T5ITF24BGModule group table7SECTNF24: Compensated tax payer's reference number sectionnvarchar150
27T5ITUI_2User Data Table for Report / Legal Form4SECTNReport: section/partnvarchar100
28T7RU_STAT_VFLDView Variant Fields5SECTNForms: Sectionnvarchar40
29T7RU_STAT_VFLD_TNames of View Variant Fields6SECTNForms: Sectionnvarchar40
TOPBelgium
30T5BX2Assign Description text to BELCOTAX form, BOW (Obsolete)10SECTNSectionnvarchar40
31T5BX5Define sections to BELCOTAX forms (Obsolete)3SECTNSectionnvarchar40
32T5BX5TXTDescription of BELCOTAX form section (Obsolete)4SECTNSectionnvarchar40
33T5BX6Assign Description texts to BELCOTAX forms, BOW3SECTNSection of BOW print formnvarchar40
34T5BX8Define sections to BELCOTAX forms3SECTNSection of BOW print formnvarchar40
35T5BX8TDescription of BELCOTAX form section4SECTNSection of BOW print formnvarchar40
TOPFrance
36PA0217Infotype 0217 (INSEE Code)29SECTNSection (labor court elections)nvarchar10
37T5F1BCContribution base nature type code mapping3SECTNForms: Sectionnvarchar40
38T5F1BDContribution basis type code by application3SECTNForms: Sectionnvarchar40
39T5F1BDTWage type text contribution basis type code4SECTNForms: Sectionnvarchar40
40T77TNMFR_FSForms: Sections4SECTNForms: Sectionnvarchar40
TOPItaly
41PA3206HR Master Record: Infotype 320624SECTNDMA Sectionnvarchar40
42T5IT33Events and reasons3SECTNReport: section/partnvarchar100
43T5IT34Events and reasons3SECTNForms: Sectionnvarchar40
44T5ITDMA_1Fixed values for DMA DAQ fields5SECTNForms: Sectionnvarchar40
45T5ITDMA_2Fund values for DAQ fields4SECTNForms: Sectionnvarchar40
46T5ITNPTable for print contribution13SECTNReport: section/partnvarchar100
47T5ITUAUser Data Table of the Company for Report/ Legal Form6SECTNReport: section/partnvarchar100
48T5ITUBReport: report field mapping - output boxes3SECTNReport: section/partnvarchar100
49T5ITUDReport: report and attribution fields3SECTNReport: section/partnvarchar100
50T5ITUDTReport: field texts4SECTNReport: section/partnvarchar100
51T5ITUDT_CReport: field texts4SECTNReport: section/partnvarchar100
52T5ITUD_CReport: report and attribution fields3SECTNReport: section/partnvarchar100
53T5ITUGUnified reporting: output generation3SECTNReport: section/partnvarchar100
54T5ITUG_CUnified reporting: output generation3SECTNReport: section/partnvarchar100
55T5ITUIUser Data Table for Report / Legal Form4SECTNReport: section/partnvarchar100
56T5ITUPReport: post-processing field step3SECTNReport: section/partnvarchar100
57T5ITUP_CReport: post-processing field step3SECTNReport: section/partnvarchar100
58T5ITUSReport: section3SECTNReport: section/partnvarchar100
59T5ITUSTReport: section text4SECTNReport: section/partnvarchar100
60T5ITUS_CReport: section3SECTNReport: section/partnvarchar100
61T5ITVRdefinizione di variabili di UR per condizioni7SECTNReport: sezione/partenvarchar100
TOPPayroll
62T7UA_STAT_VARVariant Name of Statistical Report7SECTNForms: Sectionnvarchar40
63T7UA_STAT_VFLDView Variant Fields5SECTNForms: Sectionnvarchar40
64T7UA_STAT_VFLD_TNames of View Variant Fields6SECTNForms: Sectionnvarchar40
TOPPension fund General Parts
65T72T2HR-PF: TS Data Areas5SECTNData Areanvarchar40
66T72T2THR-PF: TS Data Areas6SECTNData Areanvarchar40
67T72T3HR-PF: TS Characteristics of Data Areas6SECTNData Areanvarchar40
TOPReuse Services for Country Development
68T5F99ADDate Types by DAQ Application4SECTNForms: Sectionnvarchar40
69T5F99ADTInfotype 0041 date mapping types text DAQ5SECTNForms: Sectionnvarchar40
70T5F99DMMapping of Infotype 0041 Date Types for DAQ applications4SECTNForms: Sectionnvarchar40
71T5F99FDForms: Construct4SECTNForms: Sectionnvarchar40
72T5F99FSForms: Sections4SECTNForms: Sectionnvarchar40
73T5F99FSTForms: Sections description5SECTNForms: Sectionnvarchar40
74T799BHRF02HRF Report sections4SECTNReport: section/partnvarchar300
75T799BHRF02CHRF Report customer sections4SECTNReport: section/partnvarchar300
76T799BHRF02THRF Report sections texts5SECTNReport: section/partnvarchar300
77T799BHRF03HRF Report fields4SECTNReport: section/partnvarchar300
78T799BHRF03CHRF Report customer fields4SECTNReport: section/partnvarchar300
79T799BHRF03THRF Report fields texts5SECTNReport: section/partnvarchar300
80T799BHRF04HRF Report output generation4SECTNReport: section/partnvarchar300
81T799BHRF04CHRF Report customer output generation4SECTNReport: section/partnvarchar300
82T799BHRF06HRF Report Post Processing8SECTNReport: section/partnvarchar300
83T799BHRF06CHRF Report Customer Post Processing8SECTNReport: section/partnvarchar300
TOPSpain
84T5EF7DAQ fields definition extension4SECTNForms: Sectionnvarchar40