SAP VDBILL_ITEMS Billing Items Table data and field list

VDBILL_ITEMS is a standard SAP Table which is used to store Billing Items data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VDBILL_ITEMS table consists of various fields, each holding specific information or linking keys about Billing Items data available in SAP. These include BILL_NUMBER (Bill Number), ITEM_TYPE (Bill Item Type), ITEM_NUMBER (Bill Item Number), RBELKPFD (Document Number of Document Header (Loan))... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

VDBILL_ITEMS table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VDBILL_ITEMS table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VDBILL_ITEMS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
BILL_NUMBERBill Number TB_BILL_NUMBERCHAR15VDBILL_HISTALPHAT_BILL_NUMBER
ITEM_TYPEBill Item Type TB_BILL_ITEM_TYPECHAR1T_BILL_ITEM_TYPE
ITEM_NUMBERBill Item Number TB_BILL_ITEMNUMC3T_CURRENT_NR
RBELKPFDDocument Number of Document Header (Loan) RBELKPFDCHAR10ALPHARBELKPFD
RPOSNRActivity number NVORGANGCHAR3CHAR3
PLAN_ACT_INDPlan/actual record/record to be released indicator SPLANISTCHAR1SPLANIST
FLOW_TYPEFlow Type SBEWARTCHAR4Assigned to domainSBEWART
TRANS_DATEPosting Date in the Document BUDATDATS8DATUM
DUE_DATEPayment Date DDISPODATS8DATUM
AMOUNTAmount in position currency BBWHRCURR13(2) WERTV7
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS

Key field Non-key field



How do I retrieve data from SAP table VDBILL_ITEMS using ABAP code

The following ABAP code Example will allow you to do a basic selection on VDBILL_ITEMS to SELECT all data from the table
DATA: WA_VDBILL_ITEMS TYPE VDBILL_ITEMS.

SELECT SINGLE *
FROM VDBILL_ITEMS
INTO CORRESPONDING FIELDS OF WA_VDBILL_ITEMS
WHERE...

How to access SAP table VDBILL_ITEMS

Within an ECC or HANA version of SAP you can also view further information about VDBILL_ITEMS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).