SAP ABAP View V_TDBILL_INFO (Billing Information)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	V_TDBILL_INFO
Short Description	Billing Information
Root table	VDBILL_HIST	Billing History

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VDBILL_HIST	VDBILL_HIST
2	VDBILL_ITEMS
3	VDBILL_RES_HEAD

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VDBILL_HIST	MANDT	JL	EQ				0	0
2	VDBILL_ITEMS	MANDT	JR	EQ			AND	0	0
3	VDBILL_HIST	BILL_NUMBER	JL	EQ				0	0
4	VDBILL_ITEMS	BILL_NUMBER	JR	EQ			AND	0	0
5	VDBILL_HIST	MANDT	JL	EQ				0	0
6	VDBILL_RES_HEAD	MANDT	JR	EQ			AND	0	0
7	VDBILL_HIST	BILL_NUMBER	JL	EQ				0	0
8	VDBILL_RES_HEAD	BILL_NUMBER	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VDBILL_HIST	MANDT		☐	MANDT	☐	Client
2	BILL_NUMBER	VDBILL_HIST	BILL_NUMBER		☐	TB_BILL_NUMBER	☐	Bill Number
3	BUKRS	VDBILL_HIST	BUKRS		☐	BUKRS	☐	Company Code
4	RANL	VDBILL_HIST	RANL		☐	RANL	☐	Contract Number
5	TOTAL_DUE	VDBILL_HIST	TOTAL_DUE		☐	TB_BILL_DUE	☐	Total Due Amount for Bill
6	MINIMUM_DUE	VDBILL_HIST	MINIMUM_DUE		☐	TB_MIN_DUE	☐	Minimum Due Amount for a Bill
7	PRIN_BALANCE	VDBILL_HIST	PRIN_BALANCE		☐	TB_PRIN_BALANCE	☐	Outstanding Net Payoff Amount
8	CURRENCY	VDBILL_HIST	CURRENCY		☐	WAERS	☐	Currency Key
9	CREATION_DATE	VDBILL_HIST	CREATION_DATE		☐	TB_BILL_DATE	☐	Bill Creation Date
10	DUE_DATE	VDBILL_HIST	DUE_DATE		☐	DFAELLIG	☐	Due date/calculation date
11	BILL_FORMAT	VDBILL_HIST	BILL_FORMAT		☐	TB_BILL_FORMAT	☐	Bill Format Key
12	RERF	VDBILL_HIST	RERF		☐	RERF	☐	Entered by
13	TIMESTAMP	VDBILL_HIST	TIMESTAMP		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
14	LOGNUMBER	VDBILL_HIST	LOGNUMBER		☐	BALNREXT	☐	Application Log: External ID
15	BILL_CATEGORY	VDBILL_RES_HEAD	BILL_CATEGORY		☐	TB_BILL_METH	☐	Billing Category
16	REMITTANCE_CODE	VDBILL_RES_HEAD	REMITTANCE_CODE		☐	TB_REMIT_CODE	☐	Remittance Code
17	MICR_CODE	VDBILL_RES_HEAD	MICR_CODE		☐	TB_MICR_CODE	☐	Code for Magnetic Ink Character Recognition (MICR)
18	GRACE_DATE	VDBILL_RES_HEAD	GRACE_DATE		☐	TB_GRACE_DATE	☐	Last Day of Grace Period
19	MATURITY_DATE	VDBILL_RES_HEAD	MATURITY_DATE		☐	DENDLFZ	☐	End of Loan Term
20	BEGIN_BALANCE	VDBILL_RES_HEAD	BEGIN_BALANCE		☐	TB_BEG_BALANCE	☐	Remaining Capital at Start of a Billing Period
21	END_BALANCE	VDBILL_RES_HEAD	END_BALANCE		☐	TB_END_BALANCE	☐	Closing Balance for Billing Period
22	ADB	VDBILL_RES_HEAD	ADB		☐	TB_ADB	☐	Average Daily Balance
23	TOTAL_FEES	VDBILL_RES_HEAD	TOTAL_FEES		☐	TB_TOTAL_FEES	☐	Charges per Billing Period
24	APR	VDBILL_RES_HEAD	APR		☐	TB_APR	☐	Annual Percentage Rate (APR)
25	PER_RATE	VDBILL_RES_HEAD	PER_RATE		☐	TB_PER_RATE	☐	Daily Interest Rate
26	NEXT_RATE	VDBILL_RES_HEAD	NEXT_RATE		☐	TB_NEXT_PER_RATE	☐	Interest Rate for Next Period
27	INT_YTD	VDBILL_RES_HEAD	INT_YTD		☐	TB_INT_YTD	☐	Interest Paid - Year-to-Date
28	PARTNER	VDBILL_RES_HEAD	PARTNER		☐	BU_PARTNER	☐	Business Partner Number
29	NAME_LAST	VDBILL_RES_HEAD	NAME_LAST		☐	AD_NAMELAS	☐	Last name
30	NAME_FIRST	VDBILL_RES_HEAD	NAME_FIRST		☐	AD_NAMEFIR	☐	First name
31	STREETCODE	VDBILL_RES_HEAD	STREETCODE		☐	AD_STRNUM	☐	Street Number for City/Street File
32	STREET	VDBILL_RES_HEAD	STREET		☐	AD_STREET	☐	Street
33	HOUSE_NUM	VDBILL_RES_HEAD	HOUSE_NUM		☐	AD_HSNM1	☐	House Number
34	CITY	VDBILL_RES_HEAD	CITY		☐	AD_CITY1	☐	City
35	REGION	VDBILL_RES_HEAD	REGION		☐	REGIO	☐	Region (State, Province, County)
36	POST_CODE1	VDBILL_RES_HEAD	POST_CODE1		☐	AD_PSTCD1	☐	City postal code
37	POST_CODE2	VDBILL_RES_HEAD	POST_CODE2		☐	AD_PSTCD2	☐	PO Box postal code
38	ITEM_TYPE	VDBILL_ITEMS	ITEM_TYPE		☐	TB_BILL_ITEM_TYPE	☐	Bill Item Type
39	ITEM_NUMBER	VDBILL_ITEMS	ITEM_NUMBER		☐	TB_BILL_ITEM	☐	Bill Item Number
40	RBELKPFD	VDBILL_ITEMS	RBELKPFD		☐	RBELKPFD	☐	Document Number of Document Header (Loan)
41	RPOSNR	VDBILL_ITEMS	RPOSNR		☐	NVORGANG	☐	Activity number
42	PLAN_ACT_IND	VDBILL_ITEMS	PLAN_ACT_IND		☐	SPLANIST	☐	Plan/actual record/record to be released indicator
43	FLOW_TYPE	VDBILL_ITEMS	FLOW_TYPE		☐	SBEWART	☐	Flow Type
44	TRANS_DATE	VDBILL_ITEMS	TRANS_DATE		☐	BUDAT	☐	Posting Date in the Document
45	AMOUNT	VDBILL_ITEMS	AMOUNT		☐	BBWHR	☐	Amount in position currency

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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