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
Basis Components :: Customizing :: Customizing Tools Techniques :: Implementation Guide
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TMPOBJRES1771Temporary BC Set Check Report DataImplementation Guide
SQL:  selectupdate insert create

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

SELECT ACTIVITY, OBJECTNAME, OBJECTTYPE, SEQU_NO, TCODE, DUMMY, STANDARDTA, PARAM_TA, WRONG_OBJ, RIGHT_OBJ, BEF_EXP_ME, AFT_IMP_ME, IMPORTABLE, MOD_DIALOG, NOTINOBJS, NOTINOBJH, NOTINSYST, INVAL_V_D, INCONSOBJS, INCONSIST, PRIORITY, OBJ_EXCEPT, IMG_EXCEPT, DOCU, ACTIVATE, ACT_VERIF, LOCK_DATA, FUSER_IMG, FUSER_OBJ, LUSER_IMG, LUSER_OBJ, DEVC_IMG, DEVC_OBJ, COMP_IMG, COMP_OBJ, LDATE_IMG, LDATE_OBJ, LTIME_IMG, LTIME_OBJ, LOCAL_ACTI, SRCSYSTEM_IMG, SRCSYSTEM_OBJ, IS_ORGACT, IS_BADI, NO_CUSTOBJ, DELIVERYCL, INCONSDYCL, RIGHT_DYCL, SYSTEMOBJ, ONEDCOBJNC, ONEDCALLNC, ALLDCOBJNC, ALLDCALLNC, TABEXPLDEN, TABEXPLALW, ONEDENOBJT, ONEDENALLT, ALLDENOBJT, ALLDENALLT, ONECDEPALL, ONECDEPOBJ, ALLCDEPALL, ALLCDEPOBJ, ONECCASALL, ONECCASOBJ, ALLCCASALL, ALLCCASOBJ, MIXEDCDEPO, MIXEDCDEPA, MIXEDCCASO, MIXEDCCASA, READ_ONLY, OBJ_BCSDEN, IMG_BCSDEN, TADIROBLIG, WRONG_IMP, PRMTAB_MIS FROM TMPOBJRES1
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1ACTIVITYIMG Activitynvarchar200CHAR(N' ')No*CUS_IMG_AC Allow NULL? 
2OBJECTNAMEObject Namenvarchar300CHAR(N' ')No*OB_OBJECT Allow NULL? 
3OBJECTTYPEObject typechar10CHAR(N' ')NoOB_TYP Allow NULL? 
4SEQU_NO2 byte integer (signed)smallint50INT2((0))NoINT2
5TCODETransaction Codenvarchar200CHAR(N' ')No*TCODE Allow NULL? 
6DUMMYCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
7STANDARDTACharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
8PARAM_TACharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
9WRONG_OBJCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
10RIGHT_OBJObject Namenvarchar300CHAR(N' ')Yes*OB_OBJECT Allow NULL? 
11BEF_EXP_MEName of Function Modulenvarchar300CHAR(N' ')Yes*RS38L_FNAM Allow NULL? 
12AFT_IMP_MEName of Function Modulenvarchar300CHAR(N' ')Yes*RS38L_FNAM Allow NULL? 
13IMPORTABLEFlag: Object can be adjustedchar10CHAR(N' ')YesOBJIMP Allow NULL? 
14MOD_DIALOGCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
15NOTINOBJSCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
16NOTINOBJHCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
17NOTINSYSTCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
18INVAL_V_DCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
19INCONSOBJSCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
20INCONSISTCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
21PRIORITYCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
22OBJ_EXCEPTCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
23IMG_EXCEPTCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
24DOCUStatus Flag for BC Set Use Scenarionvarchar20CHAR(N' ')Yes*SCEN_FLAG Allow NULL? 
25ACTIVATEStatus Flag for BC Set Use Scenarionvarchar20CHAR(N' ')Yes*SCEN_FLAG Allow NULL? 
26ACT_VERIFStatus Flag for BC Set Use Scenarionvarchar20CHAR(N' ')Yes*SCEN_FLAG Allow NULL? 
27LOCK_DATAStatus Flag for BC Set Use Scenarionvarchar20CHAR(N' ')Yes*SCEN_FLAG Allow NULL? 
28FUSER_IMGPerson Responsible for a Repository Objectnvarchar120CHAR(N' ')YesRESPONSIBL Allow NULL? 
29FUSER_OBJPerson Responsible for a Repository Objectnvarchar120CHAR(N' ')YesRESPONSIBL Allow NULL? 
30LUSER_IMGPerson Responsible for a Repository Objectnvarchar120CHAR(N' ')YesRESPONSIBL Allow NULL? 
31LUSER_OBJPerson Responsible for a Repository Objectnvarchar120CHAR(N' ')YesRESPONSIBL Allow NULL? 
32DEVC_IMGPackagenvarchar300CHAR(N' ')Yes*DEVCLASS Allow NULL? 
33DEVC_OBJPackagenvarchar300CHAR(N' ')Yes*DEVCLASS Allow NULL? 
34COMP_IMGApplication Componentnvarchar200CHAR(N' ')Yes*UFFCTR Allow NULL? 
35COMP_OBJApplication Componentnvarchar200CHAR(N' ')Yes*UFFCTR Allow NULL? 
36LDATE_IMGLast Changed Onnvarchar80DATS(N'00000000')YesHIER_LDATE Allow NULL? 
37LDATE_OBJDatenvarchar80DATS(N'00000000')YesDATUM Allow NULL? 
38LTIME_IMGTime of Last Changenvarchar60TIMS(N'000000')YesHIER_LTIME Allow NULL? 
39LTIME_OBJField of type TIMSnvarchar60TIMS(N'000000')YesTIMS Allow NULL? 
40LOCAL_ACTICharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
41SRCSYSTEM_IMGOriginal System of Objectnvarchar100CHAR(N' ')YesSRCSYSTEM Allow NULL? 
42SRCSYSTEM_OBJOriginal System of Objectnvarchar100CHAR(N' ')YesSRCSYSTEM Allow NULL? 
43IS_ORGACTCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
44IS_BADICharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
45NO_CUSTOBJCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
46DELIVERYCLDelivery classchar10CHAR(N' ')YesCONTFLAG Allow NULL? 
47INCONSDYCLCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
48RIGHT_DYCLDelivery classchar10CHAR(N' ')YesCONTFLAG Allow NULL? 
49SYSTEMOBJCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
50ONEDCOBJNCCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
51ONEDCALLNCCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
52ALLDCOBJNCCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
53ALLDCALLNCCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
54TABEXPLDENCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
55TABEXPLALWCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
56ONEDENOBJTCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
57ONEDENALLTCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
58ALLDENOBJTCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
59ALLDENALLTCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
60ONECDEPALLCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
61ONECDEPOBJCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
62ALLCDEPALLCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
63ALLCDEPOBJCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
64ONECCASALLCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
65ONECCASOBJCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
66ALLCCASALLCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
67ALLCCASOBJCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
68MIXEDCDEPOCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
69MIXEDCDEPACharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
70MIXEDCCASOCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
71MIXEDCCASACharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
72READ_ONLYCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
73OBJ_BCSDENCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
74IMG_BCSDENCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
75TADIROBLIGCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
76WRONG_IMPCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
77PRMTAB_MISCharacter Field Length 1char10CHAR(N' ')YesCHAR01 Allow NULL? 
NamePrimaryUniqueTypeColumns
TMPOBJRES1~0YesYesCLUSTEREDACTIVITY, OBJECTNAME, OBJECTTYPE, SEQU_NO, TCODE