SAP ABAP Table VDBILL_HIST (Billing History)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML-PO (Application Component) Portfolio
     ⤷ FVVD_BILL (Package) Loans - Billing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VDBILL_HIST	Table Relationship Diagram
Short Description	Billing History

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	.INCLUDE	☑				0	0	Primary Key for Billing History
3	BILL_NUMBER	☑	TB_BILL_NUMBER	T_BILL_NUMBER	CHAR	15	0	Bill Number
4	.INCLUDE	☐				0	0	Secondary Key for Billing History
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
6	RANL	☐	RANL	RANL	CHAR	13	0	Contract Number
7	.INCLUDE	☐				0	0	Billing History Details
8	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
9	BILL_CATEGORY	☐	TB_BILL_METH	T_BILL_METHOD	NUMC	2	0	Billing Category
10	TOTAL_DUE	☐	TB_BILL_DUE	WERTV7	CURR	13	2	Total Due Amount for Bill
11	MINIMUM_DUE	☐	TB_MIN_DUE	WERTV7	CURR	13	2	Minimum Due Amount for a Bill
12	PRIN_BALANCE	☐	TB_PRIN_BALANCE	WERTV7	CURR	13	2	Outstanding Net Payoff Amount
13	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
14	CREATION_DATE	☐	TB_BILL_DATE	DATS	DATS	8	0	Bill Creation Date
15	DUE_DATE	☐	DFAELLIG	DATUM	DATS	8	0	Due date/calculation date
16	BILL_FORMAT	☐	TB_BILL_FORMAT	NUMC01	NUMC	1	0	Bill Format Key	TDBILL_FORMAT
17	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
18	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
19	LOGNUMBER	☐	BALNREXT	BALNREXT	CHAR	100	0	Application Log: External ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDBILL_HIST	BILL_FORMAT	TDBILL_FORMAT	BILL_FORMAT	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	500