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
9OVTG52Tax Definition
10OPOR386Purchase Order

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
Enterprise Controlling :: Executive Information System :: Data Collection
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CF0051411Personnel InformationData Collection
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, RECTY, VERSO, YEARB, PERDE, COMPN, EORGE, IORGE, KOSTE, RFORM, BRNCH, LAND1, VALTY, RECNR, AEDTM, UNAME, PINTR, MITAB, QMITAB, ARBTR, QARBTR, ANGES, QANGES, AZUBI, QAZUBI, TZBES, QTZBES, FRAUN, QFRAUN, EXTAB, QEXTAB, UNTAB, QUNTAB, FRWAB, QFRWAB, EX1AB, QEX1AB, INTAB, QINTAB, EXTZU, QEXTZU, INTZU, QINTZU, DAUER, QDAUER, ALTRS, QALTRS, SALTR, QSALTR, ALTAR, QALTAR, SALTA, QSALTA, ALTAN, QALTAN, SALTN, QSALTN, ALTAZ, QALTAZ, SALTZ, QSALTZ, SOLAZ, QSOLAZ, ISTAZ, QISTAZ, OVRAZ, QOVRAZ, FZKRK, QFZKRK, FZURL, QFZURL, FZKAZ, QFZKAZ, SZBFR, QSZBFR, ISTFR, QISTFR, SOSBH, QSOSBH, UMSAZ, CUMSAZ, DBTRG, CDBTRG, BASBZ, CBASBZ, SOBEZ, CSOBEZ, ISTBZ, CISTBZ, EINKO, CEINKO, FRWKO, CFRWKO, GEMKO, CGEMKO, AUSKO, CAUSKO, WBLBD, QWBLBD, SWBLB, QSWBLB, EIGRD, QEIGRD, SEIGR, QSEIGR, IWGMA, QIWGMA, EWGMA, QEWGMA, IWBVA, QIWBVA, EWBVA, QEWBVA, IWBTG, QIWBTG, EWBTG, QEWBTG, IWBKO, CIWBKO, EWBKO, CEWBKO, OFPLS, QOFPLS, PERBD, QPERBD, BEWRB, QBEWRB, SBWRB, QSBWRB, BESKO, CBESKO, ANWKO, CANWKO, ALTRF, QALTRF, FSTLV, QFSTLV, OFNFP, QOFNFP, FRPOS, QFRPOS FROM CF005
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2RECTYRecord typechar10CHAR(N' ')NoCFRECTY Allow NULL? 
3VERSOData area (previously version)nvarchar20NUMC(N'00')NoT242VCFVERSO Allow NULL? 
4YEARBFiscal Yearnvarchar40NUMC(N'0000')NoCFYEARB Allow NULL? 
5PERDEPeriodnvarchar30NUMC(N'000')NoCFPERDE Allow NULL? 
6COMPNCompanynvarchar40CHAR(N' ')NoCFCOMPN Allow NULL? 
7EORGEExternal organizational unitnvarchar80NUMC(N'00000000')NoCFEORGE Allow NULL? 
8IORGEOrganizational unitnvarchar80NUMC(N'00000000')NoCFIORGE Allow NULL? 
9KOSTECost centernvarchar140CHAR(N' ')NoCFKOSTE Allow NULL? 
10RFORMLegal form (of company)nvarchar30NUMC(N'000')NoCFRFORM Allow NULL? 
11BRNCHSector of industry (of company)nvarchar30NUMC(N'000')NoCFBRNCH Allow NULL? 
12LAND1Country Keynvarchar30CHAR(N' ')NoT005LAND1 Allow NULL? 
13VALTYValue typechar10CHAR(N' ')NoT242WCFVALTY Allow NULL? 
14RECNRCO-BPC record numbernvarchar80NUMC(N'00000000')NoCFRECNR Allow NULL? 
15AEDTMChanged Onnvarchar80DATS(N'00000000')YesCFAEDTM Allow NULL? 
16UNAMEUser namenvarchar120CHAR(N' ')YesCFUNAME Allow NULL? 
17PINTRReference to reportsnvarchar80NUMC(N'00000000')YesCFPINTR Allow NULL? 
18MITABNumber of employeesdecimal153QUAN((0))YesCFMITAB
19QMITABUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
20ARBTRNumber of hourly-paid workersdecimal153QUAN((0))YesCFARBTR
21QARBTRUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
22ANGESNumber of salaried employeesdecimal153QUAN((0))YesCFANGES
23QANGESUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
24AZUBINumber of traineesdecimal153QUAN((0))YesCFAZUBI
25QAZUBIUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
26TZBESNumber of part-time employeesdecimal153QUAN((0))YesCFTZBES
27QTZBESUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
28FRAUNNumber of female employeesdecimal153QUAN((0))YesCFFRAUN
29QFRAUNUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
30EXTABExternal outflow of employeesdecimal153QUAN((0))YesCFEXTAB
31QEXTABUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
32UNTABNumber of terminations of contract by employerdecimal153QUAN((0))YesCFUNTAB
33QUNTABUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
34FRWABNumber of terminations of contract by employeesdecimal153QUAN((0))YesCFFRWAB
35QFRWABUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
36EX1ABExternal outflow of employees (1st year)decimal153QUAN((0))YesCFEX1AB
37QEX1ABUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
38INTABInternal outflow of employeesdecimal153QUAN((0))YesCFINTAB
39QINTABUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
40EXTZUExternal inflow of employeesdecimal153QUAN((0))YesCFEXTZU
41QEXTZUUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
42INTZUInternal inflow of employeesdecimal153QUAN((0))YesCFINTZU
43QINTZUUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
44DAUERLength of time employeddecimal153QUAN((0))YesCFDAUER
45QDAUERUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
46ALTRSTotal agedecimal153QUAN((0))YesCFALTRS
47QALTRSUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
48SALTRAge spreaddecimal153QUAN((0))YesCFSALTR
49QSALTRUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
50ALTARTotal age of wage earnersdecimal153QUAN((0))YesCFALTAR
51QALTARUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
52SALTAAge spread of wage earnersdecimal153QUAN((0))YesCFSALTA
53QSALTAUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
54ALTANTotal age of salary earnersdecimal153QUAN((0))YesCFALTAN
55QALTANUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
56SALTNAge spread of salary earnersdecimal153QUAN((0))YesCFSALTN
57QSALTNUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
58ALTAZTotal age of traineesdecimal153QUAN((0))YesCFALTAZ
59QALTAZUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
60SALTZAge spread of traineesdecimal153QUAN((0))YesCFSALTZ
61QSALTZUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
62SOLAZPlanned work timedecimal153QUAN((0))YesCFSOLAZ
63QSOLAZUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
64ISTAZActual working timedecimal153QUAN((0))YesCFISTAZ
65QISTAZUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
66OVRAZOvertimedecimal153QUAN((0))YesCFOVRAZ
67QOVRAZUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
68FZKRKTime absent due to sicknessdecimal153QUAN((0))YesCFFZKRK
69QFZKRKUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
70FZURLTime absent for vacationdecimal153QUAN((0))YesCFFZURL
71QFZURLUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
72FZKAZTime absent due to reduced hoursdecimal153QUAN((0))YesCFFZKAZ
73QFZKAZUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
74SZBFRPlanned worktime for employees on a limited contractdecimal153QUAN((0))YesCFSZBFR
75QSZBFRUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
76ISTFRActual work time of external personneldecimal153QUAN((0))YesCFISTFR
77QISTFRUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
78SOSBHPlanned work time for severely handicappeddecimal153QUAN((0))YesCFSOSBH
79QSOSBHUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
80UMSAZSales revenuedecimal152CURR((0))YesCFUMSAZ
81CUMSAZCurrencynvarchar50CUKY(N' ')YesTCURCCFCUKY Allow NULL? 
82DBTRGContribution margindecimal152CURR((0))YesCFDBTRG
83CDBTRGCurrencynvarchar50CUKY(N' ')YesTCURCCFCUKY Allow NULL? 
84BASBZBasic Paydecimal152CURR((0))YesCFBASBZ
85CBASBZCurrencynvarchar50CUKY(N' ')YesTCURCCFCUKY Allow NULL? 
86SOBEZPlanned remunerationdecimal152CURR((0))YesCFSOBEZ
87CSOBEZCurrencynvarchar50CUKY(N' ')YesTCURCCFCUKY Allow NULL? 
88ISTBZActual remunerationdecimal152CURR((0))YesCFISTBZ
89CISTBZCurrencynvarchar50CUKY(N' ')YesTCURCCFCUKY Allow NULL? 
90EINKOEmployee benefit costs: Direct costsdecimal152CURR((0))YesCFEINKO
91CEINKOCurrencynvarchar50CUKY(N' ')YesTCURCCFCUKY Allow NULL? 
92FRWKOVoluntary direct costsdecimal152CURR((0))YesCFFRWKO
93CFRWKOCurrencynvarchar50CUKY(N' ')YesTCURCCFCUKY Allow NULL? 
94GEMKOEmployee benefit costs: Overhead costsdecimal152CURR((0))YesCFGEMKO
95CGEMKOCurrencynvarchar50CUKY(N' ')YesTCURCCFCUKY Allow NULL? 
96AUSKOTraining costsdecimal152CURR((0))YesCFAUSKO
97CAUSKOCurrencynvarchar50CUKY(N' ')YesTCURCCFCUKY Allow NULL? 
98WBLBDFurther education requirementdecimal153QUAN((0))YesCFWBLBD
99QWBLBDUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
100SWBLBSpread of further education requirementdecimal153QUAN((0))YesCFSWBLB
101QSWBLBUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
102EIGRDTotal degree of aptitudedecimal153QUAN((0))YesCFEIGRD
103QEIGRDUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
104SEIGRSpread of aptitudedecimal153QUAN((0))YesCFSEIGR
105QSEIGRUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
106IWGMANumber of employees with internal further educationdecimal153QUAN((0))YesCFIWGMA
107QIWGMAUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
108EWGMANumber of employees with external further educationdecimal153QUAN((0))YesCFEWGMA
109QEWGMAUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
110IWBVANumber of internal further education eventsdecimal153QUAN((0))YesCFIWBVA
111QIWBVAUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
112EWBVANumber of external further education eventsdecimal153QUAN((0))YesCFEWBVA
113QEWBVAUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
114IWBTGNumber of days spent on internal further educationdecimal153QUAN((0))YesCFIWBTG
115QIWBTGUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
116EWBTGExternal further education daysdecimal153QUAN((0))YesCFEWBTG
117QEWBTGUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
118IWBKOInternal further education costsdecimal152CURR((0))YesCFIWBKO
119CIWBKOCurrencynvarchar50CUKY(N' ')YesTCURCCFCUKY Allow NULL? 
120EWBKOExternal further education costsdecimal152CURR((0))YesCFEWBKO
121CEWBKOCurrencynvarchar50CUKY(N' ')YesTCURCCFCUKY Allow NULL? 
122OFPLSNumber of vacancies planneddecimal153QUAN((0))YesCFOFPLS
123QOFPLSUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
124PERBDWorkforce requirementsdecimal153QUAN((0))YesCFPERBD
125QPERBDUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
126BEWRBNumber of applicationsdecimal153QUAN((0))YesCFBEWRB
127QBEWRBUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
128SBWRBNumber of spontaneous applicationsdecimal153QUAN((0))YesCFSBWRB
129QSBWRBUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
130BESKOCosts of aquisitiondecimal152CURR((0))YesCFBESKO
131CBESKOCurrencynvarchar50CUKY(N' ')YesTCURCCFCUKY Allow NULL? 
132ANWKORecruitment costsdecimal152CURR((0))YesCFANWKO
133CANWKOCurrencynvarchar50CUKY(N' ')YesTCURCCFCUKY Allow NULL? 
134ALTRFAge of managersdecimal153QUAN((0))YesCFALTRF
135QALTRFUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
136FSTLVNumber of assistant managersdecimal153QUAN((0))YesCFFSTLV
137QFSTLVUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
138OFNFPVacant management positionsdecimal153QUAN((0))YesCFOFNFP
139QOFNFPUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
140FRPOSNumber of managersdecimal153QUAN((0))YesCFFRPOS
141QFRPOSUnitnvarchar30UNIT(N' ')YesT006CFUNIT Allow NULL? 
NamePrimaryUniqueTypeColumns
CF005~0YesYesCLUSTEREDRECNR, VALTY, LAND1, BRNCH, RFORM, KOSTE, IORGE, EORGE, COMPN, PERDE, YEARB, VERSO, RECTY, MANDT