SAP ABAP Table VDZNV (Payment Postprocessing Clearing Data: Module Pool TRDZ)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FS-CML (Application Component) Loans Management
⤷ FVVD (Package) Treasury Loans
⤷ FS-CML (Application Component) Loans Management
⤷ FVVD (Package) Treasury Loans
Basic Data
Table Category | INTTAB | Structure |
Structure | VDZNV | Table Relationship Diagram |
Short Description | Payment Postprocessing Clearing Data: Module Pool TRDZ |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | .INCLUDE | 0 | 0 | Payment Postprocessing Item Data: Module Pool TRDZ | |||||
2 | POSFLAG | NPOSFLAG | CHAR1 | CHAR | 1 | 0 | Item Selection Indicator | ||
3 | BZBTYP | VVBZBTYP | DDTEXT | CHAR | 60 | 0 | Name of processing category | ||
4 | ZART | VVZART | VVZART | CHAR | 1 | 0 | Target object type | ||
5 | ZOBJ | VVZOBJ | TEXT13 | CHAR | 13 | 0 | Target object | ||
6 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
7 | ABETR | VVABETR | WERT7 | CURR | 13 | 2 | Accepted amount | ||
8 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
9 | WRBTR | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
10 | VBEWA | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | * | |
11 | ZFBDT | DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
12 | PARTNR | BP_PARTNR_NEW | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
13 | PARTNAME | BP_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 (surname for persons, otherwise company name) | ||
14 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
15 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
16 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
17 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
18 | REBZT | REBZT | REBZT | CHAR | 1 | 0 | Follow-On Document Type | ||
19 | REBZJ | REBZJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of the Relevant Invoice (for Credit Memo) | ||
20 | REBZG | REBZG | BELNR | CHAR | 10 | 0 | Number of the Invoice the Transaction Belongs to | ||
21 | REBZZ | REBZZ | BUZEI | NUMC | 3 | 0 | Line Item in the Relevant Invoice | ||
22 | BATYP | VVBATYP | VVBATYP | CHAR | 2 | 0 | Processing category | * | |
23 | DTRANSREF | VVDTRANS | DATUM | DATS | 8 | 0 | Flow data key: System date | ||
24 | TTRANSREF | VVTTRANS | UZEIT | TIMS | 6 | 0 | Transaction data key: system time | ||
25 | NTRANSREF | VVNTRANS | NUMC4 | NUMC | 4 | 0 | Transaction data key: Consecutive number | ||
26 | ZLSCH | SCHZW_BSEG | ZLSCH | CHAR | 1 | 0 | Payment Method | * | |
27 | ZLSPR | DZLSPR | ZAHLS | CHAR | 1 | 0 | Payment Block Key | * | |
28 | PARTN | PARTN_EB | CHAR55 | CHAR | 55 | 0 | Business Partner | ||
29 | .INCLUDE | 0 | 0 | One-Time Account Data Document Segment | |||||
30 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
31 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
32 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
33 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
34 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
35 | NAME1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
36 | NAME2 | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
37 | NAME3 | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
38 | NAME4 | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
39 | PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
40 | ORT01 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
41 | LAND1 | LAND1_GP | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
42 | STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
43 | PFACH | PFACH | PFACH | CHAR | 10 | 0 | PO Box | ||
44 | PSTL2 | PSTL2 | PSTLZ | CHAR | 10 | 0 | P.O. Box Postal Code | ||
45 | PSKTO | PSKTO | PSKTO | CHAR | 16 | 0 | Account Number of Bank Account At Post Office | ||
46 | BANKN | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
47 | BANKL | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
48 | BANKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | T005 | |
49 | STCD1 | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
50 | STCD2 | STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
51 | STKZU | STKZU | XFELD | CHAR | 1 | 0 | Liable for VAT | ||
52 | STKZA | STKZA | STKZA | CHAR | 1 | 0 | Indicator: Business Partner Subject to Equalization Tax? | ||
53 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
54 | BKONT | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
55 | DTAWS | DTAWS | DTAWS | CHAR | 2 | 0 | Instruction key for data medium exchange | * | |
56 | DTAMS | DTAMS | DTAMS | CHAR | 1 | 0 | Report key for data medium exchange | ||
57 | XCPDK | XCPDK | XFELD | CHAR | 1 | 0 | Indicator: Is the account a one-time account? | ||
58 | EMPFG | EMPFG | EMPFG | CHAR | 16 | 0 | Payee code | ||
59 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
60 | FITYP | J_1AFITP_D | J_1AFITP | CHAR | 2 | 0 | Tax type | J_1AFITP | |
61 | STCDT | J_1ATOID | J_1ATOID | CHAR | 2 | 0 | Tax Number Type | J_1ATODC | |
62 | STKZN | STKZN | STKZN | CHAR | 1 | 0 | Natural Person | ||
63 | STCD3 | STCD3 | CHAR18 | CHAR | 18 | 0 | Tax Number 3 | ||
64 | STCD4 | STCD4 | CHAR18 | CHAR | 18 | 0 | Tax Number 4 | ||
65 | BKREF | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
66 | J_1KFREPRE | REPRES | REPRES | CHAR | 10 | 0 | Name of Representative | ||
67 | J_1KFTBUS | GESTYP | GESTYP | CHAR | 30 | 0 | Type of Business | BUSTYPE | |
68 | J_1KFTIND | INDTYP | INDTYP | CHAR | 30 | 0 | Type of Industry | INDUSTYPE | |
69 | ANRED | ANRED | TEXT15 | CHAR | 15 | 0 | Title | ||
70 | ADRNR | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
71 | XRGUH | XRGUH | XRGUH | CHAR | 1 | 0 | Indicator: Bank Details from REGUH | ||
72 | PO_BOX_NUM | AD_POBXNUM | XFELD | CHAR | 1 | 0 | Flag: PO Box without number | ||
73 | DDISPO | DDISPO | DATUM | DATS | 8 | 0 | Payment Date | ||
74 | DFAELL | DFAELLIG | DATUM | DATS | 8 | 0 | Due date/calculation date | ||
75 | BBWHR | BBWHR | WERTV7 | CURR | 13 | 2 | Amount in position currency | ||
76 | IBAN | BU_IBAN | CHAR34 | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
77 | .INCLUDE | 0 | 0 | SEPA Return Information | |||||
78 | TRANSID | TB_SEPA_TRANSID | CHAR | 35 | 0 | SEPA Transaction ID | |||
79 | RETURNKEY | TB_SEPA_RETCODES | CHAR | 6 | 0 | CML SEPA return codes | VDSEPA_RETCODE | ||
80 | RETURNRSN | TB_SEPA_RETRSN | CHAR | 4 | 0 | CML: SEPA Return Reasons | VDSEPA_RETRSN | ||
81 | POREF | TB_SEPA_PEREF | CHAR | 26 | 0 | SEPA Reference Field (Payment Engine) | |||
82 | PIREF | TB_SEPA_PEREF | CHAR | 26 | 0 | SEPA Reference Field (Payment Engine) | |||
83 | .INCLU-P | 0 | 0 | Payments: Key Fields | |||||
84 | MANDTP | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
85 | BUKRSP | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
86 | RANLP | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
87 | DTRANSP | VVDTRANS | DATUM | DATS | 8 | 0 | Flow data key: System date | ||
88 | TTRANSP | VVTTRANS | UZEIT | TIMS | 6 | 0 | Transaction data key: system time | ||
89 | NTRANSP | VVNTRANS | NUMC4 | NUMC | 4 | 0 | Transaction data key: Consecutive number | ||
90 | NVERFP | NVERF | NUM2 | NUMC | 2 | 0 | Disposal number within an outpayment | ||
91 | ZINKZ | DZINKZ | ZINKZ | CHAR | 2 | 0 | Exempted from Interest Calculation | ||
92 | .INCLUDE | 0 | 0 | SEPA Remittance Information | |||||
93 | REMIT_INFO | TB_REMIT_INFO | T_REMIT_INFO | CHAR | 140 | 0 | SEPA Payment Notes Information | ||
94 | .INCLU--AP | 0 | 0 | APPEND with Suspense Reason | |||||
95 | SUSP_REASON_TYPE | TB_SUSPREASON | T_SUSPREASON | NUMC | 3 | 0 | Key for Overpayment Reason | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VDZNV | BANKS | T005 | LAND1 | REF | 1 | CN |
2 | VDZNV | BUKRS | T001 | BUKRS | KEY | 1 | CN |
3 | VDZNV | FITYP | J_1AFITP | J_1AFITP | 1 | CN | |
4 | VDZNV | J_1KFTBUS | BUSTYPE | GESTYP | REF | C | CN |
5 | VDZNV | J_1KFTIND | INDUSTYPE | INDTYPE | REF | C | CN |
6 | VDZNV | LAND1 | T005 | LAND1 | REF | 1 | CN |
7 | VDZNV | MANDT | T000 | MANDT | KEY | 1 | CN |
8 | VDZNV | REGIO | T005S | BLAND | REF | C | CN |
9 | VDZNV | RETURNKEY | VDSEPA_RETCODE | RETURNKEY | |||
10 | VDZNV | RETURNRSN | VDSEPA_RETRSN | RETURNRSN | |||
11 | VDZNV | SPRAS | T002 | SPRAS | REF | C | CN |
12 | VDZNV | STCDT | J_1ATODC | J_1ATODC | 1 | CN |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |