SAP VDBILL_ITEMS Billing Items Table
Overview
VDBILL_ITEMS is a standard SAP S/4HANA table that stores Billing Items data. There are total 12 fields in the VDBILL_ITEMS table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDBILL_ITEMS 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_ITEMS to other SAP tables and standard CDS views available based on VDBILL_ITEMS table in S/4HANA 2020.
Techincal Settings of VDBILL_ITEMS
Below are technical details of the table VDBILL_ITEMS
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDBILL_ITEMS Fields
The following table gives you an overview of the fields available in VDBILL_ITEMS
| 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 |
| ITEM_TYPE | Bill Item Type | TB_BILL_ITEM_TYPE | CHAR | 1 | |
| ITEM_NUMBER | Bill Item Number | TB_BILL_ITEM | NUMC | 3 | |
| RBELKPFD | Document Number of Document Header (Loan) | RBELKPFD | CHAR | 10 | |
| RPOSNR | Activity number | NVORGANG | CHAR | 3 | |
| PLAN_ACT_IND | Plan/actual record/record to be released indicator | SPLANIST | CHAR | 1 | |
| FLOW_TYPE | Flow Type | SBEWART | * | CHAR | 4 |
| TRANS_DATE | Posting Date in the Document | BUDAT | DATS | 8 | |
| DUE_DATE | Payment Date | DDISPO | DATS | 8 | |
| AMOUNT | Amount in position currency | BBWHR | CURR | 13 | |
| CURRENCY | Currency Key | WAERS | * | CUKY | 5 |
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_ITEMS
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDBILL_ITEMS | BILL_NUMBER | 1: CN | VDBILL_HIST |