REGUH

Transparent Table Application Table
174 Fields 8 CDS Views

Regulierungsdaten aus Zahlprogramm

REGUH is an SAP database table in S/4HANA. Regulierungsdaten aus Zahlprogramm. It contains 174 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
FACVD_GLMC_OIT_02 view from Payment reference for bank account in G/L clearing
I_Paymentstatistics_Base view left_outer BASIC Base View for Payment Statistics
I_PrepaymentSettlementDate view from BASIC Prepayment Settlement Date
I_ToBeReversedPaymentDocument view left_outer BASIC Payment document to be reversed
P_Bcmitem view left_outer BASIC Analyze Payment Detail BCM Item
P_PaytProposalItemAggregation view from BASIC
R_PaymentProposalPayment view from BASIC Payment Proposal Payment
VFCP_DDL_BCM view left_outer

Fields (174)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY laufd laufd Run On
KEY laufi laufi Identification
KEY xvorl xvorl Indicator: Only Proposal Run?
KEY zbukr dzbukr Paying co. code
KEY lifnr lifnr Supplier
KEY kunnr kunnr Customer
KEY empfg empfg Pmnt Recipient
KEY vblnr vblnr Payment Doc.No.
avisg avisg Advice Reason
waers waers Currency
srtgb gsber Business Area
anred anred Title
name1 name1_gp Name
name2 name2_gp Name 2
name3 name3_gp Name 3
name4 name4_gp Name 4
pstlz pstlz Postal Code
ort01 ort01_gp City
stras stras_gp Street
pfach pfach PO Box
land1 land1 Country/Reg.
stcd1 stcd1 Tax Number 1
wevwv wevwv Plan.Usage
zanre dzanre Title
znme1 dznme1 Name
znme2 dznme1 Name
znme3 dznme1 Name
znme4 dznme1 Name
zpstl dzpstl Payee Postal Code
zort1 dzort1 City
zstra dzstra Street
zpfac dzpfac PO Box
zland dzland Country/Region
zregi dzregi Regional code
zbnks dzbnks Country/Region
zbnkn dzbnkn Payee acct no.
zbnkn_long dzbnkn35 Payee Acct No.
zbnkl dzbnkl Bank number
zbkon dzbkon Control Key
zbvty dzbvty Part. Bank Type
zswif swift SWIFT/BIC
xezer xezer Collect.author.
zspra dzspra Payee lang. key
zaldt dzaldt_zhl Doc. Pstg Date
rzawe rzawe Payment Method
rumsk rumsk Special G/L Ind
rzums rzums Target Spec. G/L Ind
hktid hktid Account ID
hbkid hbkid House Bank
hktiw hktiw Acct for Bill/Exch.
hbkiw hbkiw House Bank
bvtyp bvtyp Part.bank type
ubkon ubkon Control Key
ubknt ubknt Our account number
ubknt_long ubknt35 Our Account Number
ubnks banks Bank Ctry/Reg.
ubnkl ubnkl House bank no.
uiban uiban IBAN House Bank
ubhkt ubhkt G/L Account No.
valut valut Value date
crval prq_crval Value date payee
anfae anfae Return Bef.
wefae wefae BoE Due Date
rbetr rbetr Local Curr.Pmnt Amnt
rskon rskon Cash Discnt(LC)
rwbtr rwbtr Amount Paid
rwskt rwskt Cash Discount Amount
rspe1 spes1 Charges 1
rspe2 spes2 Charges 2
rpost rpost Number of Items Paid
rtext rtext_d No.Txt Lines for Items Paid
rspm1 spem1 Charges 1
rspm2 spem2 Charges 2
wehmx wehmx Max.Amt per Bill/Ex
wefmx wefmx Max.Amt per Bill/Ex
wehrs wehrs Rem. Amt Bill/Ex.
wefrs wefrs Rem. Amt Bill/Ex.
weamx weamx No. Bills/Ex.
busab busab Clerk Abbrev.
eikto eikto Acct at Cust.
xinve xinve Invest.ID
wdate wdate Issue Date
xaend xaend_regu Change
zlspr dzlspr Pmnt block
dtaws dtaws Instruction Key
dtams dtams DME Rec. Code
kursf kursf Exchange rate
abwae abwae Settlement cur.
skvhw skvhw Lost Disc.(LC)
skvfw skvfw Lost C.Disc(FC)
dskvh dskvh Imp. Lost Disc.
zpst2 dzpst2 PO box post cde
paygr paygr Grouping
zbnky dzbnky Payee bank key
ubnky ubnky House Bank Key
pstl2 pstl2 PO Box PCode
absbu absbu Sending co.code
rbet2 rbet2 LC2 Amount Paid
rbet3 rbet3 LC3 Amount Paid
rsko2 rsko2 Discount 2. LC
rsko3 rsko3 Discount 3. LC
kurs2 kurs2 Exchange Rate 2
kurs3 kurs3 Exchange Rate 3
bkref bkref Reference
uzawe uzawe Pmnt Meth. Sup.
zort2 ort02_z District
ztlfx telfx_z Fax Number
xsiwe xsiwe Bill on Demand
zpfor pfort_z PO box city
pernr pernr_d Personnel No.
seqnr seqc5 Sequence Number
btznr btznr Assignment of Transfers
ausfd ausfd Due Date
augdt augdt Clearing
ediav ediav EDI pmnt.ad.st.
idoc_num_avis edi_docnum IDoc number
edibn edibn EDI payment order status
idoc_num edi_docnum IDoc number
ztelf telfn_z Payee telephone number
ztelx telex_z Telex Number
koinh koinh_fi Account holder
dtws1 dtat16 Instruct. Key 1
dtws2 dtat17 Instruct. Key 2
dtws3 dtat18 Instruct. key 3
dtws4 dtat19 Instruct. key 4
payt_rsn farp_payt_rsn Payment Reason
zstc1 stcd1_z Payee tax cde.1
kidno kidno Payment Ref.
pyord pyord Payment Order
regio regio Region
text text Field name
btyp1 bntyp Bank type in chain
bnks1 banks Bank Ctry/Reg.
bnkl1 bankk Bank Key
bnkn1 bankn Bank Account
bkon1 bkont Control Key
bkrf1 bkref Reference
iban1 iban IBAN
btyp2 bntyp Bank type in chain
bnks2 banks Bank Ctry/Reg.
bnkl2 bankk Bank Key
bnkn2 bankn Bank Account
bkon2 bkont Control Key
bkrf2 bkref Reference
iban2 iban IBAN
btyp3 bntyp Bank type in chain
bnks3 banks Bank Ctry/Reg.
bnkl3 bankk Bank Key
bnkn3 bankn Bank Account
bkon3 bkont Control Key
bkrf3 bkref Reference
iban3 iban IBAN
saknr saknr G/L Account
hkont hkont G/L Acct
alebn alebn ALE IDoc Distribution Status of Payment Data
xkdfb xkdfb_042e No Exch. Rate Diffr
srtbp bupla Business place
dorigin fibl_dorigin Grouping Origin
rfttrn rfttrn_bf Payment code
zadnr adrnr_z Payee's Address Number
adrnr ad_addrnum Address Number
ziban dziban IBAN of the Payee
mguid sepa_mguid Mandate GUID
seq_type sepa_seq_type Sequence Type
inst_code fsepa_inst_code Direct Debit Type
purp_code fpm_purp_code SEPA Purpose Code: Classification of a Payment/Debit Memo
xmlst xmlst_avis Stat.XML PytAdv
timestamp_avis timestamp_avis Time Stamp
uetr fpm_uetr Unique Reference
zpayment_system payee_payment_system Payee Payment System
zalias_type payee_alias_type Payee Alias Type
zbank_alias payee_bank_alias Payee Alias
j_1tpbupl bcode Branch Code

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Regulierungsdaten aus Zahlprogramm
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE REGUH (
    MANDT,            -- Client [mandt]
    LAUFD,            -- Run On [laufd]
    LAUFI,            -- Identification [laufi]
    XVORL,            -- Indicator: Only Proposal Run? [xvorl]
    ZBUKR,            -- Paying co. code [dzbukr]
    LIFNR,            -- Supplier [lifnr]
    KUNNR,            -- Customer [kunnr]
    EMPFG,            -- Pmnt Recipient [empfg]
    VBLNR,            -- Payment Doc.No. [vblnr]
    AVISG,            -- Advice Reason [avisg]
    WAERS,            -- Currency [waers]
    SRTGB,            -- Business Area [gsber]
    ANRED,            -- Title [anred]
    NAME1,            -- Name [name1_gp]
    NAME2,            -- Name 2 [name2_gp]
    NAME3,            -- Name 3 [name3_gp]
    NAME4,            -- Name 4 [name4_gp]
    PSTLZ,            -- Postal Code [pstlz]
    ORT01,            -- City [ort01_gp]
    STRAS,            -- Street [stras_gp]
    PFACH,            -- PO Box [pfach]
    LAND1,            -- Country/Reg. [land1]
    STCD1,            -- Tax Number 1 [stcd1]
    WEVWV,            -- Plan.Usage [wevwv]
    ZANRE,            -- Title [dzanre]
    ZNME1,            -- Name [dznme1]
    ZNME2,            -- Name [dznme1]
    ZNME3,            -- Name [dznme1]
    ZNME4,            -- Name [dznme1]
    ZPSTL,            -- Payee Postal Code [dzpstl]
    ZORT1,            -- City [dzort1]
    ZSTRA,            -- Street [dzstra]
    ZPFAC,            -- PO Box [dzpfac]
    ZLAND,            -- Country/Region [dzland]
    ZREGI,            -- Regional code [dzregi]
    ZBNKS,            -- Country/Region [dzbnks]
    ZBNKN,            -- Payee acct no. [dzbnkn]
    ZBNKN_LONG,       -- Payee Acct No. [dzbnkn35]
    ZBNKL,            -- Bank number [dzbnkl]
    ZBKON,            -- Control Key [dzbkon]
    ZBVTY,            -- Part. Bank Type [dzbvty]
    ZSWIF,            -- SWIFT/BIC [swift]
    XEZER,            -- Collect.author. [xezer]
    ZSPRA,            -- Payee lang. key [dzspra]
    ZALDT,            -- Doc. Pstg Date [dzaldt_zhl]
    RZAWE,            -- Payment Method [rzawe]
    RUMSK,            -- Special G/L Ind [rumsk]
    RZUMS,            -- Target Spec. G/L Ind [rzums]
    HKTID,            -- Account ID [hktid]
    HBKID,            -- House Bank [hbkid]
    HKTIW,            -- Acct for Bill/Exch. [hktiw]
    HBKIW,            -- House Bank [hbkiw]
    BVTYP,            -- Part.bank type [bvtyp]
    UBKON,            -- Control Key [ubkon]
    UBKNT,            -- Our account number [ubknt]
    UBKNT_LONG,       -- Our Account Number [ubknt35]
    UBNKS,            -- Bank Ctry/Reg. [banks]
    UBNKL,            -- House bank no. [ubnkl]
    UIBAN,            -- IBAN House Bank [uiban]
    UBHKT,            -- G/L Account No. [ubhkt]
    VALUT,            -- Value date [valut]
    CRVAL,            -- Value date payee [prq_crval]
    ANFAE,            -- Return Bef. [anfae]
    WEFAE,            -- BoE Due Date [wefae]
    RBETR,            -- Local Curr.Pmnt Amnt [rbetr]
    RSKON,            -- Cash Discnt(LC) [rskon]
    RWBTR,            -- Amount Paid [rwbtr]
    RWSKT,            -- Cash Discount Amount [rwskt]
    RSPE1,            -- Charges 1 [spes1]
    RSPE2,            -- Charges 2 [spes2]
    RPOST,            -- Number of Items Paid [rpost]
    RTEXT,            -- No.Txt Lines for Items Paid [rtext_d]
    RSPM1,            -- Charges 1 [spem1]
    RSPM2,            -- Charges 2 [spem2]
    WEHMX,            -- Max.Amt per Bill/Ex [wehmx]
    WEFMX,            -- Max.Amt per Bill/Ex [wefmx]
    WEHRS,            -- Rem. Amt Bill/Ex. [wehrs]
    WEFRS,            -- Rem. Amt Bill/Ex. [wefrs]
    WEAMX,            -- No. Bills/Ex. [weamx]
    BUSAB,            -- Clerk Abbrev. [busab]
    EIKTO,            -- Acct at Cust. [eikto]
    XINVE,            -- Invest.ID [xinve]
    WDATE,            -- Issue Date [wdate]
    XAEND,            -- Change [xaend_regu]
    ZLSPR,            -- Pmnt block [dzlspr]
    DTAWS,            -- Instruction Key [dtaws]
    DTAMS,            -- DME Rec. Code [dtams]
    KURSF,            -- Exchange rate [kursf]
    ABWAE,            -- Settlement cur. [abwae]
    SKVHW,            -- Lost Disc.(LC) [skvhw]
    SKVFW,            -- Lost C.Disc(FC) [skvfw]
    DSKVH,            -- Imp. Lost Disc. [dskvh]
    ZPST2,            -- PO box post cde [dzpst2]
    PAYGR,            -- Grouping [paygr]
    ZBNKY,            -- Payee bank key [dzbnky]
    UBNKY,            -- House Bank Key [ubnky]
    PSTL2,            -- PO Box PCode [pstl2]
    ABSBU,            -- Sending co.code [absbu]
    RBET2,            -- LC2 Amount Paid [rbet2]
    RBET3,            -- LC3 Amount Paid [rbet3]
    RSKO2,            -- Discount 2. LC [rsko2]
    RSKO3,            -- Discount 3. LC [rsko3]
    KURS2,            -- Exchange Rate 2 [kurs2]
    KURS3,            -- Exchange Rate 3 [kurs3]
    BKREF,            -- Reference [bkref]
    UZAWE,            -- Pmnt Meth. Sup. [uzawe]
    ZORT2,            -- District [ort02_z]
    ZTLFX,            -- Fax Number [telfx_z]
    XSIWE,            -- Bill on Demand [xsiwe]
    ZPFOR,            -- PO box city [pfort_z]
    PERNR,            -- Personnel No. [pernr_d]
    SEQNR,            -- Sequence Number [seqc5]
    BTZNR,            -- Assignment of Transfers [btznr]
    AUSFD,            -- Due Date [ausfd]
    AUGDT,            -- Clearing [augdt]
    EDIAV,            -- EDI pmnt.ad.st. [ediav]
    IDOC_NUM_AVIS,    -- IDoc number [edi_docnum]
    EDIBN,            -- EDI payment order status [edibn]
    IDOC_NUM,         -- IDoc number [edi_docnum]
    ZTELF,            -- Payee telephone number [telfn_z]
    ZTELX,            -- Telex Number [telex_z]
    KOINH,            -- Account holder [koinh_fi]
    DTWS1,            -- Instruct. Key 1 [dtat16]
    DTWS2,            -- Instruct. Key 2 [dtat17]
    DTWS3,            -- Instruct. key 3 [dtat18]
    DTWS4,            -- Instruct. key 4 [dtat19]
    PAYT_RSN,         -- Payment Reason [farp_payt_rsn]
    ZSTC1,            -- Payee tax cde.1 [stcd1_z]
    KIDNO,            -- Payment Ref. [kidno]
    PYORD,            -- Payment Order [pyord]
    REGIO,            -- Region [regio]
    TEXT,             -- Field name [text]
    BTYP1,            -- Bank type in chain [bntyp]
    BNKS1,            -- Bank Ctry/Reg. [banks]
    BNKL1,            -- Bank Key [bankk]
    BNKN1,            -- Bank Account [bankn]
    BKON1,            -- Control Key [bkont]
    BKRF1,            -- Reference [bkref]
    IBAN1,            -- IBAN [iban]
    BTYP2,            -- Bank type in chain [bntyp]
    BNKS2,            -- Bank Ctry/Reg. [banks]
    BNKL2,            -- Bank Key [bankk]
    BNKN2,            -- Bank Account [bankn]
    BKON2,            -- Control Key [bkont]
    BKRF2,            -- Reference [bkref]
    IBAN2,            -- IBAN [iban]
    BTYP3,            -- Bank type in chain [bntyp]
    BNKS3,            -- Bank Ctry/Reg. [banks]
    BNKL3,            -- Bank Key [bankk]
    BNKN3,            -- Bank Account [bankn]
    BKON3,            -- Control Key [bkont]
    BKRF3,            -- Reference [bkref]
    IBAN3,            -- IBAN [iban]
    SAKNR,            -- G/L Account [saknr]
    HKONT,            -- G/L Acct [hkont]
    ALEBN,            -- ALE IDoc Distribution Status of Payment Data [alebn]
    XKDFB,            -- No Exch. Rate Diffr [xkdfb_042e]
    SRTBP,            -- Business place [bupla]
    DORIGIN,          -- Grouping Origin [fibl_dorigin]
    RFTTRN,           -- Payment code [rfttrn_bf]
    ZADNR,            -- Payee's Address Number [adrnr_z]
    ADRNR,            -- Address Number [ad_addrnum]
    ZIBAN,            -- IBAN of the Payee [dziban]
    MGUID,            -- Mandate GUID [sepa_mguid]
    SEQ_TYPE,         -- Sequence Type [sepa_seq_type]
    INST_CODE,        -- Direct Debit Type [fsepa_inst_code]
    PURP_CODE,        -- SEPA Purpose Code: Classification of a Payment/Debit Memo [fpm_purp_code]
    XMLST,            -- Stat.XML PytAdv [xmlst_avis]
    TIMESTAMP_AVIS,   -- Time Stamp [timestamp_avis]
    UETR,             -- Unique Reference [fpm_uetr]
    ZPAYMENT_SYSTEM,  -- Payee Payment System [payee_payment_system]
    ZALIAS_TYPE,      -- Payee Alias Type [payee_alias_type]
    ZBANK_ALIAS,      -- Payee Alias [payee_bank_alias]
    J_1TPBUPL,        -- Branch Code [bcode]
    PRIMARY KEY (MANDT, LAUFD, LAUFI, XVORL, ZBUKR, LIFNR, KUNNR, EMPFG, VBLNR)
);

Learn More