1. Home
  2. Resources
  3. SAP Tables
  4. SPROXDAT - Proxy Metadata (Substitution Table)

SAP Table SPROXDAT

Proxy Metadata (Substitution Table)

SPROXDAT (Proxy Metadata (Substitution Table)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SPROXDAT to other SAP tables.

SPROXDAT table fields

Field Data element Checktable Datatype Length Decimals
OBJECT Proxy Generation: Object Type in R3 (DTEL, TABL,...) PRX_R3OBJ CHAR 4 0
CLAS Class
INTF Interface
DTEL Data Element
TABL Structure
TTYP Table Type
SCON Semantic Contract
CONT Contract
CONI Contract Implementation
SCEN Integration Scenario
PAIM Importing Parameter
PAEX Exporting Parameter
METH Method
FIEL Feld
ATTR Attribute
FAUM Fault Mapping
REQM Request Mapping
RESM Response Mapping
AREQ RFC Consumer Request
ARES RFC Consumer Response
OBJ_NAME Proxy Generation: Name of an Object in R/3 PRX_R3NAME CHAR 30 0
OBJECT1 Proxy Generation: Object Type in R3 (DTEL, TABL,...) PRX_R3OBJ CHAR 4 0
CLAS Class
INTF Interface
DTEL Data Element
TABL Structure
TTYP Table Type
SCON Semantic Contract
CONT Contract
CONI Contract Implementation
SCEN Integration Scenario
PAIM Importing Parameter
PAEX Exporting Parameter
METH Method
FIEL Feld
ATTR Attribute
FAUM Fault Mapping
REQM Request Mapping
RESM Response Mapping
AREQ RFC Consumer Request
ARES RFC Consumer Response
OBJ_NAME1 Proxy Generation: Name of an Object in R/3 PRX_R3NAME CHAR 30 0
OBJECT2 Proxy Generation: Object Type in R3 (DTEL, TABL,...) PRX_R3OBJ CHAR 4 0
CLAS Class
INTF Interface
DTEL Data Element
TABL Structure
TTYP Table Type
SCON Semantic Contract
CONT Contract
CONI Contract Implementation
SCEN Integration Scenario
PAIM Importing Parameter
PAEX Exporting Parameter
METH Method
FIEL Feld
ATTR Attribute
FAUM Fault Mapping
REQM Request Mapping
RESM Response Mapping
AREQ RFC Consumer Request
ARES RFC Consumer Response
OBJ_NAME2 Proxy Generation: Name of an Object in R/3 PRX_R3NAME CHAR 30 0
INACTIVE Proxy Generation: Flag for Inactive Version PRX_INACT CHAR 1 0
X True
NULL False
OBJECT_R Proxy Generation: Object Type in R3 (DTEL, TABL,...) PRX_R3OBJ CHAR 4 0
CLAS Class
INTF Interface
DTEL Data Element
TABL Structure
TTYP Table Type
SCON Semantic Contract
CONT Contract
CONI Contract Implementation
SCEN Integration Scenario
PAIM Importing Parameter
PAEX Exporting Parameter
METH Method
FIEL Feld
ATTR Attribute
FAUM Fault Mapping
REQM Request Mapping
RESM Response Mapping
AREQ RFC Consumer Request
ARES RFC Consumer Response
OBJ_NAME_R Proxy Generation: Name of an Object in R/3 PRX_R3NAME CHAR 30 0
ID Proxy Generation: Unique ID of a Proxy Object PRX_ID STRG 0 0
IFR_TYPE Proxy Generation: WSDL Type (portType, message, and so on) PRX_WSDLTY CHAR 30 0
IFR_NAME Proxy Generation: External Name PRX_IFRNAM CHAR 120 0
IFR_TEXT Proxy Generation: Short Text of an Object in the IFR PRX_IFRTXT CHAR 100 0
IFR_LANGU Proxy Generation: Original Language PRX_LANGU CHAR 2 0
IFR_REPTERM Representation Term PRX_REPTERM CHAR 30 0
IFR_LABEL_F CHAR 40 0
IFR_LABEL_C CHAR 55 0
IFR_TEXTID CHAR 32 0
IFR_TAGTYP Proxy Generation: Tag Type (Normal, Invisible, ...) PRX_TAGTYP CHAR 1 0
NULL Normal Tag
I Invisible Tag
L Row Tag in Table
IFR_MINOCC INT4 10 0
IFR_MAXOCC INT4 10 0
IFR_OPTNL CHAR 1 0
IFR_DEFLT STRG 0 0
IFR_QUALIF CHAR 1 0
IFR_XSDTYP CHAR 30 0
IFR_LENGTH INT4 10 0
IFR_MAXLEN INT4 10 0
IFR_MINLEN INT4 10 0
IFR_NILLABLE CHAR 1 0
IFR_PATTRN CHAR 255 0
IFR_PREC INT4 10 0
IFR_SCALE INT4 10 0
IFR_FAULT CHAR 1 0
IFR_ACTIONCODE CHAR 1 0
IFR_IDEMPOTENT operation is idempotent PRX_IDEMPOTENT CHAR 1 0
X true
NULL false
R3_TYPE Proxy Generation: Object Type in R3 (DTEL, TABL,...) PRX_R3OBJ CHAR 4 0
CLAS Class
INTF Interface
DTEL Data Element
TABL Structure
TTYP Table Type
SCON Semantic Contract
CONT Contract
CONI Contract Implementation
SCEN Integration Scenario
PAIM Importing Parameter
PAEX Exporting Parameter
METH Method
FIEL Feld
ATTR Attribute
FAUM Fault Mapping
REQM Request Mapping
RESM Response Mapping
AREQ RFC Consumer Request
ARES RFC Consumer Response
R3_NAME Proxy Generation: Name of an Object in R/3 PRX_R3NAME CHAR 30 0
R3_TEXT Proxy Generation: Short Text of an Object in SAP System PRX_R3TEXT CHAR 60 0
R3_DATATYP Data Type in ABAP Dictionary DATATYPE_D CHAR 4 0
ACCP Posting period YYYYMM
CHAR Character String
CLNT Client
CUKY Currency key, referenced by CURR fields
CURR Currency field, stored as DEC
D16D Decimal Floating Point, 16 Digits, DEC on Database
D16R Decimal Floating Point, 16 Digits, RAW on Database
D16S Decimal Floating Point. 16 Digits, with Scale Field
D34D Decimal Floating Point, 34 Digits, DEC on Database
D34R Decimal Floating Point, 34 Digits, RAW on Database
D34S Decimal Floating Point, 34 Digits, with Scale Field
DATS Date field (YYYYMMDD) stored as char(8)
DEC Counter or amount field with comma and sign
FLTP Floating point number, accurate to 8 bytes
INT1 1-byte integer, integer number <= 255
INT2 2-byte integer, only for length field before LCHR or LRAW
INT4 4-byte integer, integer number with sign
LANG Language key
LCHR Long character string, requires preceding INT2 field
LRAW Long byte string, requires preceding INT2 field
NUMC Character string with only digits
PREC Obsolete data type, do not use
QUAN Quantity field, points to a unit field with format UNIT
RAW Uninterpreted sequence of bytes
RSTR Byte String of Variable Length
SSTR Short Character String of Variable Length
STRG Character String of Variable Length
TIMS Time field (hhmmss), stored as char(6)
UNIT Unit key for QUAN fields
VARC Long character string, no longer supported from Rel. 3.0
R3_LENGTH Length (No. of Characters) DDLENG NUMC 6 0
R3_DECIMAL Number of Decimal Places DECIMALS NUMC 6 0
R3_REFTO CHAR 1 0
R3_DTREF Proxy Generation: Name of an Object in R/3 PRX_R3NAME CHAR 30 0
R3_INCLUDE CHAR 1 0
R3_SEQNUM Proxy Generation: Sequence Number of a Structure Field PRX_SEQNUM NUMC 6 0
R3_BOXED boxed component PRX_R3_BOXED CHAR 1 0
NULL not boxed component
X boxed component
CATEGORY Proxy Generation: Object Type in Modelling Environment PRX_TYPE CHAR 30 0
DIRECTION Proxy Generation: Interface Direction (Inbound/Outbound) PRX_DIR CHAR 1 0
I Inbound
O Outbound
INSTANCE CHAR 1 0
SYNCHRON Proxy Generation: Communication Mode (Synchron./Asynchron.) PRX_MODE CHAR 1 0
X Synchronous
NULL Asynchronous
KEYPARAM CHAR 1 0
PROBLEMS Proxy Generation: Number of Problems PRX_PROBL CHAR 20 0
WARNINGS Proxy Generation: Number of Warning Messages PRX_WARN CHAR 20 0
PROBL_INF CHAR 10 0
FURTHERDATA Proxy Generation: Further Proxy Data (XML) PRX_FURTHER_DATA_CONTAINER STRG 0 0
ENUMTYPE CHAR 1 0