REGUO SAP (Extract from the payment records for online list) Structure details

Dictionary Type: Structure
Description: Extract from the payment records for online list




ABAP Code to SELECT data from REGUO
Related tables to REGUO
Access table REGUO




Structure field list including key, data, relationships and ABAP select examples

REGUO is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Extract from the payment records for online list" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_REGUO TYPE REGUO.

The REGUO table consists of various fields, each holding specific information or linking keys about Extract from the payment records for online list data available in SAP. These include KUNNR (Customer Numbers), EMPFG (Payee code), VBLNR (Document Number of the Payment Document), AVISG (Reason for Printing Payment Advice).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP REGUO structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
EMPFGPayee code EMPFGCHAR16EMPFG
VBLNRDocument Number of the Payment Document VBLNRCHAR10ALPHABELNR
AVISGReason for Printing Payment Advice AVISGCHAR1AVISG
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
SRTGBBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
SRTBPBusiness Place BUPLACHAR4Assigned to domainJ_1BBRANCH
NAME1Name 1 NAME1_GPCHAR35NAME
ORT01City ORT01_GPCHAR35TEXT35
LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
ZNME1Name of the payee DZNME1CHAR35TEXT35
ZORT1City of the payee DZORT1CHAR35TEXT35
ZLANDCountry Key DZLANDCHAR3Assigned to domainLAND1LND
ZBNKSCountry Key DZBNKSCHAR3Assigned to domainLAND1LND
ZBNKNBank account number of the payee DZBNKNCHAR18BANKN
ZBNKLBank number of the payee's bank DZBNKLCHAR15BANKL
ZBKONBank Control Key of the Payee's Bank DZBKONCHAR2BKONT
ZBVTYBank Data Indicator for the Payee DZBVTYCHAR4BVTYP
ZSWIFSWIFT/BIC for International Payments SWIFTCHAR11SWIFT
RZAWEPayment Method for This Payment RZAWECHAR1Assigned to domainZLSCH
HKTIDID for account details HKTIDCHAR5Assigned to domainHKTID
HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
HKTIWShort Key of the Account Data for the Bill of Exchange HKTIWCHAR5Assigned to domainHKTID
HBKIWShort Key of the House Bank for Bill/Exch.for Check/Bill/Ex. HBKIWCHAR5Assigned to domainHBKID
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
VALUTValue date VALUTDATS8DATUM
WDATEBill of Exchange Issue Date WDATEDATS8DATUM
ANFAEBill of Exchange Payment Request Due Date ANFAEDATS8DATUM
WEFAEBill of Exchange Due Date WEFAEDATS8DATUM
WEVWVPlanned usage of the bill of exchange WEVWVCHAR1WEVWV
RBETRAmount in Local Currency RBETRCURR13(2) WRTV7
RSKONTotal Cash Discount for the Payment Trans. (Local Currency) RSKONCURR13(2) WRTV7
SKVHWLost Cash Discount in Local Currency SKVHWCURR13(2) WERT7
RWBTRAmount Paid in the Payment Currency RWBTRCURR13(2) WRTV7
RWSKTTotal Cash Discount for the Pmnt Transactn in Pmnt Currency RWSKTCURR13(2) WRTV7
SKVFWLost Cash Discount in Payment Currency SKVFWCURR13(2) WERT7
DSKVHImpending Lost Cash Discount in Local Currency DSKVHCURR13(2) WERT7
RPOSTNumber of Items Paid RPOSTDEC5PACK3
RTEXTNumber of Text Lines for the Items Paid RTEXT_DDEC5PACK3
RUMSKSpecial G/L Indicator of the Payment Transaction RUMSKCHAR1Assigned to domainUMSKZ
RZUMSTarget Special G/L Indicator of the Payment Transaction RZUMSCHAR1Assigned to domainUMSKZ
WEHMXMaximum Amount per Bill of Exchange in Local Currency WEHMXCURR13(2) WERT7
WEFMXMaximum Amount per Bill of Exchange in Payment Currency WEFMXCURR13(2) WERT7
WEHRSRemaining Amount in Local Crcy for Last Bill of Exchange WEHRSCURR13(2) WERT7
WEFRSRemaining Amount in Payment Crcy for Last Bill of Exchange WEFRSCURR13(2) WERT7
WEAMXNumber of Bills of Exchange with Maximum Amount WEAMXDEC3PACK2
RSPE1Form Charges SPES1CURR11(2) WERT6
RSPE2Form Charges SPES2CURR11(2) WERT6
RSPM1Form Charges for Bill of Exchange with Maximum Amount SPEM1CURR11(2) WERT6
RSPM2Form Charges for Bill of Exchange with Maximum Amount SPEM2CURR11(2) WERT6
BUSABAccounting clerk BUSABCHAR2Assigned to domainBUSAB
INSELIndicator: Partial Selection of Postings INSELNUMC1NUM01
ORISOIndex Number for Original Sorting ORISODEC7PACK4
TYPAEType of Change TYPAECHAR1CHAR1
UBHKTG/L Account Number for Our Bank Account / Bank Sub-Account UBHKTCHAR10Assigned to domainALPHASAKNR
UBKNTOur account number at the bank UBKNTCHAR18BANKN
UBKONBank control key at our bank UBKONCHAR2BKONT
UBNKSBank country key BANKSCHAR3Assigned to domainLAND1BKL
UBNKLBank number of our bank UBNKLCHAR15BANKL
PAYGRGrouping Field for Automatic Payments PAYGRCHAR20CHAR20
UBNKYBank key of our bank UBNKYCHAR15BANKK
ZBNKYBank key of the payee's bank DZBNKYCHAR15BANKK
KURSFExchange rate KURSFDEC9(5) EXCRTKURSF
RBET2Amount Paid in Second Local Currency RBET2CURR13(2) WRTV7
RBET3Amount Paid in Third Local Currency RBET3CURR13(2) WRTV7
RSKO2Payment Transaction Total Discount in Second Local Currency RSKO2CURR13(2) WRTV7
RSKO3Payment Transaction Total Discount in Third Local Currency RSKO3CURR13(2) WRTV7
KURS2Exchange Rate for the Second Local Currency KURS2DEC9(5) KURSF
KURS3Exchange Rate for the Third Local Currency KURS3DEC9(5) KURSF
BKREFReference specifications for bank details BKREFCHAR20CHAR20
UZAWEPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
ZPFORCity of payee's PO box PFORT_ZCHAR35TEXT35
AUSFDDue date of the paid items AUSFDDATS8DATUM
AUGDTClearing Date AUGDTDATS8DATUM
DTAWSInstruction key for data medium exchange DTAWSCHAR2Assigned to domainDTAWS
EDIAVEDI Payment Advice Status EDIAVCHAR1EDIST
EDIBNEDI Payment Order Status EDIBNCHAR1EDIST
KOINHAccount Holder Name KOINH_FICHAR60KOINH
DTWS1Instruction key 1 DTAT16NUMC2Assigned to domainDTWSX
DTWS2Instruction key 2 DTAT17NUMC2Assigned to domainDTWSX
DTWS3Instruction key 3 DTAT18NUMC2Assigned to domainDTWSX
DTWS4Instruction key 4 DTAT19NUMC2Assigned to domainDTWSX
KIDNOPayment Reference KIDNOCHAR30CHAR30
PYORDPayment Order PYORDCHAR10ALPHAPYORD
VERTNContract Number RANLCHAR13ALPHARANLRAN
VBEWAFlow Type SBEWARTCHAR4Assigned to domainSBEWART
BTYP1Type of bank in a bank chain (correspondent, intermediary) BNTYPCHAR1BNTYP
BNKS1Bank country key BANKSCHAR3Assigned to domainLAND1BKL
BNKL1Bank Keys BANKKCHAR15BANKKBNK
BNKN1Bank account number BANKNCHAR18BANKN
BKON1Bank Control Key BKONTCHAR2BKONT
BTYP2Type of bank in a bank chain (correspondent, intermediary) BNTYPCHAR1BNTYP
BNKS2Bank country key BANKSCHAR3Assigned to domainLAND1BKL
BNKL2Bank Keys BANKKCHAR15BANKKBNK
BNKN2Bank account number BANKNCHAR18BANKN
BKON2Bank Control Key BKONTCHAR2BKONT
BTYP3Type of bank in a bank chain (correspondent, intermediary) BNTYPCHAR1BNTYP
BNKS3Bank country key BANKSCHAR3Assigned to domainLAND1BKL
BNKL3Bank Keys BANKKCHAR15BANKKBNK
BNKN3Bank account number BANKNCHAR18BANKN
BKON3Bank Control Key BKONTCHAR2BKONT
SAKNRG/L Account Number SAKNRCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
XURGEIndicator: Extremely Urgent Payment PRQ_XURGECHAR1X
ZIBANIBAN of the Payee DZIBANCHAR34IBAN
MGUIDSEPA Mandate: GUID of Mandate SEPA_MGUIDRAW16
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
SEQ_TYPESEPA: Sequence Type SEPA_SEQ_TYPECHAR4SEPA_SEQ_TYPE
INST_CODELocal Instrument Code (Direct Debit Type) FSEPA_INST_CODECHAR4FSEPA_INST_CODE

Key field Non-key field



How do I retrieve data from SAP structure REGUO using ABAP code?

As REGUO is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on REGUO as there is no data to select.

How to access SAP table REGUO

Within an ECC or HANA version of SAP you can also view further information about REGUO and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!