IBST
IB: Installation Component - Structure
IBST is an SAP database table in S/4HANA. IB: Installation Component - Structure. It contains 17 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_DgtlVehBaseInstceHier | view_entity | from | BASIC | Digital Vehicle Installed Base Hierarchy |
| P_IBaseHierarchy | view | from | BASIC |
Fields (17)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | st_recno | IB_RECNO | Record number | |||
| valfr | IB_VALFR | Valid From | ||||
| valto | IB_VALTO | Valid To | ||||
| aennr | AENNR | Change Number | ||||
| delflag | OAX | Yes/No (X/ ) | ||||
| crnam | BU_CRUSR | Created by | ||||
| crtim | ICRTS | Created On/At | ||||
| upnam | BU_CHUSR | Changed by | ||||
| uptim | IUPTS | Changed on/at | ||||
| instance | IB_INSTANCE | Component | ||||
| posno | IB_POSNO | Item | ||||
| parent | IB_PARENT | Sup. component | ||||
| root | IB_ROOT | Top component | ||||
| ibase | IB_IBASE | Installed Base | ||||
| ataut | ATATAUT | Justification | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- IB: Installation Component - Structure
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IBST (
MANDT, -- Client [MANDT]
ST_RECNO, -- Record number [IB_RECNO]
VALFR, -- Valid From [IB_VALFR]
VALTO, -- Valid To [IB_VALTO]
AENNR, -- Change Number [AENNR]
DELFLAG, -- Yes/No (X/ ) [OAX]
CRNAM, -- Created by [BU_CRUSR]
CRTIM, -- Created On/At [ICRTS]
UPNAM, -- Changed by [BU_CHUSR]
UPTIM, -- Changed on/at [IUPTS]
INSTANCE, -- Component [IB_INSTANCE]
POSNO, -- Item [IB_POSNO]
PARENT, -- Sup. component [IB_PARENT]
ROOT, -- Top component [IB_ROOT]
IBASE, -- Installed Base [IB_IBASE]
ATAUT, -- Justification [ATATAUT]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
PRIMARY KEY (MANDT, ST_RECNO)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA