The BAD_ASSIGNMENT table in SAP ERP or S/4HANA stores BAD – Assignment data data. There are total 9 fields in BAD_ASSIGNMENT table. The BAD – Assignment data table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BAD_ASSIGNMENT table. It is in CRM Order: BAD Objects – General Order Processing (BAD_ORDER) ABAP package and is part of the Basic Functions for Business Transactions (CRM-BTX-BF) module.
SAP BAD_ASSIGNMENT Table Fields
Following is the list of fields that are available in SAP BAD_ASSIGNMENT table. The primary key fields of the table are CLIENT (Client), GUID (GUID of a CRM Order Object).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| ORDERADM_I_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| DEMAND_KEY | Character field, length 32 | CHAR32 | CHAR (32) | |
| ASSIGNMENT_KEY | Character field, length 32 | CHAR32 | CHAR (32) | |
| RESOURCE_KEY | Character field, length 32 | CHAR32 | CHAR (32) | |
| BEG_TSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| END_TSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| STATUS_NUMBER | Object Status | CRM_J_STATUS | CHAR (5) |
