The BAD_SALES table in SAP ERP or S/4HANA stores BAD – Sales Set data. There are total 41 fields in BAD_SALES table. The BAD – Sales Set 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_SALES 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_SALES Table Fields
Following is the list of fields that are available in SAP BAD_SALES 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_H_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| PO_NUMBER_UC | Sold-to Party’s External Reference No. (in Capital Letters) | CRMT_PO_NUMBER_UC | CHAR (35) | |
| REGION | Region (State, Province, County) | CRMT_REGION | * | CHAR (3) |
| INDUSTRY | Industry Sector | CRMT_INDUSTRY | * | CHAR (4) |
| CUST_GROUP1 | Customer Group 1 | CRMT_CUST_GROUP1 | TVV1 | CHAR (3) |
| CUST_GROUP2 | Customer Group 2 | CRMT_CUST_GROUP2 | TVV2 | CHAR (3) |
| CUST_GROUP3 | Customer Group 3 | CRMT_CUST_GROUP3 | TVV3 | CHAR (3) |
| CUST_GROUP4 | Customer Group 4 | CRMT_CUST_GROUP4 | TVV4 | CHAR (3) |
| CUST_GROUP5 | Customer Group 5 | CRMT_CUST_GROUP5 | TVV5 | CHAR (3) |
| PO_NUMBER_SOLD | Sold-To Party’s External Reference Number | CRMT_PO_NUMBER_SOLD | CHAR (35) | |
| PO_DATE_SOLD | Reference Document Date | CRMT_PO_DATE_SOLD | DATS (8) | |
| YOUR_REF_SOLD | Sold-to Party Reference | CRMT_YOUR_REFERENCE_SOLD | CHAR (12) | |
| PO_NUMBER_SHIP | Ship-To Party’s External Reference Number | CRMT_PO_NUMBER_SHIP | CHAR (35) | |
| PO_DATE_SHIP | Ship-To Party’s Reference Document Date | CRMT_PO_DATE_SHIP | DATS (8) | |
| YOUR_REF_SHIP | Ship-To Party Reference | CRMT_YOUR_REFERENCE_SHIP | CHAR (12) | |
| USAGE_TYPE | Usage Indicator | CRMT_USAGE | TVLV | CHAR (3) |
| SUBMISSION | Collective Number for Quotations | CRMT_SUBMISSION | CHAR (10) | |
| REJECTION | Cancellation Reason Code | CRMT_REJECTION_CODE | CRMC_REJECTION | CHAR (2) |
| PROBABILITY | Order Probability | CRMT_ORDER_PROBABILITY | NUMC (3) | |
| DATE_QTY_FIXED | Fixed Date and Quantity | CRMT_DATE_QTY_FIXED | CHAR (1) | |
| REQ_DLV_DATE | Requested Delivery Date Header | CRMT_REQ_DLV_DATE | DEC (15) | |
| REQ_TIMEZONE | Time Zone Requested Delivery Date Header | CRMT_REQ_DATE_TIMEZONE | * | CHAR (6) |
| RULE_REQ_DATE | Rule Reqested Delivery Date Header | CRMT_RULE_REQ_DATE | * | RAW (16) |
| ROUNDING | Round Requirement Quantity | CRMT_ROUNDING | CHAR (1) | |
| PAR_ATP_SSTOCK | Parameter-Dependent ATP Safety Stock | CRMT_PAR_ATP_SSTOCK | CHAR (1) | |
| CONF_RULE | Confirmation Rule | CRMT_CONF_RULE | CHAR (1) | |
| SUBST_EXCL | Rule Criterion 1 | CRMT_ATP_SUBST_EXCL | CRMC_SUBST_EXCL | CHAR (2) |
| SEARCH_PATTERN | Rule Criterion 2 | CRMT_SEARCH_PATTERN | CRMC_ATP_SEARCH | CHAR (10) |
| REASSIGN_ABILITY | Reassignment of Order Confirmations | CRMT_REASSIGN_ABILITY | CHAR (1) | |
| ABNORMAL_DEMAND | Abnormal Demand | CRMT_ABNORMAL_DEMAND | CHAR (1) | |
| REQ_SOLUTION | Complaint Requested Solution | CRMS4_REQ_SOLUTION | * | CHAR (4) |
| ISSUE_CAUSED_BY | Complaint Issue Caused By | CRMS4_COMP_ISS_CAU | * | CHAR (4) |
| COMPLAINT_IMPACT | Complaint Impact | CRMS4_COMP_IMPACT | * | CHAR (4) |
| COMPLAINT_REASON | Complaint Reason | CRMS4_COMP_REASON | * | CHAR (4) |
| SALES_DUMMY | Dummy function in length 1 | DUMMY | CHAR (1) | |
| NFE_REF_NUM | Text (length 35) | TEXT35 | CHAR (35) | |
| REF_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| REF_KIND | Object Type | CRMT_OBJECT_KIND | CHAR (1) | |
| RULE_REQ_DATE_T | Rule Req Delivery Date | CRMT_RULE_REQ_DATE_T | CHAR (12) |
