SAP ABAP Table V_TDBILL_INFO (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_TDBILL_INFO   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 BILL_NUMBER TB_BILL_NUMBER T_BILL_NUMBER CHAR 15   0   Bill Number  
3 BUKRS BUKRS BUKRS CHAR 4   0   Company Code  
4 RANL RANL RANL CHAR 13   0   Contract Number  
5 TOTAL_DUE TB_BILL_DUE WERTV7 CURR 13   2   Total Due Amount for Bill  
6 MINIMUM_DUE TB_MIN_DUE WERTV7 CURR 13   2   Minimum Due Amount for a Bill  
7 PRIN_BALANCE TB_PRIN_BALANCE WERTV7 CURR 13   2   Outstanding Net Payoff Amount  
8 CURRENCY WAERS WAERS CUKY 5   0   Currency Key  
9 CREATION_DATE TB_BILL_DATE DATS DATS 8   0   Bill Creation Date  
10 DUE_DATE DFAELLIG DATUM DATS 8   0   Due date/calculation date  
11 BILL_FORMAT TB_BILL_FORMAT NUMC01 NUMC 1   0   Bill Format Key TDBILL_FORMAT
12 RERF RERF SYCHAR12 CHAR 12   0   Entered by  
13 TIMESTAMP TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
14 LOGNUMBER BALNREXT BALNREXT CHAR 100   0   Application Log: External ID  
15 BILL_CATEGORY TB_BILL_METH T_BILL_METHOD NUMC 2   0   Billing Category TDBILL_CATEG
16 REMITTANCE_CODE TB_REMIT_CODE CHAR4 CHAR 4   0   Remittance Code  
17 MICR_CODE TB_MICR_CODE   CHAR 128   0   Code for Magnetic Ink Character Recognition (MICR)  
18 GRACE_DATE TB_GRACE_DATE DATS DATS 8   0   Last Day of Grace Period  
19 MATURITY_DATE DENDLFZ DATUM DATS 8   0   End of Loan Term  
20 BEGIN_BALANCE TB_BEG_BALANCE WERTV7 CURR 13   2   Remaining Capital at Start of a Billing Period  
21 END_BALANCE TB_END_BALANCE WERTV7 CURR 13   2   Closing Balance for Billing Period  
22 ADB TB_ADB WERTV7 CURR 13   2   Average Daily Balance  
23 TOTAL_FEES TB_TOTAL_FEES WERTV7 CURR 13   2   Charges per Billing Period  
24 APR TB_APR DECV3_7 DEC 10   7   Annual Percentage Rate (APR)  
25 PER_RATE TB_PER_RATE DECV3_7 DEC 10   7   Daily Interest Rate  
26 NEXT_RATE TB_NEXT_PER_RATE DECV3_7 DEC 10   7   Interest Rate for Next Period  
27 INT_YTD TB_INT_YTD WERTV7 CURR 13   2   Interest Paid - Year-to-Date  
28 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number  
29 NAME_LAST AD_NAMELAS TEXT40 CHAR 40   0   Last name  
30 NAME_FIRST AD_NAMEFIR TEXT40 CHAR 40   0   First name  
31 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File  
32 STREET AD_STREET TEXT60 CHAR 60   0   Street  
33 HOUSE_NUM AD_HSNM1 TEXT10 CHAR 10   0   House Number  
34 CITY AD_CITY1 TEXT40 CHAR 40   0   City  
35 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County)  
36 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
37 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
38 ITEM_TYPE TB_BILL_ITEM_TYPE T_BILL_ITEM_TYPE CHAR 1   0   Bill Item Type  
39 ITEM_NUMBER TB_BILL_ITEM T_CURRENT_NR NUMC 3   0   Bill Item Number  
40 RBELKPFD RBELKPFD RBELKPFD CHAR 10   0   Document Number of Document Header (Loan)  
41 RPOSNR NVORGANG CHAR3 CHAR 3   0   Activity number  
42 PLAN_ACT_IND SPLANIST SPLANIST CHAR 1   0   Plan/actual record/record to be released indicator  
43 FLOW_TYPE SBEWART SBEWART CHAR 4   0   Flow Type  
44 TRANS_DATE BUDAT DATUM DATS 8   0   Posting Date in the Document  
45 AMOUNT BBWHR WERTV7 CURR 13   2   Amount in position currency  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_TDBILL_INFO BILL_CATEGORY TDBILL_CATEG BILL_CATEGORY    
2 V_TDBILL_INFO BILL_FORMAT TDBILL_FORMAT BILL_FORMAT KEY 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in