CMSD_CI_HISTORY is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of CMSD_CI_HISTORY in SAP.
- Table description : Channel Inventory History Table
- Module : CRM-CHM-CIM
- Parent Module : CRM
- Package : CMS_CI
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP CMSD_CI_HISTORY Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| CLIENT | Client | MANDT | MANDT |
| BUCKET_GUID | Price bucket GUID | CMST_BUCKET_GUID | SYSUUID_C |
| HISTORY_GUID | Price bucket history GUID | CMST_HISTORY_GUID | SYSUUID_C |
| HISTORYID | Price bucket history ID | CMST_HISTORY_ID | NUMC6 |
| BUCKET_ID | Price bucket ID | CMST_BUCKET_ID | CRM_OBJECT_ID |
| RECORD_ID | Item number | CMST_ITEM_NO | CMST_ITEM_NO |
| APPLICATION | Application | CMST_APPLICATION | CMST_APPLICATION |
| XN_GUID | GUID of an Object | CMST_OBJECT_GUID | SYSUUID_C |
| XN_TYPE | Transaction Type | CMST_XNTYPE | CMST_XNTYPE |
| XN_DATE | Transaction effective date | CMST_XN_DATE | SYDATS |
| STEXT | Short text for History modification | CMST_STEXT | CMST_STEXT |
| LTEXT | Long text for History modification | CMST_LTEXT | CMST_LTEXT |
| .INCLUDE | Channel Inventory Price Structure - Old Price | ||
| O_COND_RATE | Old price protectable price | CMST_OLD_COND_RATE | WERTV8 |
| O_CURRENCY | Old price protectable price currency | CMST_OLD_COND_CURR | WAERS |
| O_COND_PRC_UNIT | Unit of measure for old price protectable price | CMST_OLD_COND_PRICING_UNIT | CMST_COND_PRICING_UNIT |
| O_COND_UOM | Old price protectable price pricing unit of measure | CMST_OLD_COND_UOM | MEINS |
| O_NUMER | Numerator for converting old price protectable price | CMST_OLD_COND_NUMERATOR | UMBSZ |
| O_DENOM | Denominator for converting old price protectable price | CMST_OLD_COND_DENOMINATOR | UMBSN |
| .INCLUDE | Channel Inventory Price Structure - New Price | ||
| N_COND_RATE | New price protectable price | CMST_NEW_COND_RATE | WERTV8 |
| N_CURRENCY | New price protectable price currency | CMST_NEW_COND_CURR | WAERS |
| N_COND_PRC_UNIT | Unit of measure for new price protectable price | CMST_NEW_COND_PRICING_UNIT | CMST_COND_PRICING_UNIT |
| N_COND_UOM | New price protectable price pricing unit of measure | CMST_NEW_COND_UOM | MEINS |
| N_NUMER | Numerator for converting new price protectable price | CMST_NEW_COND_NUMERATOR | UMBSZ |
| N_DENOM | Denominator for converting new price protectable price | CMST_NEW_COND_DENOMINATOR | UMBSN |
| .INCLUDE | Channel inventory Old COGS pricing structure | ||
| O_COGS_RATE | Cogs Price | CMST_COGS_PRICE_PRIC | WERTV8 |
| O_COGS_CURRENCY | Cogs Price Currency | CMST_COGS_CURR_PRIC | WAERS |
| O_COGS_PRC_UNIT | Cogs Price Price Unit | CMST_COGS_PRCUNIT_PRIC | CMST_COND_PRICING_UNIT |
| O_COGS_UOM | Cogs Price UoM | CMST_COGS_PUOM_PRIC | MEINS |
| O_COGS_NUMER | Cogs Price Prc. Numerator | CMST_COGS_PRCNUM_PRIC | CMST_PRC_NUM |
| O_COGS_DENOM | Cogs Price Prc. Denominator | CMST_COGS_PRCDEN_PRIC | CMST_PRC_DEN |
| .INCLUDE | Channel inventory New COGS pricing structure | ||
| N_COGS_RATE | Cogs Price | CMST_COGS_PRICE_PRIC | WERTV8 |
| N_COGS_CURRENCY | Cogs Price Currency | CMST_COGS_CURR_PRIC | WAERS |
| N_COGS_PRC_UNIT | Cogs Price Price Unit | CMST_COGS_PRCUNIT_PRIC | CMST_COND_PRICING_UNIT |
| N_COGS_UOM | Cogs Price UoM | CMST_COGS_PUOM_PRIC | MEINS |
| N_COGS_NUMER | Cogs Price Prc. Numerator | CMST_COGS_PRCNUM_PRIC | CMST_PRC_NUM |
| N_COGS_DENOM | Cogs Price Prc. Denominator | CMST_COGS_PRCDEN_PRIC | CMST_PRC_DEN |
| COND_RATE | Price protectable price condition rate | CMST_PRIC_RATE | WERTV8 |
| COND_CURRENCY | Currency | CMST_COND_CURR | WAERS |
| COGS_RATE | Cogs Price | CMST_COGS_PRICE_PRIC | WERTV8 |
| COGS_CURRENCY | Cogs Price Currency | CMST_COGS_CURR_PRIC | WAERS |
| EFFT_QTY | Available quantity | CMST_AVBL_QTY | MENG13 |
| .INCLUDE | Channel Inventory Transaction Quantity Structure | ||
| XN_QTY | Transaction quantity | CMST_XN_QUANTITY | MENGV15_3 |
| XN_QTY_UNIT | Transaction quantity unit of measure | CMST_XN_QUANTITY_UNIT | MEINS |
| .INCLUDE | Channel inventory admin stucture | ||
| .INCLUDE | Time and User of Last Transaction Processing | ||
| CREATED_AT | Created date | CMST_CREATED_DT | SYDATS |
| CREATED_TM | Time | CMST_TIME | SYTIME |
| CREATED_BY | User that created the transaction | CMST_CREATED_BY | UNAME |
| CHANGED_AT | Date of last change | CMST_CHANGED_DT | SYDATS |
| CHANGED_TM | Time | CMST_TIME | SYTIME |
| CHANGED_BY | Transaction last changed by | CMST_CHANGED_BY | UNAME |
| LOGHANDLE | Application log handle | CMST_LOGHANDLE | SYSUUID_22 |
| ARCHIVE_FLAG | Indicator whether the business transaction can be archived | CMST_ARCHIVING_FLAG | CRM_BOOLEAN |
| EXP_DATE | Expected delivery date | CMST_EXP_DATE | SYDATS |
| .INCLUDE | RO Hitech : Reason Code | ||
| REASON | Order reason (reason for the business transaction) | AUGRU | AUGRU |
| CANCEL_IND | Logical variable | CMST_BOOLEAN | CMST_BOOLEAN |
| .INCLUDE | EEW Include | ||
| HISTORY_DUMMY | Dummy function in length 1 | DUMMY | DUMMY |
| .INCLUDE | |||
| .INCLUDE | CI Due List | ||
| DLI_GUID | GUID of a Billing Due List (BDL) Item | BEA_DLI_GUID | SYSUUID |
| FISPRD_ENDDATE | CI Fiscal Period End Date | CMS_FISPRD_ENDDATE | DATS |
| C_DLI_GUID | GUID of a Billing Due List (BDL) Item | BEA_DLI_GUID | SYSUUID |
| C_FISPRD_ENDDATE | CI Fiscal Period End Date | CMS_FISPRD_ENDDATE | DATS |
CMSD_CI_HISTORY related tables
| Table | Note |
|---|---|
| CMSD_CI_HISTORY | Channel Inventory History Table |
| CMSC_CI_DTGRP_T | Text table for Channel inventory date group |
| CMSC_CI_XNGRP_T | Text table for Channel inventory transaction group |
| CMSD_CI_ANALYSIS | Channel inventory analysis table |
| CMSD_CI_HEADER | Channel Inventory Header Table |
| CMSD_CI_PTYP_DET | Channel Inventory price type table |
| CRMC_METHOD_CIIL | BOL Method table for Channel Inventory |
| CRMC_MODEL_CIIL | BOL Model table for Channel Inventory |
| CRMC_OBJ_CIIL | BOL Object Table for Channel Inventory |
| /SAPHT/DRMFIFINV | DRM Inventory Reconciliation FIFO Inventory |
| /SAPHT/DRMREPINV | DRM Inventory Reconciliation Reported Inventory |
| CMSC_CI_DATE_GRP | Channel inventory date group |
| CMSC_CI_RULES | Channel inventory rules |
| CMSC_CI_XN_GRP | Channel inventory transaction group |
| COMC_WEC_AGR_D | Web channel: Web Descriptions for web channel UA Roles |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP