VWBEPP

Treasury Securities: Planned Flows | #transactional | Component: Transaction Manager

🔑 Keys (7)
💰 Amounts (9)
∑ Quantities
📅 Dates (28)
☰ Categorical (41)
Other (58)
🔗 Relations (35)

Column Name	Description
MANDT FK	Client
BUKRS FK	Company Code
RANL FK	Security Class ID Number
RLDEPO FK	Securities Account
DTRANS	Flow data key: System date
TTRANS	Transaction data key: system time
NTRANS	Transaction data key: Consecutive number

Column Name	Description
💲 Stock price currency (SSWHR):
BWKURS	Security price for unit quotation
BSWHR	Market value
💲 Currency of nominal amount (SNWHR):
BNWHR	Nominal amount
BBASIS	Calculation Base Amount
💲 Position Currency (Currency of Position Amount) (SBWHR):
BBWHR	Amount in position currency
BBWHR_IDX_CLEAN	Amount in position currency
💲 Settlement Currency (SCWHR):
BCWHR	Settlement Amount
BLIMIT	Limit price for unit quotation
💲 Currency Key (T001.WAERS):
BHWHR	Amount in local currency

Column Name	Description

Column Name	Description
DTRANS	Flow data key: System date
TTRANS	Transaction data key: system time
DERF	First Entered On
TERF	Time of Creation
DBEAR	Last Edited On
TBEAR	Last Edited At
DVORGANG	Activity date
DORDER	Order day
DVALUT	Interest Value Date/Calculation Date
DDISPO	Value Date / Planning Day
DBESTAND	Position value date
DBEST6B	Date for §6b EstG relevant postings
DANST	Reservation date
TANST	Order time of day
DBERVON	Start of Calculation Period
DBERBIS	End of Calculation Period
DCOUPON	Coupon date of next delivered coupon
DFAELL	Due date
DVERRECH	Settlement date
DPKOND	Fixing Date of Percentage Rate from Condition
DBPERIOD	Period start
DEPERIOD	Period End
DGUEL_KP	Condition Item Effective From
DSCHLUSS	Date of business closing
TSCHLUSS	Time of business closing
DZFEST	Interest rate fixing date
DEVALPOST	Date of period-end closing
DBUDAT	Posting Date in the Document

Column Name	Description
SSOLHAB	Debit/credit indicator	Show values
SSPESEN	Expenses key	Show values
SLIMIT	Order notation	Show values
SWHRT	Currency swap indicator	Show values
JFDUPD	Record transferred to cash management and forecast	Show values
JONLAEN	Indicator for fixing a flow record	Show values
JZINSBAS	Flow in interest base	Show values
JZINSZPT	Interest date	Show values
SSTCKKZ	Accrued interest method	Show values
SSTCKTG	Accrued interest: Daily method	Show values
SEFFMETH	Effective Interest Method (Financial Mathematics)	Show values
SWOHER	Treasury: Source of Flow	Show values
SZBMETH	Interest Calculation Method	Show values
JEXPOZINS	Type of Compound Interest Calculation	Show values
SCOUPON	Coupon ID for interest and accrued interest calculation	Show values
SFLAT	Indicator 'Traded flat',i.e.no accrued interest calculation	Show values
SEXCLVON	Exclusive Indicator for the Start of a Calculation Period	Show values
SULTVON	Month-End Indicator for Start of a Calculation Period	Show values
SINCLBIS	Inclusive Indicator for the End of a Calculation Period	Show values
SULTBIS	Month-End Indicator for the End of a Calculation Period	Show values
SFIXRATE2	Fixed exchange rate	Show values
SFIXRATE1	Fixed exchange rate	Show values
SINCL	Inclusive indicator for beginning and end of a period	Show values
SVULT	Month-End Indicator for Value Date	Show values
STGMETH	Daily Method	Show values
STGBASIS	Base Days Method	Show values
SPAEXCL	Exclusive Indicator for Start Date of a Period	Show values
SPAULT	Month-End Indicator for Start Date of a Period	Show values
SPEINCL	Inclusive Indicator for End Date of a Period	Show values
SPEULT	Month-End Indicator for End of a Period	Show values
SINCLVERR	Inclusive Indicator for Clearing Date	Show values
SULTVERR	Month-End Indicator for Clearing Date	Show values
SVORGKZ	Activity indicator for debit/credit control	Show values
SHERKUNFT	Origin indicator: 'From planned record/actual record'	Show values
SFGKZ	Release Indicator	Show values
SZART	Payment Transaction	Show values
KGV_FLAG	Manages status of the related price gains/losses flows	Show values
SPAYRQ	Generate Payment Request	Show values
SPRSNG	Individual Payment	Show values
MIGR_CFM10	Status of Flow Related to Migration to CFM 1.0	Show values
MIGR_ERP20	Status of Flow Related to Migration to ERP2.0	Show values

