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
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Basis Components :: ABAP Workbench, Java IDE and Infrastructure :: Proxy Generation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0SPROXDAT566Proxy Metadata (Substitution Table)Proxy Generation
SQL:  selectupdate insert create

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

SELECT OBJECT, OBJ_NAME, OBJECT1, OBJ_NAME1, OBJECT2, OBJ_NAME2, INACTIVE, OBJECT_R, OBJ_NAME_R, ID, IFR_TYPE, IFR_NAME, IFR_TEXT, IFR_LANGU, IFR_REPTERM, IFR_LABEL_F, IFR_LABEL_C, IFR_TEXTID, IFR_TAGTYP, IFR_MINOCC, IFR_MAXOCC, IFR_OPTNL, IFR_DEFLT, IFR_QUALIF, IFR_XSDTYP, IFR_LENGTH, IFR_MAXLEN, IFR_MINLEN, IFR_NILLABLE, IFR_PATTRN, IFR_PREC, IFR_SCALE, IFR_FAULT, IFR_ACTIONCODE, IFR_IDEMPOTENT, R3_TYPE, R3_NAME, R3_TEXT, R3_DATATYP, R3_LENGTH, R3_DECIMAL, R3_REFTO, R3_DTREF, R3_INCLUDE, R3_SEQNUM, R3_BOXED, CATEGORY, DIRECTION, INSTANCE, SYNCHRON, KEYPARAM, PROBLEMS, WARNINGS, PROBL_INF, FURTHERDATA, ENUMTYPE FROM SPROXDAT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1OBJECTProxy Generation: Object Type in R3 (DTEL, TABL,...)nvarchar40CHAR(N' ')NoPRX_R3OBJ Allow NULL? 
2OBJ_NAMEProxy Generation: Name of an Object in R/3nvarchar300CHAR(N' ')NoPRX_R3NAME Allow NULL? 
3OBJECT1Proxy Generation: Object Type in R3 (DTEL, TABL,...)nvarchar40CHAR(N' ')NoPRX_R3OBJ Allow NULL? 
4OBJ_NAME1Proxy Generation: Name of an Object in R/3nvarchar300CHAR(N' ')NoPRX_R3NAME Allow NULL? 
5OBJECT2Proxy Generation: Object Type in R3 (DTEL, TABL,...)nvarchar40CHAR(N' ')NoPRX_R3OBJ Allow NULL? 
6OBJ_NAME2Proxy Generation: Name of an Object in R/3nvarchar300CHAR(N' ')NoPRX_R3NAME Allow NULL? 
7INACTIVEProxy Generation: Flag for Inactive Versionchar10CHAR(N' ')NoPRX_INACT Allow NULL? 
8OBJECT_RProxy Generation: Object Type in R3 (DTEL, TABL,...)nvarchar40CHAR(N' ')YesPRX_R3OBJ Allow NULL? 
9OBJ_NAME_RProxy Generation: Name of an Object in R/3nvarchar300CHAR(N' ')YesPRX_R3NAME Allow NULL? 
10IDProxy Generation: Unique ID of a Proxy Objectntext10737418230YesPRX_ID
11IFR_TYPEProxy Generation: WSDL Type (portType, message, and so on)nvarchar300CHAR(N' ')NoPRX_WSDLTY Allow NULL? 
12IFR_NAMEProxy Generation: External Namenvarchar1200CHAR(N' ')NoPRX_IFRNAM Allow NULL? 
13IFR_TEXTProxy Generation: Short Text of an Object in the IFRnvarchar1000CHAR(N' ')NoPRX_IFRTXT Allow NULL? 
14IFR_LANGUProxy Generation: Original Languagenvarchar20CHAR(N' ')NoPRX_LANGU Allow NULL? 
15IFR_REPTERMRepresentation Termnvarchar300CHAR(N' ')NoPRX_REPTERM Allow NULL? 
16IFR_LABEL_Fnvarchar400(N' ')Yes Allow NULL? 
17IFR_LABEL_Cnvarchar550(N' ')Yes Allow NULL? 
18IFR_TEXTIDnvarchar320(N' ')Yes Allow NULL? 
19IFR_TAGTYPProxy Generation: Tag Type (Normal, Invisible, ...)char10CHAR(N' ')NoPRX_TAGTYP Allow NULL? 
20IFR_MINOCCint100((0))Yes Allow NULL? 
21IFR_MAXOCCint100((0))Yes Allow NULL? 
22IFR_OPTNLchar10(N' ')Yes Allow NULL? 
23IFR_DEFLTntext10737418230Yes
24IFR_QUALIFchar10(N' ')Yes Allow NULL? 
25IFR_XSDTYPnvarchar300(N' ')Yes Allow NULL? 
26IFR_LENGTHint100((0))Yes Allow NULL? 
27IFR_MAXLENint100((0))Yes Allow NULL? 
28IFR_MINLENint100((0))Yes Allow NULL? 
29IFR_NILLABLEchar10(N' ')Yes Allow NULL? 
30IFR_PATTRNnvarchar2550(N' ')Yes Allow NULL? 
31IFR_PRECint100((0))Yes Allow NULL? 
32IFR_SCALEint100((0))Yes Allow NULL? 
33IFR_FAULTchar10(N' ')Yes Allow NULL? 
34IFR_ACTIONCODEchar10(N' ')Yes Allow NULL? 
35IFR_IDEMPOTENToperation is idempotentchar10CHAR(N' ')NoPRX_IDEMPOTENT Allow NULL? 
36R3_TYPEProxy Generation: Object Type in R3 (DTEL, TABL,...)nvarchar40CHAR(N' ')NoPRX_R3OBJ Allow NULL? 
37R3_NAMEProxy Generation: Name of an Object in R/3nvarchar300CHAR(N' ')NoPRX_R3NAME Allow NULL? 
38R3_TEXTProxy Generation: Short Text of an Object in SAP Systemnvarchar600CHAR(N' ')NoPRX_R3TEXT Allow NULL? 
39R3_DATATYPData Type in ABAP Dictionarynvarchar40CHAR(N' ')NoDATATYPE_D Allow NULL? 
40R3_LENGTHLength (No. of Characters)nvarchar60NUMC(N'000000')NoDDLENG Allow NULL? 
41R3_DECIMALNumber of Decimal Placesnvarchar60NUMC(N'000000')NoDECIMALS Allow NULL? 
42R3_REFTOchar10(N' ')Yes Allow NULL? 
43R3_DTREFProxy Generation: Name of an Object in R/3nvarchar300CHAR(N' ')NoPRX_R3NAME Allow NULL? 
44R3_INCLUDEchar10(N' ')Yes Allow NULL? 
45R3_SEQNUMProxy Generation: Sequence Number of a Structure Fieldnvarchar60NUMC(N'000000')NoPRX_SEQNUM Allow NULL? 
46R3_BOXEDboxed componentchar10CHAR(N' ')NoPRX_R3_BOXED Allow NULL? 
47CATEGORYProxy Generation: Object Type in Modelling Environmentnvarchar300CHAR(N' ')No*PRX_TYPE Allow NULL? 
48DIRECTIONProxy Generation: Interface Direction (Inbound/Outbound)char10CHAR(N' ')NoPRX_DIR Allow NULL? 
49INSTANCEchar10(N' ')Yes Allow NULL? 
50SYNCHRONProxy Generation: Communication Mode (Synchron./Asynchron.)char10CHAR(N' ')NoPRX_MODE Allow NULL? 
51KEYPARAMchar10(N' ')Yes Allow NULL? 
52PROBLEMSProxy Generation: Number of Problemsnvarchar200CHAR(N' ')NoPRX_PROBL Allow NULL? 
53WARNINGSProxy Generation: Number of Warning Messagesnvarchar200CHAR(N' ')NoPRX_WARN Allow NULL? 
54PROBL_INFnvarchar100(N' ')Yes Allow NULL? 
55FURTHERDATAProxy Generation: Further Proxy Data (XML)ntext10737418230YesPRX_FURTHER_DATA_CONTAINER
56ENUMTYPEchar10(N' ')Yes Allow NULL? 
NamePrimaryUniqueTypeColumns
SPROXDAT~0YesYesCLUSTEREDINACTIVE, OBJ_NAME2, OBJECT2, OBJ_NAME1, OBJECT1, OBJ_NAME, OBJECT
SPROXDAT~ENHNoNoNONCLUSTEREDCATEGORY, OBJ_NAME, OBJECT
SPROXDAT~ITYNoNoNONCLUSTEREDOBJECT, OBJECT1, OBJ_NAME1, IFR_TYPE
SPROXDAT~OB1NoNoNONCLUSTEREDOBJ_NAME1, OBJECT1
SPROXDAT~OB2NoNoNONCLUSTEREDOBJ_NAME2, OBJECT2
SPROXDAT~REFNoNoNONCLUSTEREDOBJECT_R, OBJ_NAME_R