SAP VDORDER Borrower's note loan order data Table
Overview
VDORDER is a standard SAP S/4HANA table that stores Borrower's note loan order data data. There are total 77 fields in the VDORDER table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDORDER belongs to Loans Management (FS-CML) module and is located in the package Treasury Loans (FVVD).
In addition, following links provide an overview of foreign key relationships, if any, that link VDORDER to other SAP tables and standard CDS views available based on VDORDER table in S/4HANA 2020.
Techincal Settings of VDORDER
Below are technical details of the table VDORDER
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDORDER Fields
The following table gives you an overview of the fields available in VDORDER
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RANL | Contract Number | RANL | CHAR | 13 | |
| NORDER | Order Number | NORDER | NUMC | 8 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| SABRECH | Status borrower's note order | SSDSTAT | CHAR | 1 | |
| SBEWART | Flow Type | SBEWART | CHAR | 4 | |
| SBEWZITI | Flow category | SBEWZITI | TZB03 | CHAR | 4 |
| SPLANIST | Plan/actual record/record to be released indicator | SPLANIST | CHAR | 1 | |
| SSOLHAB | Debit/credit indicator | VVSSOLHAB | CHAR | 1 | |
| SANLF | Product Category | SANLF | NUMC | 3 | |
| SSTATI | Order Status | VVDSTATORD | NUMC | 2 | |
| GSART | Product Type | VVSART | TZPAB | CHAR | 3 |
| RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | T037S | CHAR | 8 |
| DORDER | Order day | DORDER | DATS | 8 | |
| BNWHR | Nominal amount | BNWHR | CURR | 13 | |
| SNWHR | Currency of nominal amount | SNWHR | TCURC | CUKY | 5 |
| BBWHR | Amount in position currency | BBWHR | CURR | 13 | |
| SBWHR | Position Currency (Currency of Position Amount) | SBWHR | TCURC | CUKY | 5 |
| BCWHR | Settlement Amount | BCWHR | CURR | 13 | |
| SCWHR | Settlement Currency | SCWHR | TCURC | CUKY | 5 |
| BHWHR | Amount in local currency | BHWHR | CURR | 13 | |
| KURS1 | Exchange rate | VVKURSF | DEC | 9 | |
| KURS2 | Exchange rate | VVKURSF | DEC | 9 | |
| DVALUT | Calculation Date | DVALUT | DATS | 8 | |
| DFAELL | Due date/calculation date | DFAELLIG | DATS | 8 | |
| DDISPO | Payment Date | DDISPO | DATS | 8 | |
| DBESTAND | Position value date | DBESTAND | DATS | 8 | |
| DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | |
| DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | |
| ATAGE | Number of Days | VVATAGE | NUMC | 6 | |
| ABASTAGE | Number of base days in a calculation period | ABASTAGE | NUMC | 6 | |
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| JONLAEN | Indicator for fixing a flow record | JONLAEN | CHAR | 1 | |
| JZINSBAS | Flow in interest base | JZINSBAS | CHAR | 1 | |
| JZINSZPT | Interest date | JZINSZPT | CHAR | 1 | |
| PKOND | Percentage rate for condition items | PKOND | DEC | 10 | |
| BBASIS | Calculation Base Amount | BBASIS | CURR | 13 | |
| SSORTZIT | Sort indicator for interest/repayment schedule calculations | SSORTZIT | CHAR | 1 | |
| SWOHER | Source of flow record | SWOHER | CHAR | 1 | |
| SSTCKKZ | Accrued interest method | SSTCKKZ | CHAR | 1 | |
| SSTCKTG | Accrued interest: Daily method | SSTCKTG | CHAR | 1 | |
| PEFFZINS | Effective Interest Rate | PEFFZINS | DEC | 10 | |
| SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | |
| PARTNR | Business Partner Number | BU_PARTNER | BUT000 | CHAR | 10 |
| SROLEXT | Dummy function | DUMMY_3 | CHAR | 3 | |
| XPART | Name of Contact Person (User-Defined Text) | XPART | CHAR | 30 | |
| SANRED | Form of Address (Key) | BP_TITLE_NEW | TSAD3 | CHAR | 4 |
| SWORTL | Wording of order/contract | SWORTL | TD20 | NUMC | 2 |
| DVKMAX | Value date for preemption at the latest by | DVKMAX | DATS | 8 | |
| KKASSE | Cash price for repeat purchases | KKASSE | DEC | 10 | |
| KMARKT | Market price for preemptions | KMARKT | DEC | 10 | |
| BVTYP | Partner bank type | BVTYP | CHAR | 4 | |
| RBANKK | Bank account | RBANKK | CHAR | 10 | |
| PWKURS | Security price for percentage quotation | PWKURS | DEC | 10 | |
| SGTXT | Item Text | SGTXT | CHAR | 50 | |
| RDEALER | Trader | RDEALER | TZDEA | CHAR | 12 |
| DVKMIN | Preemption payment date Poss. as from | DVKMIN | DATS | 8 | |
| ZUONR | Assignment number | DZUONR | CHAR | 18 | |
| XPORE | Indicator: Individual Payment? | PRQ_XPORE | CHAR | 1 | |
| SPAYRQ | Generate Payment Request | TB_SPAYRQK | CHAR | 1 | |
| HBKID | Short Key for a House Bank | HBKID | T012 | CHAR | 5 |
| HKTID | ID for Account Details | HKTID | T012K | CHAR | 5 |
| ZLSCH | Payment Method | DZLSCH | T042Z | CHAR | 1 |
| SPRSNG | Individual Payment | TB_SPRSNGK | CHAR | 1 | |
| UZAWE | Payment method supplement | UZAWE | CHAR | 2 | |
| SPRGRD | Determine Grouping Definition | TB_SPRGRD | CHAR | 1 | |
| SCSPAY | Same Direction Necessary for Joint Payment? | TB_SCSPAY | CHAR | 1 | |
| ZWELS | List of Respected Payment Methods | DZWELS | CHAR | 10 | |
| PAYGR | Grouping Field for Automatic Payments | PAYGR | CHAR | 20 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VDORDER
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDORDER | BUKRS | 1: CN | T001 |
| VDORDER | GSART | 1: CN | TZPAB |
| VDORDER | HBKID | : | T012 |
| VDORDER | HKTID | : | T012K |
| VDORDER | MANDT | 1: CN | T000 |
| VDORDER | PARTNR | 1: CN | BUT000 |
| VDORDER | RDEALER | 1: CN | TZDEA |
| VDORDER | RREFKONT | 1: CN | T037S |
| VDORDER | SANRED | C: CN | TSAD3 |
| VDORDER | SBEWZITI | 1: CN | TZB03 |
| VDORDER | SBWHR | 1: CN | TCURC |
| VDORDER | SCWHR | 1: CN | TCURC |
| VDORDER | SNWHR | 1: CN | TCURC |
| VDORDER | SWORTL | 1: CN | TD20 |
| VDORDER | ZLSCH | : | T042Z |