SAP VDSEPA_AUTODEB Records for new auto debit (SEPA direct debit) Table
Overview
VDSEPA_AUTODEB is a standard SAP S/4HANA table that stores Records for new auto debit (SEPA direct debit) data. There are total 41 fields in the VDSEPA_AUTODEB table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDSEPA_AUTODEB 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 VDSEPA_AUTODEB to other SAP tables and standard CDS views available based on VDSEPA_AUTODEB table in S/4HANA 2020.
Techincal Settings of VDSEPA_AUTODEB
Below are technical details of the table VDSEPA_AUTODEB
- Buffering allowed but switched off
- Full table is passed to buffer
- Storage type is Column Store
List of VDSEPA_AUTODEB Fields
The following table gives you an overview of the fields available in VDSEPA_AUTODEB
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| BUKRS | Company Code | BUKRS | CHAR | 4 | |
| RANL | Contract Number | RANL | CHAR | 13 | |
| REBZG | Accounting Document Number | BELNR_D | CHAR | 10 | |
| REBZZ | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | |
| REBZJ | Fiscal Year | GJAHR | NUMC | 4 | |
| SEQNR | Sequence Number | TB_NUMC3 | NUMC | 3 | |
| KUNNR | Customer Number | KUNNR | CHAR | 10 | |
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | |
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | |
| ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | |
| ZLSCH_OLD | Payment Method | DZLSCH | * | CHAR | 1 |
| RBELKPFD | Document Number of Document Header (Loan) | RBELKPFD | CHAR | 10 | |
| RPOSNR | Activity number | NVORGANG | CHAR | 3 | |
| SANLF | Product Category | SANLF | * | NUMC | 3 |
| GSART | Product Type | VVSART | CHAR | 3 | |
| PRODUCT_ID | Internal Product ID | TB_PR_PRODINT | * | CHAR | 18 |
| RKLAMMER | Classification Number for Finance Projects | RKLAMMER | CHAR | 13 | |
| FILL_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| FILL_USER | User Name | UNAME | CHAR | 12 | |
| FILL_RUNID | 16 Byte UUID in 16 Bytes (Raw Format) | SYSUUID_X16 | RAW | 16 | |
| FILL_TCODE | Transaction Code | TCODE | * | CHAR | 20 |
| CORR_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| CORR_USER | User Name | UNAME | CHAR | 12 | |
| CORR_RUNID | 16 Byte UUID in 16 Bytes (Raw Format) | SYSUUID_X16 | RAW | 16 | |
| CORR_COLLECTION_DATE | Payment Date | DDISPO | DATS | 8 | |
| REMOVE_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| REMOVE_USER | User Name | UNAME | CHAR | 12 | |
| REMOVE_RUNID | 16 Byte UUID in 16 Bytes (Raw Format) | SYSUUID_X16 | RAW | 16 | |
| UZAWE_OLD | Payment method supplement | UZAWE | * | CHAR | 2 |
| UZAWE_NEW | Payment method supplement | UZAWE | * | CHAR | 2 |
| ZLSPR_OLD | Payment Block Key | DZLSPR | * | CHAR | 1 |
| FLG_COMPLETION | Checkbox | XFELD | CHAR | 1 | |
| STATUS_REASON | Completion reason (new auto debit) | TB_NAD_STATUS_REASON | INT1 | 3 | |
| STATUS_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| STATUS_USER | User Name | UNAME | CHAR | 12 | |
| STATUS_RUNID | 16 Byte UUID in 16 Bytes (Raw Format) | SYSUUID_X16 | RAW | 16 | |
| STATUS_RSN_CUST | Completion reason (new auto debit) (customer specific) | TB_NAD_STATUS_REASON_CUST | * | INT1 | 3 |
| RPNSUP | Super prima nota for grouping in autom.deb.pos. | VVRPNSUP | CHAR | 10 |
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 VDSEPA_AUTODEB