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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||
|
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 |