SAP Table IBIN

IB: IBase Components - Condition

IBIN (IB: IBase Components - Condition) 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 IBIN to other SAP tables.

IBIN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
IN_RECNO IB: Unique record number IB_RECNO CHAR 22 0
VALFR IBase: Valid From IB_VALFR DEC 15 0
VALTO IBase: Valid To IB_VALTO DEC 15 0
AENNR Change Number AENNR CHAR 12 0
DELFLAG Yes/No (X/ ) OAX CHAR 1 0
X Yes
NULL No
INSTANCE IB: Component (instance) IB_INSTANCE NUMC 18 0
MLANG Language Key SPRAS T002 LANG 1 0
SORTF Sort string IB_SORTF CHAR 10 0
OBJNR IB: Component reservation IB_INSTANCEOBJECT CHAR 22 0
IBASE IBase: Number of the Installed Base/IBase IB_IBASE IBIB NUMC 18 0
AMOUNT Quantity field, length 13, with +/- sign MENGV13 QUAN 13 3
UNIT Base Unit of Measure MEINS T006 UNIT 3 0
DATUV Valid-From Date DATUV DATS 8 0
TECHS Technical status from CC_TECHV CHAR 12 0
IN_OBJNR Object number J_OBJNR CHAR 22 0
IN_GUID Globally Unique Identifier GUID RAW 16 0
OBJECTTYP IB: Object Type of Component Master Record IB_OBJTYP_INSTANCE CHAR 4 0
VOID iBase: Void Komponente IB_VOID CHAR 1 0
X Yes
NULL No
CSTATUS Status of component(Instance)from configuration perspective ATINSTATUS CHAR 2 0
CUCOCNT Internal counter CUCOZHL NUMC 4 0
EXPERT User as expert EXPRT CHAR 1 0
MAT_VARIANT Material Number MATNR CHAR 18 0
ATAUT Justification ATATAUT CHAR 1 0
KLART Class Type KLASSENART CHAR 3 0
CRNAM User who created the object BU_CRUSR CHAR 12 0
CRTIM Time (UTC) at which the object was created ICRTS DEC 15 0
UPNAM Last user to change object BU_CHUSR CHAR 12 0
UPTIM Time (UTC) at which the object was last changed IUPTS DEC 15 0

IBIN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
IBIN IBASE SYST MANDT IBIB IB: Installed Base/IBase MANDT
IBIN IBASE IBIN IBASE IBIB IB: Installed Base/IBase IBASE
IBIN MLANG IBIN MLANG T002 Language Keys (Component BC-I18) SPRAS
IBIN UNIT SYST MANDT T006 Units of Measurement MANDT
IBIN UNIT IBIN UNIT T006 Units of Measurement MSEHI