SAP ABAP Table VDORDER (Borrower's note loan order data)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD (Package) Treasury Loans

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VDORDER	Table Relationship Diagram
Short Description	Borrower's note loan order data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RANL	☑	RANL	RANL	CHAR	13	0	Contract Number
4	NORDER	☑	NORDER	NUM8	NUMC	8	0	Order Number
5	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
6	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
7	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
8	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
9	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
10	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
11	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
12	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
13	SABRECH	☐	SSDSTAT	SSDSTAT	CHAR	1	0	Status borrower's note order
14	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
15	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	TZB03
16	SPLANIST	☐	SPLANIST	SPLANIST	CHAR	1	0	Plan/actual record/record to be released indicator
17	SSOLHAB	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
18	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
19	SSTATI	☐	VVDSTATORD	STATI	NUMC	2	0	Order Status	*
20	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPAB
21	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	T037S
22	DORDER	☐	DORDER	DATUM	DATS	8	0	Order day
23	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
24	SNWHR	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	TCURC
25	BBWHR	☐	BBWHR	WERTV7	CURR	13	2	Amount in position currency
26	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
27	BCWHR	☐	BCWHR	WERTV7	CURR	13	2	Settlement Amount
28	SCWHR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	TCURC
29	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
30	KURS1	☐	VVKURSF	KURSF	DEC	9	5	Exchange rate
31	KURS2	☐	VVKURSF	KURSF	DEC	9	5	Exchange rate
32	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
33	DFAELL	☐	DFAELLIG	DATUM	DATS	8	0	Due date/calculation date
34	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
35	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
36	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
37	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
38	ATAGE	☐	VVATAGE	INT6	NUMC	6	0	Number of days
39	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
40	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
41	JONLAEN	☐	JONLAEN	VVSONLAEN	CHAR	1	0	Indicator for fixing a flow record
42	JZINSBAS	☐	JZINSBAS	JANEI	CHAR	1	0	Flow in interest base
43	JZINSZPT	☐	JZINSZPT	JANEI	CHAR	1	0	Interest date
44	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
45	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
46	SSORTZIT	☐	SSORTZIT	CHAR1	CHAR	1	0	Sort indicator for interest/repayment schedule calculations
47	SWOHER	☐	SWOHER	CHAR1	CHAR	1	0	Source of flow record
48	SSTCKKZ	☐	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
49	SSTCKTG	☐	SSTCKTG	SZBMETH	CHAR	1	0	Accrued interest: Daily method
50	PEFFZINS	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
51	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
52	PARTNR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
53	SROLEXT	☐	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
54	XPART	☐	XPART	XMBEZ	CHAR	30	0	Name of Contact Person (User-Defined Text)
55	SANRED	☐	BP_TITLE_NEW	AD_TITLE	CHAR	4	0	Form of Address (Key)	TSAD3
56	SWORTL	☐	SWORTL	SWORTL	NUMC	2	0	Wording of order/contract	TD20
57	DVKMAX	☐	DVKMAX	DATUM	DATS	8	0	Value date for preemption at the latest by
58	KKASSE	☐	KKASSE	DEC3_7	DEC	10	7	Cash price for repeat purchases
59	KMARKT	☐	KMARKT	DEC3_7	DEC	10	7	Market price for preemptions
60	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
61	RBANKK	☐	RBANKK	SAKNR	CHAR	10	0	Bank account	*
62	PWKURS	☐	PWKURS	PWKURS	DEC	10	7	Security price for percentage quotation
63	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
64	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
65	DVKMIN	☐	DVKMIN	DATUM	DATS	8	0	Preemption payment date Poss. as from
66	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
67	XPORE	☐	PRQ_XPORE	XFELD	CHAR	1	0	Indicator: Individual Payment?
68	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
69	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
70	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	T012K
71	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
72	SPRSNG	☐	TB_SPRSNGK	XFELD	CHAR	1	0	Individual payment
73	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
74	SPRGRD	☐	TB_SPRGRD	T_SPRGRD	CHAR	1	0	Determine grouping definition
75	SCSPAY	☐	TB_SCSPAY	XFELD	CHAR	1	0	Same direction necessary for joint payment?
76	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
77	PAYGR	☐	PAYGR	CHAR20	CHAR	20	0	Grouping Field for Automatic Payments

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDORDER	BUKRS	T001	BUKRS	KEY	1	CN
2	VDORDER	GSART	TZPAB	GSART	KEY	1	CN
3	VDORDER	HBKID	T012	HBKID
4	VDORDER	HKTID	T012K	HKTID
5	VDORDER	MANDT	T000	MANDT	KEY	1	CN
6	VDORDER	PARTNR	BUT000	PARTNER	KEY	1	CN
7	VDORDER	RDEALER	TZDEA	RDEALER	KEY	1	CN
8	VDORDER	RREFKONT	T037S	RREFKONT	KEY	1	CN
9	VDORDER	SANRED	TSAD3	TITLE		C	CN
10	VDORDER	SBEWZITI	TZB03	SBEWZITI	KEY	1	CN
11	VDORDER	SBWHR	TCURC	WAERS	KEY	1	CN
12	VDORDER	SCWHR	TCURC	WAERS	KEY	1	CN
13	VDORDER	SNWHR	TCURC	WAERS	KEY	1	CN
14	VDORDER	SWORTL	TD20	SWORTL	KEY	1	CN
15	VDORDER	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in