REGUE SAP (Line items from the settlement in the payment proposal) Structure details

Dictionary Type: Structure
Description: Line items from the settlement in the payment proposal




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




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

REGUE 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 "Line items from the settlement in the payment proposal" 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_REGUE TYPE REGUE.

The REGUE table consists of various fields, each holding specific information or linking keys about Line items from the settlement in the payment proposal data available in SAP. These include BELNR (Accounting Document Number), GJAHR (Fiscal Year), BUZEI (Number of Line Item Within Accounting Document), FILKD (Account Number of the Branch).. 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 REGUE 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
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
FILKDAccount Number of the Branch FILKDCHAR10ALPHAMAXKK
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
POKENItem Indicator POKENCHAR3CHAR3
SRIDShared Services Center: CRM Service Request SSC_OBJECT_IDCHAR10ALPHASSC_OBJECT_ID
XCLOSEDservice request is closed SSC_SRCLOSEDCHAR1BOOLE
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
BUDATPosting Date in the Document BUDATDATS8DATUM
BLDATDocument Date in Document BLDATDATS8DATUM
KOARTAccount Type KOARTCHAR1KOART
BSCHLPosting Key BSCHLCHAR2Assigned to domainBSCHL
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
SAKNRG/L Account Number SAKNRCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
UMSKSSpecial G/L Transaction Type UMSKSCHAR1UMSKS
ZUMSKTarget Special G/L Indicator DZUMSKCHAR1Assigned to domainUMSKZ
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
BDIFFValuation Difference BDIFFCURR13(2) WRTV7
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
MWSTSTax Amount in Local Currency MWSTSCURR13(2) WERT7
WMWSTTax amount in document currency WMWSTCURR13(2) WERT7
SGTXTItem Text SGTXTCHAR50TEXT50
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZBD1TCash discount days 1 DZBD1TDEC3ZBDXT
ZBD2TCash discount days 2 DZBD2TDEC3ZBDXT
ZBD3TNet Payment Terms Period DZBD3TDEC3ZBDXT
ZBD1PCash Discount Percentage 1 DZBD1PDEC5(3) PRZ23
ZBD2PCash Discount Percentage 2 DZBD2PDEC5(3) PRZ23
SKFBTAmount Eligible for Cash Discount in Document Currency SKFBTCURR13(2) WERT7
SKNTOCash discount amount in local currency SKNTOCURR13(2) WERT7
WSKTOCash discount amount in document currency WSKTOCURR13(2) WERT7
SKVHWLost Cash Discount in Local Currency SKVHWCURR13(2) WERT7
SKVFWLost Cash Discount in Payment Currency SKVFWCURR13(2) WERT7
DSKVHImpending Lost Cash Discount in Local Currency DSKVHCURR13(2) WERT7
ZBFIXFixed Payment Terms DZBFIXCHAR1ZBFIX
XNETBIndicator: Document posted net ? XNETBCHAR1XFELD
ZLSPRPayment Block Key DZLSPRCHAR1T008ZAHLSSPE
SPLEVLevel on Which a Payment Block has Taken Place SPLEVCHAR1SPLEV
XREBZIndicator: Item is an Invoice-Related Credit Memo XREBZCHAR1XFELD
ZOLLTCustoms Tariff Number DZOLLTCHAR8ZOLLT
ZOLLDCustoms Date DZOLLDDATS8DATUM
LZBKZState Central Bank Indicator LZBKZCHAR3Assigned to domainLZBKZ
LANDLSupplying Country LANDLCHAR3Assigned to domainLAND1
DIEKZService Indicator (Foreign Payment) DIEKZCHAR1DIEKZ
QSSKZWithholding Tax Code QSSKZCHAR2Assigned to domainQSSKZ
QSSHBWithholding Tax Base Amount QSSHBCURR13(2) WERT7
QBSHBWithholding Tax Amount (in Document Currency) QBSHBCURR13(2) WERT7
QBSHHWithholding Tax Amount (in Local Currency) QBSHHCURR13(2) WERT7
ESRNRISR Subscriber Number ESRNRCHAR11ESRNR
ESRREISR Reference Number ESRRECHAR27ALPHAESRRE
ESRPZISR Check Digit ESRPZCHAR2CHAR2
ZBDXTSelected cash discount days DZBDXTDEC3ZBDXT
ZBDXPSelected cash discount percentage rate DZBDXPDEC5(3) PRZ23
PROJKWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
VBEL2Sales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
POSN2Sales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
ETEN2Delivery Schedule Line Number ETENRNUMC4Assigned to domainETENR
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
ANLN1Main Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
ZEKKNSequential Number of Account Assignment DZEKKNNUMC2NUM02
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
XANETIndicator: Down payment in net procedure ? XANETCHAR1XFELD
INSELIndicator: Partial Selection of Postings INSELNUMC1NUM01
VBLNRDocument Number of the Payment Document VBLNRCHAR10ALPHABELNR
TYPAEType of Change TYPAECHAR1CHAR1
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
BDIF2Valuation Difference for the Second Local Currency BDIF2CURR13(2) WRTV7
BDIF3Valuation Difference for the Third Local Currency BDIF3CURR13(2) WRTV7
DMBE2Amount in Second Local Currency DMBE2CURR13(2) WERT7
DMBE3Amount in Third Local Currency DMBE3CURR13(2) WERT7
MWST2Tax Amount in Second Local Currency MWST2CURR13(2) WERT7
MWST3Tax Amount in Third Local Currency MWST3CURR13(2) WERT7
SKNT2Cash Discount Amount in Second Local Currency SKNT2CURR13(2) WERT7
SKNT3Cash Discount Amount in Third Local Currency SKNT3CURR13(2) WERT7
QBSH2Withholding Tax Amount in Second Local Currency QBSH2CURR13(2) WERT7
QBSH3Withholding Tax Amount in Third Local Currency QBSH3CURR13(2) WERT7
UZAWEPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
VERTNContract Number RANLCHAR13ALPHARANLRAN
EMPFBPayee/Payer EMPFBCHAR10ALPHAMAXKK
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
XREF1Business partner reference key XREF1CHAR12CHAR12
XREF2Business partner reference key XREF2CHAR12CHAR12
XREF3Reference key for line item XREF3CHAR20CHAR20
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
VBEWAFlow Type SBEWARTCHAR4Assigned to domainSBEWART
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
REBZTFollow-On Document Type REBZTCHAR1REBZT
BUPLABusiness Place BUPLACHAR4Assigned to domainJ_1BBRANCH
SECCOSection Code SECCOCHAR4Assigned to domainSECCOSECCO_ABA
XSAENIndicator: Unconfirmed master data change XSAENCHAR1XFELD
PSWSLUpdate Currency for General Ledger Transaction Figures PSWSLCUKY5Assigned to domainWAERS
PSWBTAmount for Updating in General Ledger PSWBTCURR13(2) WERT7
PSSKTCash Discount Deduction for the Item PSSKTCURR13(2) WRTV7
KEYNOKey Number for Payment Request PRQ_KEYNOCHAR10Assigned to domainALPHAPRQ_KEYNO
PENLC1Penalty charge amount in first local currency PENALTY1CURR13(2) WERT13
PENLC2Penalty charge amount in second local currency PENALTY2CURR13(2) WERT13
PENLC3Penalty Charge Amount in Third Local Currency PENALTY3CURR13(2) WERT13
PENFCPenalty charge amount in document currency PENALTYCURR13(2) WERT13
PENDAYSNumber of days for penalty charge calculation PDAYSINT410INT4
.INCLU--AP 0
EXTACCOUNTExternal Account TPM_EXT_ACCOUNTCHAR10TPM_EXT_ACCOUNTTREA_EATREATH_EXT_ACCOUNT

Key field Non-key field



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

As REGUE 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 REGUE as there is no data to select.

How to access SAP table REGUE

Within an ECC or HANA version of SAP you can also view further information about REGUE 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!