SAP table BDS_LOIO (BDS: Instances of Logical Information Objects)
SAP table BDS_LOIO has 2 primary key fields being MANDT,LOIO_ID.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | * | MANDT | |
| LOIO_ID | Logical document | CHAR | 32 | 0 | SDOK_LOID | ||
| LO_CLASS | Class of logical document | CHAR | 10 | 0 | SDOKLOCL | SDOK_LOCL | |
| MASTER_LG | Original language | LANG | 1 | 0 | T002 | SDOK_MSLAN | |
| CREA_USER | Created By | CHAR | 12 | 0 | SDOK_CRUSR | ||
| CREA_TIME | Creation Time (UTC) | NUMC | 14 | 0 | SDOK_CRTST | ||
| CHNG_USER | Last Changed By | CHAR | 12 | 0 | SDOK_CHUSR | ||
| CHNG_TIME | Time of change (UTC) | NUMC | 14 | 0 | SDOK_CHTST | ||
| PROP01 | Attribute feature (short version) | CHAR | 15 | 0 | SDOK_PRV_S | ||
| PROP02 | Attribute feature (short version) | CHAR | 15 | 0 | SDOK_PRV_S | ||
| PROP03 | Attribute feature (short version) | CHAR | 15 | 0 | SDOK_PRV_S | ||
| PROP04 | Attribute feature (short version) | CHAR | 15 | 0 | SDOK_PRV_S | ||
| PROP05 | Attribute feature (mid-length version) | CHAR | 20 | 0 | SDOK_PRV_M | ||
| PROP06 | Attribute feature (mid-length version) | CHAR | 20 | 0 | SDOK_PRV_M | ||
| PROP07 | Attribute feature (mid-length version) | CHAR | 20 | 0 | SDOK_PRV_M | ||
| PROP08 | Attribute feature (long version) | CHAR | 40 | 0 | SDOK_PRV_L | ||
| PROP09 | Attribute feature (long version) | CHAR | 40 | 0 | SDOK_PRV_L | ||
| PROP10 | Attribute feature (long version) | CHAR | 40 | 0 | SDOK_PRV_L |
BDS_LOIO foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 BDS_LOIO | LO_CLASS | SDOKLOCL | SDOK: Logical information object classes | LO_CLASS |
| 1 BDS_LOIO | MASTER_LG | T002 | Language Keys (Component BC-I18) | SPRAS |