Column Name	Description	Domain name
RERF	Entered By	SYCHAR12
REHER	Source of Initial Entry	CHAR10
RBEAR	Employee ID	SYCHAR12
RBHER	Editing Source	CHAR10
SSTATI	Status of data record	STATI
INTEB	Financial Assets Management internal level	INTEB
SBEWZITI	Flow category	SBEWZITI
SVORGANG	Securities-Activity	RVORGANG
NVORGANG	Activity number	CHAR3
ASTUECK	Number of units for unit-quoted securities	ASTUECK
PWKURS	Security price for percentage quotation	PWKURS
KURS1	Exchange Rate into Settlement Currency	KURSF
KURS2	Exchange rate from settlement currency into local currency	KURSF
PLIMIT	Limit price for percentage quotation	PWKURS
NORDER	Position number	NUM8
RKONTRA	Reference to Counterparty	BU_PARTNER
SROLEXTKO	Dummy function	CHAR3
PKOND	Percentage rate for condition items	DECV3_7
PEFFZINS	Effective Interest Rate	DEC3_7
KCROSS	Exchange rate	KURSF
NORDEXT	External order number	CHAR20
XZUSATZ	Assignment	CHAR18
JONLBUC	Online posting flag indicator	CHAR1
SABRECH	Single-Character Flag	CHAR1
SVERFALL	Single-Character Flag	CHAR1
ATAGE	Number of Days	INT6
ABASTAGE	Number of base days in a calculation period	INT6
SKALIDWT	Interest Calendar	WFCID
SOBJEKT	Internal key for object	VVKEY
SROLEXTZB	Dummy function	CHAR3
JVERK6B	Sale in Acc. with Tax Credit Method	CHAR1
SZEGEN	Generate Incoming Payment Immediately	SZEGEN
SREFZITI	Refer.flow category in accrual/deferral flow records	SBEWZITI
APERTAGE	No. of Days of a (Calculation) Period in Cash Flow	INT6
NSTUFE	Level number of condition item for recurring payments	NUMC2
RPNNR	Daybook no.	VVRPNNR
SBERFIMA	Calculation category for cash flow calculator	SBEWFIMA
SREFBEW	Reference flow type	SBEWART
KWKURS	Security price	VVKWKURS
SBUCHA	Indicator for postings to accruals/deferrals accounts	CHAR1
RPBANK	Partner Bank Details	BVTYP
PEFFZCALL	Effective Interest Rate	DEC3_7
REFRLDEPO	Reference sec.acct for sec.acct transfer (inflow/outflow)	RLDEPO
KUNNR	Customer Number	KUNNR
KMNR	Corporate Action Number	VKMNR
ERNR	ID number of exercised right	TER_RIGHTNUMBER
ZUOND	Assignment	TEXT18
REFER	Internal Reference	CHAR16
MERKM	Characteristics	CHAR25
RPZAHL	Payer/Payee	BU_PARTNER
RFHA	Financial Transaction	T_RFHA
INDEX_VALUE	Index Value (Independent of Basis)	TIDX_INDEX_VALUE_NO_RATIO
PPAYMENT	Payment Rate	TFM_PPAYMENT
BUSTRANSID	Identifier of the Distributor Business Transaction	SYSUUID
DGJAHR	Fiscal Year	GJAHR
RBELNRFI	Document Number of an Accounting Document	BELNR
RBELNRFI2	Document Number of an Accounting Document	BELNR
LOT_ID	Identifier of the Lot	SYSUUID

