SAP VDBILL_RES_HEAD Bill Results Header Table
Overview
VDBILL_RES_HEAD is a standard SAP S/4HANA table that stores Bill Results Header data. There are total 33 fields in the VDBILL_RES_HEAD table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDBILL_RES_HEAD 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_RES_HEAD to other SAP tables and standard CDS views available based on VDBILL_RES_HEAD table in S/4HANA 2020.
Techincal Settings of VDBILL_RES_HEAD
Below are technical details of the table VDBILL_RES_HEAD
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDBILL_RES_HEAD Fields
The following table gives you an overview of the fields available in VDBILL_RES_HEAD
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| BILL_NUMBER | Bill Number | TB_BILL_NUMBER | VDBILL_HIST | CHAR | 15 |
| BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| ACCOUNT | Contract Number | RANL | CHAR | 13 | |
| BILL_CATEGORY | Billing Category | TB_BILL_METH | TDBILL_CATEG | NUMC | 2 |
| REMITTANCE_CODE | Remittance Code | TB_REMIT_CODE | CHAR | 4 | |
| BILL_DATE | Bill Creation Date | TB_BILL_DATE | DATS | 8 | |
| DUE_DATE | Due date/calculation date | DFAELLIG | DATS | 8 | |
| GRACE_DATE | Last Day of Grace Period | TB_GRACE_DATE | DATS | 8 | |
| MATURITY_DATE | End of Loan Term | DENDLFZ | DATS | 8 | |
| BILL_FORMAT | Bill Format Key | TB_BILL_FORMAT | NUMC | 1 | |
| BEGIN_BALANCE | Remaining Capital at Start of a Billing Period | TB_BEG_BALANCE | CURR | 13 | |
| END_BALANCE | Closing Balance for Billing Period | TB_END_BALANCE | CURR | 13 | |
| 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 | |
| ADB | Average Daily Balance | TB_ADB | CURR | 13 | |
| TOTAL_FEES | Charges per Billing Period | TB_TOTAL_FEES | CURR | 13 | |
| CURRENCY | Bill Currency | TB_BILL_CURR | * | CUKY | 5 |
| APR | Annual Percentage Rate (APR) | TB_APR | DEC | 10 | |
| PER_RATE | Daily Interest Rate | TB_PER_RATE | DEC | 10 | |
| NEXT_RATE | Interest Rate for Next Period | TB_NEXT_PER_RATE | DEC | 10 | |
| INT_YTD | Interest Paid - Year-to-Date | TB_INT_YTD | CURR | 13 | |
| PARTNER | Business Partner Number | BU_PARTNER | * | CHAR | 10 |
| NAME_LAST | Last name | AD_NAMELAS | CHAR | 40 | |
| NAME_FIRST | First name | AD_NAMEFIR | CHAR | 40 | |
| STREETCODE | Street Number for City/Street File | AD_STRNUM | * | CHAR | 12 |
| STREET | Street | AD_STREET | CHAR | 60 | |
| HOUSE_NUM | House Number | AD_HSNM1 | CHAR | 10 | |
| CITY | City | AD_CITY1 | CHAR | 40 | |
| REGION | Region (State Province County) | REGIO | * | CHAR | 3 |
| POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | |
| POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 |
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_RES_HEAD
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDBILL_RES_HEAD | BILL_CATEGORY | : | TDBILL_CATEG |
| VDBILL_RES_HEAD | BILL_NUMBER | 1: CN | VDBILL_HIST |