The DFKKBIXREVRECS12 table in SAP ERP or S/4HANA stores Source Items for Revenue Accrual Item data. There are total 32 fields in DFKKBIXREVRECS12 table. The Source Items for Revenue Accrual Item table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DFKKBIXREVRECS12 table. It is in Billing (FKKBIX) ABAP package and is part of the Convergent Invoicing (FI-CA-INV) module.
SAP DFKKBIXREVRECS12 Table Fields
Following is the list of fields that are available in SAP DFKKBIXREVRECS12 table. The primary key fields of Source Items for Revenue Accrual Item table in SAP are MANDT (Client), REVREC_ACCKEY (Accrual/Deferral Accounting Key), REVREC_UUID (UUID in X form (binary)), REVRECS_UUID (UUID in X form (binary)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| REVREC_ACCKEY | Accrual/Deferral Accounting Key | REVREC_ACCKEY_KK | CHAR (12) | |
| REVREC_UUID | UUID in X form (binary) | SYSUUID_X | RAW (16) | |
| REVRECS_UUID | UUID in X form (binary) | SYSUUID_X | RAW (16) | |
| BITDATAPACKID | ID of a data package of billable items | BIT_DATAPACKID_KK | RAW (16) | |
| ITEMTYPE | Type of Accrual/Deferral Item | REVREC_ITEMTYPE_KK | CHAR (2) | |
| REVREC_PDATE | Earliest Accrual/Deferral Item Posting Date | REVREC_PDATE_KK | DATS (8) | |
| CRDATE | Created On | CRDATE | DATS (8) | |
| CRTIME | Time at Which the Object Was Created | CRTIME_KK | TIMS (6) | |
| BITCAT | Billable Item Class | BITCAT_KK | CHAR (4) | |
| SUBPROCESS | Subprocess of Billing | SUB_PROCESS_KK | * | CHAR (4) |
| VKONT | Contract Account Number | VKONT_KK | CHAR (12) | |
| GPART | Business Partner Number | GPART_KK | * | CHAR (10) |
| BITSTATUS | Status of Billable Item | BITSTATUS_KK | CHAR (1) | |
| SRCTATYPE | Source Transaction Type | SRCTATYPE_KK | * | CHAR (5) |
| SRCTAID | Source Transaction ID | SRCTAID_KK | CHAR (22) | |
| BITPACKUUID | GUID of Package of Billable Items | BITPACKUUID_KK | RAW (16) | |
| BITPACKCNO | Sequence Number of Billable Item in Package | BITPACKCNO_KK | NUMC (8) | |
| BILLCRDATE | Date on Which Billing Document Was Created | BILLCRDATE_KK | DATS (8) | |
| BILLDOCNO | Number of Billing Document | BILLDOCNO_KK | NUMC (12) | |
| INVDOCNO | Number of Invoicing Document | INVDOCNO_KK | NUMC (12) | |
| BITCRDATE | Created On | BITCRDATE_KK | DATS (8) | |
| BITDATE | Date of Origin of Billable Item | BITDATE_KK | DATS (8) | |
| BIT_AMOUNT | Amount of Billable Item | BIT_AMOUNT8_KK | CURR (15) | |
| BIT_CURR | Currency of Billable Item | BIT_CURR_KK | * | CUKY (5) |
| BIT_QUANTITY | Billing Quantity of Billable Item | BIT_QUANTITY_KK | QUAN (31) | |
| BIT_QTY_UNIT | Unit for the Billing Quantity of Billable Items | BIT_QTY_UNIT_KK | * | UNIT (3) |
| REVREC_AMOUNT | Acc./Def. Amount | REVREC_AMOUNT_KK | CURR (15) | |
| REVREC_CURR | Currency of Accrual/Deferral Amount | REVREC_CURR_KK | * | CUKY (5) |
| REVREC_QTY_UNIT | Unit of Accrued/Deferred Quantity | REVREC_QTY_UNIT_KK | * | UNIT (3) |
| REVREC_QUANTITY | Accrual/Deferral Quantity | REVREC_QUANTITY_KK | QUAN (31) | |
| BIT_NUMBER | Number of Billable Items | BIT_NUMBER_KK | INT4 (10) |
