SAP ABAP Table FIWTIE_S_XREGUO (Structure for Extract from the payment records)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBZ (Package) Payments
Basic Data
Table Category INTTAB    Structure 
Structure FIWTIE_S_XREGUO   Table Relationship Diagram
Short Description Structure for Extract from the payment records    
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 .INCLUDE       0   0   Extract from the payment records for online list  
2 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
3 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number *
4 EMPFG EMPFG EMPFG CHAR 16   0   Payee code  
5 VBLNR VBLNR BELNR CHAR 10   0   Document Number of the Payment Document  
6 AVISG AVISG AVISG CHAR 1   0   Reason for Printing Payment Advice  
7 WAERS WAERS WAERS CUKY 5   0   Currency Key *
8 SRTGB GSBER GSBER CHAR 4   0   Business Area *
9 SRTBP BUPLA J_1BBRANCH CHAR 4   0   Business Place *
10 NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
11 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
12 LAND1 LAND1 LAND1 CHAR 3   0   Country Key *
13 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) *
14 ZNME1 DZNME1 TEXT35 CHAR 35   0   Name of the payee  
15 ZORT1 DZORT1 TEXT35 CHAR 35   0   City of the payee  
16 ZLAND DZLAND LAND1 CHAR 3   0   Country Key *
17 ZBNKS DZBNKS LAND1 CHAR 3   0   Country Key *
18 ZBNKN DZBNKN BANKN CHAR 18   0   Bank account number of the payee  
19 ZBNKL DZBNKL BANKL CHAR 15   0   Bank number of the payee's bank  
20 ZBKON DZBKON BKONT CHAR 2   0   Bank Control Key of the Payee's Bank  
21 ZBVTY DZBVTY BVTYP CHAR 4   0   Bank Data Indicator for the Payee  
22 ZSWIF SWIFT SWIFT CHAR 11   0   SWIFT/BIC for International Payments  
23 RZAWE RZAWE ZLSCH CHAR 1   0   Payment Method for This Payment *
24 HKTID HKTID HKTID CHAR 5   0   ID for account details *
25 HBKID HBKID HBKID CHAR 5   0   Short key for a house bank *
26 HKTIW HKTIW HKTID CHAR 5   0   Short Key of the Account Data for the Bill of Exchange *
27 HBKIW HBKIW HBKID CHAR 5   0   Short Key of the House Bank for Bill/Exch.for Check/Bill/Ex. *
28 BVTYP BVTYP BVTYP CHAR 4   0   Partner bank type  
29 VALUT VALUT DATUM DATS 8   0   Fixed Value Date  
30 WDATE WDATE DATUM DATS 8   0   Bill of Exchange Issue Date  
31 ANFAE ANFAE DATUM DATS 8   0   Bill of Exchange Payment Request Due Date  
32 WEFAE WEFAE DATUM DATS 8   0   Bill of Exchange Due Date  
33 WEVWV WEVWV WEVWV CHAR 1   0   Planned usage of the bill of exchange  
34 RBETR RBETR WRTV7 CURR 13   2   Amount in Local Currency  
35 RSKON RSKON WRTV7 CURR 13   2   Total Cash Discount for the Payment Trans. (Local Currency)  
36 SKVHW SKVHW WERT7 CURR 13   2   Lost Cash Discount in Local Currency  
37 RWBTR RWBTR WRTV7 CURR 13   2   Amount Paid in the Payment Currency  
38 RWSKT RWSKT WRTV7 CURR 13   2   Total Cash Discount for the Pmnt Transactn in Pmnt Currency  
39 SKVFW SKVFW WERT7 CURR 13   2   Lost Cash Discount in Payment Currency  
40 DSKVH DSKVH WERT7 CURR 13   2   Impending Lost Cash Discount in Local Currency  
41 RPOST RPOST PACK3 DEC 5   0   Number of Items Paid  
42 RTEXT RTEXT_D PACK3 DEC 5   0   Number of Text Lines for the Items Paid  
43 RUMSK RUMSK UMSKZ CHAR 1   0   Special G/L Indicator of the Payment Transaction *
44 RZUMS RZUMS UMSKZ CHAR 1   0   Target Special G/L Indicator of the Payment Transaction *
45 WEHMX WEHMX WERT7 CURR 13   2   Maximum Amount per Bill of Exchange in Local Currency  
46 WEFMX WEFMX WERT7 CURR 13   2   Maximum Amount per Bill of Exchange in Payment Currency  
47 WEHRS WEHRS WERT7 CURR 13   2   Remaining Amount in Local Crcy for Last Bill of Exchange  
48 WEFRS WEFRS WERT7 CURR 13   2   Remaining Amount in Payment Crcy for Last Bill of Exchange  
49 WEAMX WEAMX PACK2 DEC 3   0   Number of Bills of Exchange with Maximum Amount  
50 RSPE1 SPES1 WERT6 CURR 11   2   Form Charges  
51 RSPE2 SPES2 WERT6 CURR 11   2   Form Charges  
52 RSPM1 SPEM1 WERT6 CURR 11   2   Form Charges for Bill of Exchange with Maximum Amount  
53 RSPM2 SPEM2 WERT6 CURR 11   2   Form Charges for Bill of Exchange with Maximum Amount  
54 BUSAB BUSAB BUSAB CHAR 2   0   Accounting clerk *
55 INSEL INSEL NUM01 NUMC 1   0   Indicator: Partial Selection of Postings  
56 ORISO ORISO PACK4 DEC 7   0   Index Number for Original Sorting  
57 TYPAE TYPAE CHAR1 CHAR 1   0   Type of Change  
58 UBHKT UBHKT SAKNR CHAR 10   0   G/L Account Number for Our Bank Account / Bank Sub-Account *
59 UBKNT UBKNT BANKN CHAR 18   0   Our account number at the bank  
60 UBKON UBKON BKONT CHAR 2   0   Bank control key at our bank  
61 UBNKS BANKS LAND1 CHAR 3   0   Bank country key *
62 UBNKL UBNKL BANKL CHAR 15   0   Bank number of our bank  
63 PAYGR PAYGR CHAR20 CHAR 20   0   Grouping Field for Automatic Payments  
64 UBNKY UBNKY BANKK CHAR 15   0   Bank key of our bank  
65 ZBNKY DZBNKY BANKK CHAR 15   0   Bank key of the payee's bank  
66 KURSF KURSF KURSF DEC 9   5   Exchange rate  
67 RBET2 RBET2 WRTV7 CURR 13   2   Amount Paid in Second Local Currency  
68 RBET3 RBET3 WRTV7 CURR 13   2   Amount Paid in Third Local Currency  
69 RSKO2 RSKO2 WRTV7 CURR 13   2   Payment Transaction Total Discount in Second Local Currency  
70 RSKO3 RSKO3 WRTV7 CURR 13   2   Payment Transaction Total Discount in Third Local Currency  
71 KURS2 KURS2 KURSF DEC 9   5   Exchange Rate for the Second Local Currency  
72 KURS3 KURS3 KURSF DEC 9   5   Exchange Rate for the Third Local Currency  
73 BKREF BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
74 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement *
75 ZPFOR PFORT_Z TEXT35 CHAR 35   0   City of payee's PO box  
76 AUSFD AUSFD DATUM DATS 8   0   Due date of the paid items  
77 AUGDT AUGDT DATUM DATS 8   0   Clearing Date  
78 DTAWS DTAWS DTAWS CHAR 2   0   Instruction key for data medium exchange *
79 EDIAV EDIAV EDIST CHAR 1   0   EDI Payment Advice Status  
80 EDIBN EDIBN EDIST CHAR 1   0   EDI Payment Order Status  
81 KOINH KOINH_FI KOINH CHAR 60   0   Account Holder Name  
82 DTWS1 DTAT16 DTWSX NUMC 2   0   Instruction key 1 *
83 DTWS2 DTAT17 DTWSX NUMC 2   0   Instruction key 2 *
84 DTWS3 DTAT18 DTWSX NUMC 2   0   Instruction key 3 *
85 DTWS4 DTAT19 DTWSX NUMC 2   0   Instruction key 4 *
86 KIDNO KIDNO CHAR30 CHAR 30   0   Payment Reference  
87 PYORD PYORD PYORD CHAR 10   0   Payment Order  
88 VERTN RANL RANL CHAR 13   0   Contract Number  
89 VBEWA SBEWART SBEWART CHAR 4   0   Flow Type *
90 BTYP1 BNTYP BNTYP CHAR 1   0   Type of bank in a bank chain (correspondent, intermediary)  
91 BNKS1 BANKS LAND1 CHAR 3   0   Bank country key *
92 BNKL1 BANKK BANKK CHAR 15   0   Bank Keys  
93 BNKN1 BANKN BANKN CHAR 18   0   Bank account number  
94 BKON1 BKONT BKONT CHAR 2   0   Bank Control Key  
95 BTYP2 BNTYP BNTYP CHAR 1   0   Type of bank in a bank chain (correspondent, intermediary)  
96 BNKS2 BANKS LAND1 CHAR 3   0   Bank country key *
97 BNKL2 BANKK BANKK CHAR 15   0   Bank Keys  
98 BNKN2 BANKN BANKN CHAR 18   0   Bank account number  
99 BKON2 BKONT BKONT CHAR 2   0   Bank Control Key  
100 BTYP3 BNTYP BNTYP CHAR 1   0   Type of bank in a bank chain (correspondent, intermediary)  
101 BNKS3 BANKS LAND1 CHAR 3   0   Bank country key *
102 BNKL3 BANKK BANKK CHAR 15   0   Bank Keys  
103 BNKN3 BANKN BANKN CHAR 18   0   Bank account number  
104 BKON3 BKONT BKONT CHAR 2   0   Bank Control Key  
105 SAKNR SAKNR SAKNR CHAR 10   0   G/L Account Number *
106 XURGE PRQ_XURGE X CHAR 1   0   Indicator: Extremely Urgent Payment  
107 ZIBAN DZIBAN IBAN CHAR 34   0   IBAN of the Payee  
108 MGUID SEPA_MGUID   RAW 16   0   SEPA Mandate: GUID of Mandate  
109 MNDID SEPA_MNDID ID035 CHAR 35   0   Unique Referene to Mandate per Payment Recipient  
110 SEQ_TYPE SEPA_SEQ_TYPE SEPA_SEQ_TYPE CHAR 4   0   SEPA: Sequence Type  
111 INST_CODE FSEPA_INST_CODE FSEPA_INST_CODE CHAR 4   0   Local Instrument Code (Direct Debit Type)  
112 XINVE XINVE XFELD CHAR 1   0   Indicator: Capital Goods Affected?  
113 XKDFB XKDFB XFELD CHAR 1   0   Indicator: Are the Exchange Rate Differences to be Posted?  
114 D_BUSAB BUSAB BUSAB CHAR 2   0   Accounting clerk *
115 ZBNKN_L BANKN35 BANKN35 CHAR 35   0   Bank account number  
116 BKRF1 BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
117 BNKN1_L BANKN35 BANKN35 CHAR 35   0   Bank account number  
118 BKRF2 BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
119 BNKN2_L BANKN35 BANKN35 CHAR 35   0   Bank account number  
120 BKRF3 BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
121 BNKN3_L BANKN35 BANKN35 CHAR 35   0   Bank account number  
122 ADRNR AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
123 ZADNR ADRNR_Z AD_ADDRNUM CHAR 10   0   Payee's Address Number *
124 RPOST_L     DEC 7   0    
History
Last changed by/on SAP  20131127 
SAP Release Created in