SAP MPS_BOOK_TRADE Table in S/4 HANA - Book sales
MPS_BOOK_TRADE is a standard SAP Table which is used to store Book sales data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MPS_BOOK_TRADE table(ECC)
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Transparent table
Database Table: MPS_BOOK_TRADE
MPS_BOOK_TRADE table structure field list
Below is the full MPS_BOOK_TRADE field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
CLIENT | Client | MANDT | CLNT | 3(0) | Assigned to domain | MANDT | ||||
PRODUCT_GUID | Internal Unique ID of Product | COMT_PRODUCT_GUID | RAW | 16(0) | SYSUUID | |||||
VALID_FROM | Valid From (Time Stamp) | COMT_VALID_FROM | DEC | 15(0) | TSTPS | BCOS_TSTMP | ||||
VALID_TO | Valid To (Time Stamp) | COMT_VALID_TO | DEC | 15(0) | TSTPS | BCOS_TSTMP | ||||
UPNAME | Name of the User Who Last Changed the Set | COMT_UPNAME | CHAR | 12(0) | UNAME | |||||
HISTEX | History Exists | COMT_HISTEX | CHAR | 1(0) | COM_BOOLEAN | |||||
LOGSYS | Original System | COMT_LOGSYS | CHAR | 10(0) | ALPHA | LOGSYS | COM_LOGSYS | COM_PRODUCT_LOGSYS | LOGSYS | |
DELIVTYPE | Answer Code for Request | CRMT_MPS_DELIVTYPE | CHAR | 6(0) | CRMT_MPS_DELIVTYPE | |||||
ISBN | ISBN Number | CRMT_MPS_ISBN | CHAR | 30(0) | CRMT_MPS_ISBN |
Search for further information about these or an SAP related objects