The BAD_PRODUCT_I table in SAP ERP or S/4HANA stores BAD – Business Transaction Item – Product data. There are total 36 fields in BAD_PRODUCT_I table. The BAD – Business Transaction Item – Product 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_PRODUCT_I 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_PRODUCT_I Table Fields
Following is the list of fields that are available in SAP BAD_PRODUCT_I 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) | |
| GROSS_WEIGHT | Gross Weight | CRMT_GROSS_WEIGHT | QUAN (15) | |
| NET_WEIGHT | Net Weight | CRMT_NET_WEIGHT | QUAN (15) | |
| WEIGHT_UNIT | Weight Unit | COMT_WEIGHT_UNIT | * | UNIT (3) |
| VOLUME | Volume Occupied by the Product per Volume Unit | CRMT_VOLUME | QUAN (15) | |
| VOLUME_UNIT | Unit for the Volume of a Product | COMT_VOLUME_UNIT | * | UNIT (3) |
| PRICE_PRODUCT | Pricing Reference Product Globally Unique Identifier | CRMT_PRICE_PRODUCT | RAW (16) | |
| PROCESS_QTY_NUM | Numerator (factor) for conversion trans. quantity in BME | CRMT_PROCESS_QTY_NUM | INT4 (10) | |
| PROCESS_QTY_DEN | Denominator (factor) for conversion trans. quantity in BME | CRMT_PROCESS_QTY_DEN | INT4 (10) | |
| EXPONENT10 | 10 Exponent for Quantity Conversion | CRMT_EXPONENT10 | INT2 (5) | |
| PROCESS_QTY_UNIT | Unit of Measure in Which the Product Is Sold | CRMT_PROCESS_QTY_UNIT | * | UNIT (3) |
| COMM_GROUP | Commission Group | CRMT_COMM_GROUP | CRMC_COMM_GRP | CHAR (2) |
| REBATE_GROUP | Volume Rebate Group | CRMT_REBATE_GROUP | CRMC_REBATEGRP | CHAR (2) |
| CASH_DISC | Specifies Whether a Cash Discount Can Be Given for the Prod. | CRMT_CASH_DISC | CHAR (1) | |
| PROD_PR_GROUP | Product Group | CRMT_PROD_PR_GROUP | CRMC_PRC_PRGRP | CHAR (2) |
| PRC_GROUP1 | Product Group 1 | CRMT_PRC_GROUP1 | CRMC_PRC_GRP1 | CHAR (3) |
| PRC_GROUP2 | Product Group 2 | CRMT_PRC_GROUP2 | CRMC_PRC_GRP2 | CHAR (3) |
| PRC_GROUP3 | Product Group 3 | CRMT_PRC_GROUP3 | CRMC_PRC_GRP3 | CHAR (3) |
| PRC_GROUP4 | Product Group 4 | CRMT_PRC_GROUP4 | CRMC_PRC_GRP4 | CHAR (3) |
| PRC_GROUP5 | Product Group 5 | CRMT_PRC_GROUP5 | CRMC_PRC_GRP5 | CHAR (3) |
| PRODUCT_SEGMENT | GUID of a Product Segment | CRMT_MKTTG_PRSEG_GUID | RAW (16) | |
| PROD_HIERARCHY | Product Category | CRMT_PROD_HIERARCHY | CHAR (20) | |
| RESID_VALUE_ST | Residual Value Strategy | CRMT_RESID_VALUE_ST | CHAR (3) | |
| BATCH_ID | Batch Number | CRMT_BATCH_ID | CHAR (10) | |
| INT_INSPECTION | Internal Quality Inspection | CRMT_INT_INSPECTION | * | CHAR (4) |
| RET_PROC_IND | Process Indicator | PROCESS_INDICATOR | CHAR (1) | |
| PLANT | Plant | WERKS_D | CHAR (4) | |
| PRODUCT_I_DUMMY | Dummy function in length 1 | DUMMY | CHAR (1) | |
| BASE_QTY_UNIT | Base Unit of Measure of Product | COMT_PRODUCT_BASE_UOM | * | UNIT (3) |
| INT_OBJ_NO_BT | Internal Object Number for Batch Properties | CRMT_INT_OBJ_NO_BT | NUMC (18) | |
| EXCH_BUSINESS | Core Entitlements | CRMT_EXCH_BUSINESS_REL | CHAR (1) | |
| IS_GIFTCARD | Logical Variable | CRMT_BOOLEAN | CHAR (1) | |
| PRICE_PRODUCT_ID | Pricing Reference Product | CRMT_PRICE_PRODUCT_ID | CHAR (40) | |
| SAVE_BATCH_PROP | Logical Variable | CRMT_BOOLEAN | CHAR (1) |
