The CMCBD_CONSUME table in SAP ERP or S/4HANA stores Cash Budgeting Consumption data. There are total 38 fields in CMCBD_CONSUME table. The Cash Budgeting Consumption 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 CMCBD_CONSUME table. It is in Service for Cash Budgeting (EA_FIN_CM_CB_PLANNING_SRV) ABAP package and is part of the Cash Budgeting China (FI-LOC-CB-CN) module.
SAP CMCBD_CONSUME Table Fields
Following is the list of fields that are available in SAP CMCBD_CONSUME table. The primary key fields of the table are MANDT (Client), GUID (16 Byte UUID in 32 Characters (Hexadecimal Encoded)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| GUID | 16 Byte UUID in 32 Characters (Hexadecimal Encoded) | SYSUUID_C32 | CHAR (32) | |
| CB_AREA | Cash Budget Area | CMCB_CB_AREA | CHAR (4) | |
| CYCLE_ID | Cycle ID | CMCB_CYCLE_ID | CHAR (10) | |
| UNIT_ID | Organizational Unit ID | CMCB_ORG_UNIT_ID | NUMC (8) | |
| LIQ_ITEM | Cash Budgeting Liquidity item | CMCB_LIQ_ITEM | CHAR (16) | |
| BUKRS | Company Code | BUKRS | CHAR (4) | |
| FIS_YEAR | Fiscal Year | GJAHR | NUMC (4) | |
| DOC_NO | Accounting Document Number | BELNR_D | CHAR (10) | |
| ITEM_NO | Number of Line Item Within Accounting Document | BUZEI | NUMC (3) | |
| ACC_NO | G/L Account Number | SAKNR | CHAR (10) | |
| ACC_TYPE | Account type | KOART | CHAR (1) | |
| BUKRS_PAY | Company Code | BUKRS | CHAR (4) | |
| FIS_YEAR_PAY | Fiscal Year | GJAHR | NUMC (4) | |
| PAYMENT_DOC | Accounting Document Number | BELNR_D | CHAR (10) | |
| PAYMENT_ITEM | Number of Line Item Within Accounting Document | BUZEI | NUMC (3) | |
| AMT_USED_TRANS | Used Amount | CMCB_USED_AMT | CURR (23) | |
| AMT_USED_LOC1 | Used Amount | CMCB_USED_AMT | CURR (23) | |
| AMT_USED_LOC2 | Used Amount | CMCB_USED_AMT | CURR (23) | |
| AMT_USED_LOC3 | Used Amount | CMCB_USED_AMT | CURR (23) | |
| AMT_RESERVED_TRANS | Reserved Amount | CMCB_RESERVED_AMT | CURR (23) | |
| AMT_RESERVED_LOC1 | Reserved Amount | CMCB_RESERVED_AMT | CURR (23) | |
| AMT_RESERVED_LOC2 | Reserved Amount | CMCB_RESERVED_AMT | CURR (23) | |
| AMT_RESERVED_LOC3 | Reserved Amount | CMCB_RESERVED_AMT | CURR (23) | |
| WAERS | Currency Key | WAERS | CUKY (5) | |
| REQ_DATE | Field of type DATS | DATS | DATS (8) | |
| RECORDED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| RECORDED_BY | User Name | UNAME | CHAR (12) | |
| REVERSED | Data element for domain BOOLE: TRUE (=’X’) and FALSE (=’ ‘) | BOOLE_D | CHAR (1) | |
| SOURCE_ID | Cash budget integration source | CMCB_SOURCE_ID | CHAR (1) | |
| CB_DOC | Document Number | CMCB_DOC | CHAR (10) | |
| CB_DOC_ITEM | Document Item Number | CMCB_DOC_ITEM | NUMC (3) | |
| TEXT_30 | 30 Characters | CHAR30 | CHAR (30) | |
| VENDOR | Account Number of Vendor or Creditor | LIFNR | CHAR (10) | |
| CUSTOMER | Customer Number | KUNNR | CHAR (10) | |
| PRCTR | Profit Center | PRCTR | CHAR (10) | |
| AUFNR | Order Number | AUFNR | CHAR (12) | |
| POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR (24) |
