SAP VDBILL_HIST Billing History Table
Overview
VDBILL_HIST is a standard SAP S/4HANA table that stores Billing History data. There are total 16 fields in the VDBILL_HIST table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDBILL_HIST belongs to Portfolio (FS-CML-PO) module and is located in the package Loans - Billing (FVVD_BILL).
In addition, following links provide an overview of foreign key relationships, if any, that link VDBILL_HIST to other SAP tables and standard CDS views available based on VDBILL_HIST table in S/4HANA 2020.
Techincal Settings of VDBILL_HIST
Below are technical details of the table VDBILL_HIST
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDBILL_HIST Fields
The following table gives you an overview of the fields available in VDBILL_HIST
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| BILL_NUMBER | Bill Number | TB_BILL_NUMBER | CHAR | 15 | |
| BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| RANL | Contract Number | RANL | CHAR | 13 | |
| PARTNER | Business Partner Number | BU_PARTNER | * | CHAR | 10 |
| BILL_CATEGORY | Billing Category | TB_BILL_METH | NUMC | 2 | |
| TOTAL_DUE | Total Due Amount for Bill | TB_BILL_DUE | CURR | 13 | |
| MINIMUM_DUE | Minimum Due Amount for a Bill | TB_MIN_DUE | CURR | 13 | |
| PRIN_BALANCE | Outstanding Net Payoff Amount | TB_PRIN_BALANCE | CURR | 13 | |
| CURRENCY | Currency Key | WAERS | * | CUKY | 5 |
| CREATION_DATE | Bill Creation Date | TB_BILL_DATE | DATS | 8 | |
| DUE_DATE | Due date/calculation date | DFAELLIG | DATS | 8 | |
| BILL_FORMAT | Bill Format Key | TB_BILL_FORMAT | TDBILL_FORMAT | NUMC | 1 |
| RERF | Entered By | RERF | CHAR | 12 | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| LOGNUMBER | Application Log: External ID | BALNREXT | CHAR | 100 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VDBILL_HIST
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDBILL_HIST | BILL_FORMAT | 1: CN | TDBILL_FORMAT |