SAP Table WFMBIWS_FIELD_MAP

Field mapping between BW InfoObjects and OLTP Fields

WFMBIWS_FIELD_MAP (Field mapping between BW InfoObjects and OLTP Fields) 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 WFMBIWS_FIELD_MAP to other SAP tables.

WFMBIWS_FIELD_MAP table fields

Field Data element Checktable Datatype Length Decimals
FIELD Component name NAME_KOMP CHAR 30 0
INFOOBJECT InfoObject RSIOBJNM CHAR 30 0
DATATYPE Data type RSDATATYPE 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
DECIMALS Number of Decimal Places DECIMALS NUMC 6 0
SIGN Flag for sign in numerical fields SIGNFLAG CHAR 1 0
NULL Do not set flag
X Set flag
LOWERCASE Lowercase letters allowed/not allowed LOWERCASE CHAR 1 0
NULL Do not set flag
X Set flag
OFFSET Offset in work area OFFSET INT2 5 0
LENGTH iSeries: Table field length LENGTH INT4 10 0
CONVEXIT Conversion Routine CONVEXIT CHAR 5 0