Follow us on LinkedIn for your next SAP project

← Back to Search

SAP Table TZPA

Financial Assets Management Product Types

TZPA (Financial Assets Management Product Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TZPA to other SAP tables.

TZPA table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

MANDT

Client

MANDT

T000

CLNT

GSART

Product Type

VVSART

CHAR

RANTYP

Contract Type

RANTYP

CHAR

Value	Description
1	Loans
2	Securities
3	Lease-Out - Real Estate
4	Foreign Exchange
5	Money Market
6	Derivatives
7	Open Item Transactions
8	Administration Contract - Real Estate
9	General Contract - Real Estate
A	Internal use only
Y	Reserved for Customer Enhancements
Z	Reserved for Customer Enhancements
V	Contract Management - Consumer Products
X	External Accounts
E	Exposure Position

SANLF

Product Category

SANLF

TZAF

NUMC

SKOGRP

Condition Group

SKOGRP

TZK04

NUMC

SFDLEV

Not used

OVERW2

CHAR

APLAN

Cash management update period in years

VVAPLAN

NUMC

SAKTPAS

Indicator: Asset/Liability Transaction

VVSAKTPAS

CHAR

Value	Description
NULL	Asset Transaction
1	Liabilities Transaction

AUSWA

Financial Assets Management field selection string

VVFEAUS

CHAR

100

NUMKR

Number range

NUMKR

CHAR

JREFER

Reference data indicator

JREFER

CHAR

Value	Description
NULL	No
1	Yes

JEINBEHALT

Indicator for withholding of amount during disbursement

VVJEINBE

CHAR

Value	Description
X	Selection character
NULL	Blank

SEFFMETH

Effective Interest Method (Financial Mathematics)

SEFFMETH

NUMC

Value	Description
1	PAngV
2	AIBD/ISMA
3	Braess
4	Moosmueller
5	US method
6	EU Act/365
8	EU 30.42/365
9	Linear

SZBMETH

Interest Calculation Method

SZBMETH

CHAR

Value	Description
1	360E/360
B	360E/365
F	360/360 (ISDA)
H	360/365 (ISDA)
7	360/360
2	Act/360
E	Act/364
3	Act/365
4	Act/366
5	Act/ActP (ICMA)
6	Act/ActY (ISDA)
G	Act/ActE (AFB)
A	ActW/252
D	365/360
C	365/365
I	360E/ActY
8	*365/360
9	*365.25/360
P	1/1
J	m+act/360
K	m+30/360
NULL	Not Specified

SDISEIN

Type of Discount Withholding

SDISEIN

CHAR

Value	Description
1	Total with first disbursement
2	Proportionate per partial disbursement
3	Total with last disbursement

PDISLIMIT

Discount limit accrued

PDISLIMIT

DEC

SSOLIST

Calculation using actual principle (or debit)

SSOLIST

CHAR

VVRANLWI1

No. of the secondary index description for class data

VVRANLWI

TWX1

NUMC

VVRANLWI2

No. of the secondary index description for class data

VVRANLWI

TWX1

NUMC

SZPA

Interest per disbursement

SZPA

CHAR

Value	Description
X	Interest per disbursement
NULL	Int.pmnt due date method

SORDER

Borrower's note via order management

VVSORDER

CHAR

Value	Description
X	Yes
NULL	No

SREVAL

Determine price gain taking account of accruals/deferrals

VVSREVAL

CHAR

Value	Description
X	Yes
NULL	No

DSART

Planning type

DSART

T037

CHAR

SASGNCOMP

Assign product type to TR-TM component

VVSASSIGNCOMP

CHAR

Value	Description
X	Yes
NULL	No

SREVALEXCL

Price gains w/o proportionate gains from deferral write-back

VVSREVALEXCL

CHAR

Value	Description
X	Yes
NULL	No

SCOLLATER

Collateral active

SCOLLATERAL

CHAR

Value	Description
X	Yes
NULL	No

SREALEST

Objects Active

SREALESTATE

CHAR

Value	Description
X	Yes
NULL	No

SUSEREXIT

User exit 14 active

SUSEREXIT

CHAR

Value	Description
X	Yes
NULL	No

DRAWNART

Product Type of the Drawn Bond

DRAWN_PRODUCTTYPE

TZPA

CHAR

DRAWNTEXT

Additional Text for the Class of Drawn Positions

DRAWNTEXT

CHAR

SPRODUCT

Check Against Underlying Product

SPRODUCT

CHAR

Value	Description
NULL	No Check
X	Against Product Version when Contract Created
A	Against Current Product Version

SFASTENTRY

Creation Only Permitted Via Process Consumer Loan"

SFASTENTRY

CHAR

Value	Description
X	Yes
NULL	No

SLIVEINS

Credit Life Insurance Active

SLIVEINS

CHAR

Value	Description
X	Yes
NULL	No

SDISBURSE

Disbursement Permitted Only Via Loan

SDISBURSE

CHAR

Value	Description
X	Yes
NULL	No

SDEFERRAL

Deferral Active

SDEFERRAL

CHAR

Value	Description
X	Yes
NULL	No

SARREARCAP

Capitalization of Overdue Items Active

SARREARCAP

CHAR

Value	Description
X	Yes
NULL	No

SNOTICE

Payoff for Consumer Loans Active

SNOTICE

CHAR

Value	Description
X	Yes
NULL	No

SNOTICE_LENDER

Notice for Consumer Loans Active

SNOTICE_LENDER

CHAR

Value	Description
X	Yes
NULL	No

SCAPITALTRANSFER

Capital Transfer Active

SCAPITALTRANSFER

CHAR

Value	Description
X	Yes
NULL	No

SBODISBACTIVE

Business Operation Disbursement Active

SBODISBACTIVE

CHAR

Value	Description
X	Yes
NULL	No

SAUTOPAYPP

Automatic Payment Postprocessing Active

SAUTOPAYPP

CHAR

Value	Description
X	Yes
NULL	No

SEXTDUNING

Extended Dunning Active

SEXTDUNNING

CHAR

Value	Description
X	Yes
NULL	No

SRELEASE

Start Release Only if Product Breached

SRELEASE

CHAR

Value	Description
X	Yes
NULL	No

SESCROW

Escrow Active

SESCROW

CHAR

Value	Description
X	Yes
NULL	No

SINSURANCE

Indicator: Insurance Active for Product Type

SUSINSURANCE

CHAR

Value	Description
X	Yes
NULL	No

SNO_CONDITIONS

Indicator Do Not Create Conditions for This Product Type

SNO_CONDITIONS

CHAR

Value	Description
X	Yes
NULL	No

CMS

Link to CMS Relevant for Transaction Type

TB_GSART_CMS

CHAR

Value	Description
X	Flag set. Event has occurred.
NULL	Flag is Not Set

SIOA

IOA Active

TB_IOA_ACTV

CHAR

Value	Description
X	Yes
NULL	No

SLPG

Limit Product Group

TB_SLPG

ATLPG

CHAR

IC_PROD_TYPE

Product Type Investor Contract

TB_IC_PROD_TYPE

TZIC

CHAR

REFRATE

Flag to activate/deactivate the multi-int. rate during disb.

TB_REFRATE_CMLCHN

CHAR

Value	Description
X	Flag set. Event has occurred.
NULL	Flag is Not Set

RES_TIME_VALUE

Residence Time Value

TB_RES_TIME_VALUE

NUMC

Value	Description
001	Value should be within the specified range

RES_TIME_UNIT

Residence Time Unit

TB_RES_TIME_UNIT

CHAR

Value	Description
Days	Days
Months	Months
Years	Years

TZPA foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table	Check field
TZPA	DRAWNART	TZPA	MANDT	TZPA Financial Assets Management Product Types	MANDT
TZPA	DRAWNART	TZPA	DRAWNART	TZPA Financial Assets Management Product Types	GSART
TZPA	DSART	TZPA	MANDT	T037 Planning Types	MANDT
TZPA	DSART	TZPA	DSART	T037 Planning Types	DSART
TZPA	IC_PROD_TYPE	TZPA	IC_PROD_TYPE	TZIC Product Type Investor Contract	IC_PROD_TYPE
TZPA	MANDT	TZPA	MANDT	T000 Clients	MANDT
TZPA	SANLF	TZPA	SANLF	TZAF Product categories	SANLF
TZPA	SKOGRP	TZPA	MANDT	TZK04 Condition Groups	MANDT
TZPA	SKOGRP	TZPA	RANTYP	TZK04 Condition Groups	RANTYP
TZPA	SKOGRP	TZPA	SKOGRP	TZK04 Condition Groups	SKOGRP
TZPA	SLPG	TZPA	MANDT	ATLPG Limit Product Group	MANDT
TZPA	SLPG	TZPA	SLPG	ATLPG Limit Product Group	SLPG
TZPA	VVRANLWI1	TZPA	VVRANLWI1	TWX1 Class data sec. index numbers	VVRANLWI
TZPA	VVRANLWI1	TZPA	MANDT	TWX1 Class data sec. index numbers	MANDT
TZPA	VVRANLWI2	TZPA	MANDT	TWX1 Class data sec. index numbers	MANDT
TZPA	VVRANLWI2	TZPA	VVRANLWI2	TWX1 Class data sec. index numbers	VVRANLWI