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