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

Home | ERP 6.0  | T5Q_SUPERSTREAM
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
1ERP EHP76.0T5Q_SUPERSTREAM1541Super Stream Master Table
SQL:  selectupdate insert create

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

SELECT MANDT, RUNID, PERNR, SRNO, STATUS, SEQNR, IABKRS, INPER, FPPER, PAYTY, PAYID, BONDT, PAYDT, SDATE, STIME, SUSER, PRN2, FCODE, NEGSP, FILID, BUKRS, LINID, SOUID, SOENT, SOADD, ERMSG, SEABN, SORGN, SFNAM, SGNAM, SONAM, SEMAL, STELN, PAABN, PORGN, PABSB, PAACN, PACNT, PYABN, PYUSI, PYORG, PYTAD, PYMTH, TRNDT, PRNUM, BPAYC, PYAMT, PYBSB, PYACN, PYACT, ERABN, LOCID, EORGN, FNDGE, TAXFN, NTITL, NSUFX, PFNAM, PGNAM, PONAM, SEXCD, BDATE, ADRCO, ADDL1, ADDL2, ADDL3, ADDL4, LOCNM, PSTCD, STACO, CNTRY, MEMAL, MEMTL, MEMMB, MEMID, PAYNO, EMPEN, EMPET, PSTDT, PENDT, SAGAM, AWDAM, PCONT, SALSC, VOLAM, SPCON, CHCON, OTCON, EMSTD, ATWRK, ANBEN, ANCON, ACONS, ACONE, AINAM, WHRSW, OCCUD, INSIN, FNDRG, BENCT, EMPST, COSDT, COEDT, MEMRT, MPRTX, MPOTC, DBERC, NMPRT, NMPOT, NOERC, ORTER, APSWE, SUAPD, NSUAP, SERFR, SERED, FUTHR, CONHR, ACHRP, EMLOC, DSERF, DSERS, DSERE, EMPRT, EMPRS, EMPRE, MERAT, MERAS, MERAE, ANSA1, ANSD1, ANSE1, ANSA2, ANSD2, ANSE2, ANSA3, ANSD3, ANSE3, ANSA4, ANSD4, ANSE4, ANSA5, ANSD5, ANSE5, LWPCD, LWPCS, LWPCE, ASIED, ASBED, EMSED, EBEND, DEMLC, DEMLS, DEMLE FROM T5Q_SUPERSTREAM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2RUNIDHR B2A: Global Object IDnvarchar320CHAR(N' ')NoPC_B2A_GLBID Allow NULL? 
3PERNRPersonnel numbernvarchar80NUMC(N'00000000')No*PERSNO Allow NULL? 
4SRNOSuper Stream Unique running sequence numbernvarchar100NUMC(N'0000000000')NoP13Q_SRNO Allow NULL? 
5STATUSStatus of Recordnvarchar20CHAR(N' ')YesP13Q_STATUS Allow NULL? 
6SEQNRSequence Numbernvarchar50NUMC(N'00000')YesCDSEQ Allow NULL? 
7IABKRSPayroll Areanvarchar20CHAR(N' ')Yes*ABKRS Allow NULL? 
8INPERIn-period for payrollnvarchar60CHAR(N' ')YesIPERI Allow NULL? 
9FPPERFor-period for garnishmentnvarchar60CHAR(N' ')YesFPPER Allow NULL? 
10PAYTYPayroll typechar10CHAR(N' ')YesPAYTY Allow NULL? 
11PAYIDPayroll Identifierchar10CHAR(N' ')YesPAYID Allow NULL? 
12BONDTOff-cycle payroll payment datenvarchar80DATS(N'00000000')YesBONDT Allow NULL? 
13PAYDTPay date for payroll resultnvarchar80DATS(N'00000000')YesPAY_DATE Allow NULL? 
14SDATEDate of updation of Recordnvarchar80DATS(N'00000000')YesP13_SDATE Allow NULL? 
15STIMETime of update of recordnvarchar60TIMS(N'000000')YesP13_STIME Allow NULL? 
16SUSERUser Namenvarchar120CHAR(N' ')YesUNAME Allow NULL? 
17PRN2Payment Reference Numbernvarchar180CHAR(N' ')YesP13Q_PRN Allow NULL? 
18FCODESuperannuation Fund Codenvarchar40CHAR(N' ')Yes*P13Q_FCODE Allow NULL? 
19NEGSPNegatives Supportednvarchar50CHAR(N' ')YesP13_NEGSP Allow NULL? 
20FILIDFILE IDnvarchar500CHAR(N' ')YesP13_FILEID Allow NULL? 
21BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
22LINIDLINE IDnvarchar80NUMC(N'00000000')YesP13_LINEID Allow NULL? 
23SOUIDSource Entity IDnvarchar110NUMC(N'00000000000')YesP13_SRCEID Allow NULL? 
24SOENTSource Entity ID Typenvarchar400CHAR(N' ')YesP13_SOUENTY Allow NULL? 
25SOADDSource Electronic Service Addressnvarchar1200CHAR(N' ')YesP13_SOUADD Allow NULL? 
26ERMSGElectronic Error Messagingnvarchar100CHAR(N' ')YesP13_ERRMSG Allow NULL? 
27SEABNHR AU: Super Stream Source ABNnvarchar110NUMC(N'00000000000')YesP13_SUPFABN Allow NULL? 
28SORGNSender Organization Namenvarchar1200CHAR(N' ')YesP13_ORGNM Allow NULL? 
29SFNAMSender Family Namenvarchar400CHAR(N' ')YesP13_SFNAM Allow NULL? 
30SGNAMSender Given Namenvarchar400CHAR(N' ')YesP13_SGNAM Allow NULL? 
31SONAMSender Other Given Namenvarchar400CHAR(N' ')YesP13_SONAM Allow NULL? 
32SEMALSender E-mail Address Textnvarchar1200CHAR(N' ')YesP13_SEMAIL Allow NULL? 
33STELNTelephone Contact Numbernvarchar100CHAR(N' ')YesP13_TELNO Allow NULL? 
34PAABNPayer ABNnvarchar110NUMC(N'00000000000')YesP13_PABN Allow NULL? 
35PORGNPayer Organization Namenvarchar600CHAR(N' ')YesP13Q_ORGNAME1 Allow NULL? 
36PABSBBank State Branch Numbernvarchar150CHAR(N' ')YesP13_SBRNO Allow NULL? 
37PAACNFinancial Institution Account Numbernvarchar200CHAR(N' ')YesP13_FACNO Allow NULL? 
38PACNTFinancial Institution Account Namenvarchar400CHAR(N' ')YesP13_FACNM Allow NULL? 
39PYABNHR AU: Super Stream Target ABNnvarchar110NUMC(N'00000000000')YesP13_SUPTABN Allow NULL? 
40PYUSIUnique Superannuation Identification Numbernvarchar140CHAR(N' ')YesP13_USINO Allow NULL? 
41PYORGFund Organization Namenvarchar600CHAR(N' ')YesP13Q_ORGNAME2 Allow NULL? 
42PYTADEnd Point URLnvarchar1200CHAR(N' ')YesP13_EPURL Allow NULL? 
43PYMTHPayment Methodnvarchar150CHAR(N' ')YesP13_PAYMD Allow NULL? 
44TRNDTPayment Datenvarchar80DATS(N'00000000')YesP13_PAYDT Allow NULL? 
45PRNUMPayment Reference Numbernvarchar180CHAR(N' ')YesP13Q_PRN Allow NULL? 
46BPAYCBPay Biller Codenvarchar100CHAR(N' ')YesP13_BPBCD Allow NULL? 
47PYAMTSuper Stream Payment Amountdecimal132CURR((0))YesP13_SUPAMNT
48PYBSBBank State Branch Numbernvarchar150CHAR(N' ')YesP13_SBRNO Allow NULL? 
49PYACNFinancial Institution Account Numbernvarchar200CHAR(N' ')YesP13_FACNO Allow NULL? 
50PYACTFinancial Institution Account Namenvarchar400CHAR(N' ')YesP13_FACNM Allow NULL? 
51ERABNEmployer ABNnvarchar110NUMC(N'00000000000')YesP13_EABN Allow NULL? 
52LOCIDLocation IDnvarchar30NUMC(N'000')YesP13_LOCID Allow NULL? 
53EORGNEmployer Organizational Name Textnvarchar400CHAR(N' ')YesP13_EORGNAM Allow NULL? 
54FNDGESuperannuation Fund Generated Employer Identifiernvarchar200CHAR(N' ')YesP13Q_EMPLR Allow NULL? 
55TAXFNTax File Number (TFN)nvarchar90NUMC(N'000000000')YesP13Q_TAXFN Allow NULL? 
56NTITLPerson Name Title Textnvarchar150CHAR(N' ')Yes*P13_NTITL Allow NULL? 
57NSUFXPerson Name Suffix textnvarchar150CHAR(N' ')Yes*P13_NSUFX Allow NULL? 
58PFNAMMember Family Namenvarchar400CHAR(N' ')YesP13_PFNAM Allow NULL? 
59PGNAMMember Given Namenvarchar400CHAR(N' ')YesP13_PGNAM Allow NULL? 
60PONAMMember Other Given Namenvarchar400CHAR(N' ')YesP13_PONAM Allow NULL? 
61SEXCDSex Codenvarchar70CHAR(N' ')YesP13_SEXCODE Allow NULL? 
62BDATEDate of Birthnvarchar80DATS(N'00000000')YesGBDAT Allow NULL? 
63ADRCOAddress Usage Codenvarchar40CHAR(N' ')YesP13_ADDCD Allow NULL? 
64ADDL1Address Details Line 1 Textnvarchar700CHAR(N' ')YesP13_ADL1 Allow NULL? 
65ADDL2Address Details Line 2 Textnvarchar700CHAR(N' ')YesP13_ADL2 Allow NULL? 
66ADDL3Address Details Line 3 Textnvarchar700CHAR(N' ')YesP13_ADL3 Allow NULL? 
67ADDL4Address Details Line 4 Textnvarchar700CHAR(N' ')YesP13_ADL4 Allow NULL? 
68LOCNMLocality Name Textnvarchar700CHAR(N' ')YesP13_LOCNAM Allow NULL? 
69PSTCDPostal Codenvarchar100CHAR(N' ')YesPSTLZ_HR Allow NULL? 
70STACOState or Territory Codenvarchar700CHAR(N' ')YesP13_STATCO Allow NULL? 
71CNTRYCountry Keynvarchar30CHAR(N' ')Yes*LAND1 Allow NULL? 
72MEMALE-mail Addressnvarchar1200CHAR(N' ')YesP13_EADDR Allow NULL? 
73MEMTLMember Telephone Minimal Number Landlinenvarchar100CHAR(N' ')YesP13_MTELNO Allow NULL? 
74MEMMBMember Telephone Minimal Number Mobilenvarchar100CHAR(N' ')YesP13_MMOBNO Allow NULL? 
75MEMIDMember Client Identifiernvarchar200CHAR(N' ')YesP13_MEMIDEN Allow NULL? 
76PAYNOPayroll Number Identifiernvarchar80NUMC(N'00000000')Yes*P13_PAYIDN Allow NULL? 
77EMPENEmployee Employment End datenvarchar80DATS(N'00000000')YesP13_EMPENDT Allow NULL? 
78EMPETEmployment End Reason Textnvarchar300CHAR(N' ')YesP13_EMPENDTEXT Allow NULL? 
79PSTDTPay Period Start Datenvarchar80DATS(N'00000000')YesP13_PSRTDT Allow NULL? 
80PENDTPay Period End Datenvarchar80DATS(N'00000000')YesP13_PENDT Allow NULL? 
81SAGAMEmployer Super Annuation Guarantee Amountdecimal132CURR((0))YesP13_SGCAMT
82AWDAMEmployer Contributions Award Or Productivity Amountdecimal132CURR((0))YesP13_AWDAMT
83PCONTEmployee Personal Contributions Amountdecimal132CURR((0))YesP13_EECAMT
84SALSCEmployer Contributions Salary Sacrificed Amountdecimal132CURR((0))YesP13_SCFAMT
85VOLAMEmployer Voluntary contribution amountdecimal132CURR((0))YesP13_ERVOL
86SPCONSpouse Contribution Amountdecimal132CURR((0))YesP13_SPOUSE
87CHCONChild Contribution Amountdecimal132CURR((0))YesP13_CHILD
88OTCONThird Party Contribution Amountdecimal132CURR((0))YesP13_3PCNTR
89EMSTDEmployment Start Datenvarchar80DATS(N'00000000')YesP13_EMSTDT Allow NULL? 
90ATWRKAt Work Indicatornvarchar70CHAR(N' ')YesP13_ATWRK Allow NULL? 
91ANBENAnnual Salary for Benefits Amountdecimal132CURR((0))YesP13_ANBEN
92ANCONAnnual Salary for Contributions Amountdecimal132CURR((0))YesP13_ANSALCON
93ACONSSuper Contribution Start Datenvarchar80DATS(N'00000000')YesP13_CONTSTDAT Allow NULL? 
94ACONESuper Contribution End Datenvarchar80DATS(N'00000000')YesP13_CONTENDAT Allow NULL? 
95AINAMAnnual Salary for Insurance Amountdecimal132CURR((0))YesP13_ANSALINS
96WHRSWWeekly Hours Worked Numberdecimal52DEC((0))YesP13_WHRS
97OCCUDOccupation Descriptionnvarchar400CHAR(N' ')YesP13_OCCDS Allow NULL? 
98INSINInsurance Opt Out Indicatornvarchar100CHAR(N' ')YesP13_INSIN Allow NULL? 
99FNDRGSuper Fund Registration Datenvarchar80DATS(N'00000000')YesP13_FUNDREGDT Allow NULL? 
100BENCTBenefit Categorynvarchar1200CHAR(N' ')YesP13_BNFCT Allow NULL? 
101EMPSTHR AU: Employment Status Of Employeenvarchar200CHAR(N' ')YesP13_EMP_STAT Allow NULL? 
102COSDTSuper Contribution Commence Datenvarchar80DATS(N'00000000')YesP13_CONTCOMDAT Allow NULL? 
103COEDTSuper Contribution Cease Datenvarchar80DATS(N'00000000')YesP13_CONTCEADAT Allow NULL? 
104MEMRTMember Registration Textnvarchar400CHAR(N' ')YesP13_REGTX Allow NULL? 
105MPRTXDefined Benefit Member Pre Tax Contributiondecimal132CURR((0))YesP13_DBPRT
106MPOTCDefined Benefit Member Post Tax Contributiondecimal132CURR((0))YesP13_DBPOT
107DBERCDefined Benefit Employer Contributiondecimal132CURR((0))YesP13_DBERCON
108NMPRTDefined Benefit Notional Member Pre Tax Contributiondecimal132CURR((0))YesP13_DBNPRT
109NMPOTDefined Benefit Notional Member Post Tax Contributiondecimal132CURR((0))YesP13_DBNPOT
110NOERCDefined Benefit Notional Employer Contributiondecimal132CURR((0))YesP13_DBNERCON
111ORTEROrdinary Time Earningsdecimal132CURR((0))YesP13_DBOTE
112APSWEActual Periodic Salary or Wages Earneddecimal132CURR((0))YesP13_DBAPS
113SUAPDSuperannuable Allowances Paiddecimal132CURR((0))YesP13_DBSAP
114NSUAPNotional Superannuable Allowancesdecimal132CURR((0))YesP13_DBNSAP
115SERFRService Fractiondecimal65DEC((0))YesP13_DBSFR
116SEREDService Fraction Effective Datenvarchar80DATS(N'00000000')YesP13_DBSED Allow NULL? 
117FUTHRFull Time Hoursdecimal73DEC((0))YesP13_DBFTH
118CONHRContracted Hoursdecimal73DEC((0))YesP13_DBCNH
119ACHRPActual Hours Paiddecimal73DEC((0))YesP13_DBAHP
120EMLOCEmployee Location Identifiernvarchar200CHAR(N' ')YesP13_DBELOC Allow NULL? 
121DSERFDefined Benefits Registration Service Fractiondecimal65DEC((0))YesP13_DBRSF
122DSERSService Fraction Start Datenvarchar80DATS(N'00000000')YesP13_DBRSD Allow NULL? 
123DSEREService Fraction End Datenvarchar80DATS(N'00000000')YesP13_DBRSED Allow NULL? 
124EMPRTDefined Benefit Employer Ratedecimal52DEC((0))YesP13_DBRER
125EMPRSDefined Benefit Employer Rate Start Datenvarchar80DATS(N'00000000')YesP13_DBERS Allow NULL? 
126EMPREDefined Benefit Employer Rate End Datenvarchar80DATS(N'00000000')YesP13_DBERE Allow NULL? 
127MERATDefined Benefit Member Ratedecimal52DEC((0))YesP13_DBMRT
128MERASDefined Benefit Member Rate Start Datenvarchar80DATS(N'00000000')YesP13_DBMRS Allow NULL? 
129MERAEDefined Benefit Member Rate End Datenvarchar80DATS(N'00000000')YesP13_DBMRE Allow NULL? 
130ANSA1Defined Benefit Annual Salary 1decimal132CURR((0))YesP13_DBAS1
131ANSD1Defined Benefit Annual Salary 1 Start Datenvarchar80DATS(N'00000000')YesP13_DBASS1 Allow NULL? 
132ANSE1Defined Benefit Annual Salary 1 End Datenvarchar80DATS(N'00000000')YesP13_DBASE1 Allow NULL? 
133ANSA2Defined Benefit Annual Salary 2decimal132CURR((0))YesP13_DBAS2
134ANSD2Defined Benefit Annual Salary 2 Start Datenvarchar80DATS(N'00000000')YesP13_DBASS2 Allow NULL? 
135ANSE2Defined Benefit Annual Salary 2 End Datenvarchar80DATS(N'00000000')YesP13_DBASE2 Allow NULL? 
136ANSA3Defined Benefit Annual Salary 3decimal132CURR((0))YesP13_DBAS3
137ANSD3Defined Benefit Annual Salary 3 Start Datenvarchar80DATS(N'00000000')YesP13_DBASS3 Allow NULL? 
138ANSE3Defined Benefit Annual Salary 3 End Datenvarchar80DATS(N'00000000')YesP13_DBASE3 Allow NULL? 
139ANSA4Defined Benefit Annual Salary 4decimal132CURR((0))YesP13_DBAS4
140ANSD4Defined Benefit Annual Salary 4 Start Datenvarchar80DATS(N'00000000')YesP13_DBASS4 Allow NULL? 
141ANSE4Defined Benefit Annual Salary 4 End Datenvarchar80DATS(N'00000000')YesP13_DBASE4 Allow NULL? 
142ANSA5Defined Benefit Annual Salary 5decimal132CURR((0))YesP13_DBAS5
143ANSD5Defined Benefit Annual Salary 5 Start Datenvarchar80DATS(N'00000000')YesP13_DBASS5 Allow NULL? 
144ANSE5Defined Benefit Annual Salary 5 End Datenvarchar80DATS(N'00000000')YesP13_DBASE5 Allow NULL? 
145LWPCDLeave Without Pay Codechar10NUMC(N'0')YesP13_DBLWPC Allow NULL? 
146LWPCSLeave Without Pay Code Start Datenvarchar80DATS(N'00000000')YesP13_DBLWPS Allow NULL? 
147LWPCELeave Without Pay Code End Datenvarchar80DATS(N'00000000')YesP13_DBLWPE Allow NULL? 
148ASIEDAnnual Salary for Insurance Effective Datenvarchar80DATS(N'00000000')YesP13_ASIED Allow NULL? 
149ASBEDAnnual Salary for Benefits Effective Datenvarchar80DATS(N'00000000')YesP13_ASBED Allow NULL? 
150EMSEDEmployee Status Effective Datenvarchar80DATS(N'00000000')YesP13_ESED Allow NULL? 
151EBENDEmployee Benefit Category Effective Datenvarchar80DATS(N'00000000')YesP13_EBCED Allow NULL? 
152DEMLCEmployee Location Identifiernvarchar200CHAR(N' ')YesP13_DBELOC Allow NULL? 
153DEMLSEmployee Location Identifier Start Datenvarchar80DATS(N'00000000')YesP13_ELOCS Allow NULL? 
154DEMLEEmployee Location Identifier End Datenvarchar80DATS(N'00000000')YesP13_ELOCE Allow NULL? 
NamePrimaryUniqueTypeColumns
T5Q_SUPERSTREAM~0YesYesCLUSTEREDSRNO, PERNR, RUNID, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy