SAP ABAP Table RVD_BILL_DATA (All Relevant 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
Table Category INTTAB    Structure 
Structure RVD_BILL_DATA   Table Relationship Diagram
Short Description All Relevant Billing Information    
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 NEXT_BDATE TB_BILL_NEXT_BDATE DATS DATS 8   0   Next Billing Date  
2 BILL_CATEGORY TB_BILL_METH T_BILL_METHOD NUMC 2   0   Billing Category TDBILL_CATEG
3 DESCRIPTION TB_BILL_METH_TXT CHAR_30 CHAR 30   0   Billing Category Description  
4 VDREMIT_BUS TRTY_VDREMIT_BUS   TTYP 0   0    
5 VDBILL_HIST TRTY_VDBILL_HIST   TTYP 0   0    
6 VDBILL_RES_HEAD TRTY_VDBILL_RES_HEAD   TTYP 0   0    
7 TDREMIT_ZIP TRTY_TDREMIT_ZIP   TTYP 0   0    
8 RVD_BILL_REM RVD_BILL_REM   STRU 0   0    
9 BUS020_EXT BUS020_EXT   STRU 0   0    
10 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number  
11 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number  
12 .INCLUDE       0   0   BP: Addresses (Data Fields Ext.)  
13 .INCLUDE       0   0   BP: Addresses (CHAR Data Fields External)  
14 XDFADR BU_XDFADR XFELD CHAR 1   0   Indicator: Address is standard address  
15 ADEXT BU_ADEXT BU_ADEXT CHAR 20   0   Address number in external system  
16 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses  
17 GUID SYSUUID_C SYSUUID_C CHAR 32   0   UUID in character form  
18 MOVE_ADDR BU_MOVE_ADDR AD_ADDRNUM CHAR 10   0   Number of Move Target Address for Address Moves  
19 .INCLUDE       0   0   BP: Addresses (Non-CHAR Data Fields External)  
20 DATE_FROM BU_DATE_OBSOLETE DATUM DATS 8   0   Date Obsolete  
21 ADDRESS_GUID BU_ADDRESS_GUID SYSUUID RAW 16   0   GUID of a Business Partner Address  
22 ADDR_VALID_FROM BU_ADDR_VALID_FROM TZNTSTMPS DEC 15   0   Validity Start of a Business Partner Address  
23 ADDR_VALID_TO BU_ADDR_VALID_TO TZNTSTMPS DEC 15   0   Validity End of a Business Partner Address  
24 ADDR_MOVE_DATE BU_ADDR_MOVE_DATE TZNTSTMPS DEC 15   0   Date of Move for Address Moves  
25 .INCLUDE       0   0   BP: Address Data (Read)  
26 .INCLUDE       0   0   Include structure with ADRC attributes without name fields  
27 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
28 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
29 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
30 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file  
31 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file  
32 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
33 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file  
34 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
35 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping  
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 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
39 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
40 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
41 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
42 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
43 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag  
44 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
45 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
46 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file)  
47 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...)  
48 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country  
49 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
50 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered  
51 STREET AD_STREET TEXT60 CHAR 60   0   Street  
52 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag  
53 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File  
54 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name  
55 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
56 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
57 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
58 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
59 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
60 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
61 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
62 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
63 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
64 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
65 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key  
66 LANGU SPRAS SPRAS LANG 1   0   Language Key  
67 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County)  
68 SORT1 AD_SORT1UL TEXT20 CHAR 20   0   Search Term 1  
69 SORT2 AD_SORT2UL TEXT20 CHAR 20   0   Search Term 2  
70 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
71 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key)  
72 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
73 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
74 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone  
75 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
76 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
77 REMARK AD_REMARK1 TEXT50 CHAR 50   0   Address notes  
78 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language  
79 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
80 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service  
81 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
82 COUNTY_CODE AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county  
83 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
84 TOWNSHIP_CODE AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township  
85 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
86 DEFLT_COMM AD_DFLTCMM AD_COMTYPE CHAR 3   0   Standard communication type  
87 TEL_NUMBER AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
88 TEL_EXTENS AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
89 FAX_NUMBER AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
90 FAX_EXTENS AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
91 VALID_FROM BU_VALID_FROM_DATS DATUM DATS 8   0   Valid From  
92 VALID_TO BU_VALID_TO_DATS DATUM DATS 8   0   Valid To  
93 BUS0BK BUS0BK   STRU 0   0    
94 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number  
95 BKVID BU_BKVID CHAR4 CHAR 4   0   Bank details ID  
96 .INCLUDE       0   0   BP: Bank Details (Data Fields - External)  
97 .INCLUDE       0   0   BP: Bank Details (CHAR Data Fields External)  
98 BANKS BU_BANKS LAND1 CHAR 3   0   Bank Country Key  
99 BANKL BU_BANKK CHAR15 CHAR 15   0   Bank Key  
100 BANKN BU_BANKN CHAR18 CHAR 18   0   Bank Account Number  
101 BKONT BU_BKONT CHAR2 CHAR 2   0   Bank Control Key  
102 BKREF BU_BKREF CHAR20 CHAR 20   0   Reference Details for Bank Details  
103 KOINH BU_KOINH BU_KOINH CHAR 60   0   Account Holder Name  
104 BKEXT BU_BKEXT CHAR20 CHAR 20   0   Bank details ID in external system  
105 XEZER BU_XEZER XFELD CHAR 1   0   Indicator: Collection Authorization  
106 ACCNAME BU_BANKACCNAME BU_BKCCNAME CHAR 40   0   Name of Bank Account  
107 MOVE_BKVID BU_MOVE_BKVID CHAR4 CHAR 4   0   ID of Target Details for Change of Bank Details (BP)  
108 .INCLUDE       0   0   BP: Bank Details (Non-CHAR Data Fields External)  
109 BK_VALID_FROM BU_BK_VALID_FROM TZNTSTMPS DEC 15   0   Validity Start of Business Partner Bank Details  
110 BK_VALID_TO BU_BK_VALID_TO TZNTSTMPS DEC 15   0   Validity End of Business Partner Bank Details  
111 BK_MOVE_DATE BU_BK_MOVE_DATE TZNTSTMPS DEC 15   0   Date of Change to Bank Details (BP)  
112 .INCLUDE       0   0   BP: Bank Details (External Bank Data)  
113 IBAN BU_IBAN CHAR34 CHAR 34   0   IBAN (International Bank Account Number)  
114 BANK_GUID BU_BANK_GUID UUID RAW 16   0   Bank GUID  
115 ACCOUNT_ID BU_ACCOUNT_ID CHAR35 CHAR 35   0   Bank Account Number (New)  
116 CHECK_DIGIT BU_ACCOUNT_CHECK CHAR2 CHAR 2   0   Bank Account Check Digit  
117 ACCOUNT_TYPE BU_ACCOUNT_TYPE CHAR3 CHAR 3   0   Bank Account Type  
118 TB_REMIT_CODE TB_REMIT_CODE CHAR4 CHAR 4   0   Remittance Code  
119 ADRS ADRS   STRU 0   0    
120 ANRED ANRED TEXT15 CHAR 15   0   Title  
121 NAME1 NAME1_ADRS TEXT40 CHAR 40   0   Name 1 of an address  
122 NAME2 NAME2_ADRS TEXT40 CHAR 40   0   Name 2 of an address  
123 NAME3 NAME3_ADRS TEXT40 CHAR 40   0   Name 3 of an address  
124 NAME4 NAME4_ADRS TEXT40 CHAR 40   0   Name 4 of an address  
125 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
126 PFACH PFACH_BAS PFACH CHAR 10   0   PO box  
127 PSTL2 PSTL2_BAS PSTLZ CHAR 10   0   PO Box postal code  
128 PFORT PFORT_ADRS TEXT40 CHAR 40   0   PO Box city  
129 LAND1 LAND1 LAND1 CHAR 3   0   Country Key  
130 PSTLZ PSTLZ_BAS PSTLZ CHAR 10   0   Postal code  
131 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
132 ORT02 ORT01_GP TEXT35 CHAR 35   0   City  
133 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County)  
134 SPRAS SPRAS SPRAS LANG 1   0   Language Key  
135 INLND LAND1 LAND1 CHAR 3   0   Country Key  
136 ANZZL ANZEI ANZEI DEC 2   0   Number of lines in address  
137 PRIOR PRITY_ADRS CHAR9 CHAR 9   0   Address lines priority  
138 WAREN WAREN WAREN CHAR 1   0   Delivery address ID  
139 LINE0 LINES LINES CHAR 80   0   Address line  
140 LINE1 LINES LINES CHAR 80   0   Address line  
141 LINE2 LINES LINES CHAR 80   0   Address line  
142 LINE3 LINES LINES CHAR 80   0   Address line  
143 LINE4 LINES LINES CHAR 80   0   Address line  
144 LINE5 LINES LINES CHAR 80   0   Address line  
145 LINE6 LINES LINES CHAR 80   0   Address line  
146 LINE7 LINES LINES CHAR 80   0   Address line  
147 LINE8 LINES LINES CHAR 80   0   Address line  
148 LINE9 LINES LINES CHAR 80   0   Address line  
149 LINEK LINES LINES CHAR 80   0   Address line  
150 LINED LINES LINES CHAR 80   0   Address line  
151 LINED0 LINES LINES CHAR 80   0   Address line  
152 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
153 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service  
154 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
155 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
156 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
157 VDBILL_CONTROL VDBILL_CONTROL   STRU 0   0    
158 MANDT MANDT MANDT CLNT 3   0   Client  
159 BUKRS BUKRS BUKRS CHAR 4   0   Company Code  
160 RANL RANL RANL CHAR 13   0   Contract Number  
161 PARTNER BP_PARTNR_NEW BU_PARTNER CHAR 10   0   Business Partner Number  
162 BILL_CATEGORY TB_BILL_METH T_BILL_METHOD NUMC 2   0   Billing Category  
163 CREATION_DATE TB_BILL_DATE DATS DATS 8   0   Bill Creation Date  
164 DUE_DATE DFAELL DATUM DATS 8   0   Due date  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RVD_BILL_DATA BILL_CATEGORY TDBILL_CATEG BILL_CATEGORY KEY 1 CN
History
Last changed by/on SAP  20140121 
SAP Release Created in 600