Master Data Relations \| to Other Relations ↓	Join Conditions
Company Code	`VWBEPP.MANDT == T001.MANDT` `VWBEPP.BUKRS == T001.BUKRS`
Business Transaction Category	`VWBEPP.BUSTRANSCAT == TRDTS_BT_CAT.BUSTRANSCAT`
Business Area	`VWBEPP.MANDT == TGSB.MANDT` `VWBEPP.GSBER == TGSB.GSBER`
Cost Center Reservation date Cost Center ?	`VWBEPP.MANDT == CSKS.MANDT` `VWBEPP.DANST == CSKS.DATBI` `VWBEPP.KOSTL == CSKS.KOSTL` `VWBEPP.[column in domain "KOKRS"] == CSKS.KOKRS`
Client	`VWBEPP.MANDT == T000.MANDT`
Short Key for Own House Bank Short Key for Own House Bank Company Code	`VWBEPP.MANDT == T012.MANDT` `VWBEPP.RAHABKI == T012.HBKID` `VWBEPP.BUKRS == T012.BUKRS`
Short Key for House Bank Account Company Code Short Key for House Bank Account Client Short Key for Own House Bank	`VWBEPP.BUKRS == T012K.BUKRS` `VWBEPP.RAHKTID == T012K.HKTID` `VWBEPP.MANDT == T012K.MANDT` `VWBEPP.RAHABKI == T012K.HBKID`
ID Number	`VWBEPP.MANDT == VWPANLA.MANDT` `VWBEPP.RANL == VWPANLA.RANL`
G/L Account in Company Code Company Code Client Bank account	`VWBEPP.BUKRS == SKB1.BUKRS` `VWBEPP.MANDT == SKB1.MANDT` `VWBEPP.RBANKK == SKB1.SAKNR`
Account for credit posting ? Client Account for credit posting	`VWBEPP.[column in domain "KTOPL"] == SKA1.KTOPL` `VWBEPP.MANDT == SKA1.MANDT` `VWBEPP.RHABEN == SKA1.SAKNR`
Securities Account Securities Account Company Code	`VWBEPP.MANDT == TWD01.MANDT` `VWBEPP.RLDEPO == TWD01.RLDEPO` `VWBEPP.BUKRS == TWD01.BUKRS`
Account Assignment Reference in Financial Assets Management Company Code ? Account Assignment Reference in Financial Assets Management	`VWBEPP.MANDT == T037S.MANDT` `VWBEPP.BUKRS == T037S.BUKRS` `VWBEPP.[column in domain "RANTYP"] == T037S.RANTYP` `VWBEPP.RREFKONT == T037S.RREFKONT`
Account for debit posting ? Client Account for debit posting	`VWBEPP.[column in domain "KTOPL"] == SKA1.KTOPL` `VWBEPP.MANDT == SKA1.MANDT` `VWBEPP.RSOLL == SKA1.SAKNR`
Paying Bank Paying Bank Client	`VWBEPP.RZBANK == BUT000.PARTNER` `VWBEPP.MANDT == BUT000.CLIENT`
Credit interim account ? Client Credit interim account	`VWBEPP.[column in domain "KTOPL"] == SKA1.KTOPL` `VWBEPP.MANDT == SKA1.MANDT` `VWBEPP.RZKHABE == SKA1.SAKNR`
Debit interim account ? Client Debit interim account	`VWBEPP.[column in domain "KTOPL"] == SKA1.KTOPL` `VWBEPP.MANDT == SKA1.MANDT` `VWBEPP.RZKSOLL == SKA1.SAKNR`
Reservation reason	`VWBEPP.MANDT == TW14.MANDT` `VWBEPP.SANST == TW14.SANST`
Movement type Flow Type Client ?	`VWBEPP.SBEWART == TZB0A.SBEWART` `VWBEPP.MANDT == TZB0A.MANDT` `VWBEPP.[column in domain "RANTYP"] == TZB0A.RANTYP`
Posting Key	`VWBEPP.MANDT == TBSL.MANDT` `VWBEPP.SBSLHABEN == TBSL.BSCHL`
Posting Key	`VWBEPP.MANDT == TBSL.MANDT` `VWBEPP.SBSLSOLL == TBSL.BSCHL`
Posting Key	`VWBEPP.MANDT == TBSL.MANDT` `VWBEPP.SBSLZKHA == TBSL.BSCHL`
Posting Key	`VWBEPP.MANDT == TBSL.MANDT` `VWBEPP.SBSLZKSO == TBSL.BSCHL`
Foreign Key Posting Control ? Posting Control Key	`VWBEPP.[column in domain "RANTYP"] == TZB09.RANTYP` `VWBEPP.SBUST == TZB09.SBUST`
Position Currency (Currency of Position Amount)	`VWBEPP.MANDT == TCURC.MANDT` `VWBEPP.SBWHR == TCURC.WAERS`
Currency	`VWBEPP.MANDT == TCURC.MANDT` `VWBEPP.SCRWHR1 == TCURC.WAERS`
Currency	`VWBEPP.MANDT == TCURC.MANDT` `VWBEPP.SCRWHR2 == TCURC.WAERS`
Currency	`VWBEPP.MANDT == TCURC.MANDT` `VWBEPP.SCWHR == TCURC.WAERS`
Planning Level	`VWBEPP.MANDT == T036.MANDT` `VWBEPP.SFDLEV == T036.EBENE`
Condition Type Condition Type (Smallest Subdivision of Condition Records) ?	`VWBEPP.MANDT == TZK01.MANDT` `VWBEPP.SKOART == TZK01.SKOART` `VWBEPP.[column in domain "RANTYP"] == TZK01.RANTYP`
Currency	`VWBEPP.MANDT == TCURC.MANDT` `VWBEPP.SNWHR == TCURC.WAERS`
Currency unit	`VWBEPP.MANDT == TZUNI.MANDT` `VWBEPP.SRUNIT == TZUNI.SRUNIT`
Payment Method Payment Method ?	`VWBEPP.MANDT == T042Z.MANDT` `VWBEPP.ZLSCH == T042Z.ZLSCH` `VWBEPP.[column in domain "LAND1"] == T042Z.LAND1`

Other Relations \| to Master Data Relations ↑	Join Conditions
Trader Company Code Trader Client	`VWBEPP.BUKRS == TZDEA.BUKRS` `VWBEPP.RDEALER == TZDEA.RDEALER` `VWBEPP.MANDT == TZDEA.MANDT`
Exchange Exchange Client	`VWBEPP.RHANDPL == TWH01.RHANDPL` `VWBEPP.MANDT == TWH01.MANDT`