VDSEPA_AUTODEB SAP (Records for new auto debit (SEPA direct debit)) Table details

Dictionary Type: Table
Description: Records for new auto debit (SEPA direct debit)




ABAP Code to SELECT data from VDSEPA_AUTODEB
Related tables to VDSEPA_AUTODEB
Access table VDSEPA_AUTODEB




Table field list including key, data, relationships and ABAP select examples

VDSEPA_AUTODEB is a standard SAP Table which is used to store Records for new auto debit (SEPA direct debit) data and is available within R/3 SAP systems depending on the version and release level.

The VDSEPA_AUTODEB table consists of various fields, each holding specific information or linking keys about Records for new auto debit (SEPA direct debit) data available in SAP. These include MANDT (Client), BUKRS (Company Code), RANL (Contract Number), REBZG (Accounting Document Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VDSEPA_AUTODEB table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
RANLContract Number RANLCHAR13ALPHARANLRAN
REBZGAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
REBZZNumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
REBZJFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
SEQNRSequence Number TB_NUMC3NUMC3NUMC3
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUDATPosting Date in the Document BUDATDATS8DATUM
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
ZLSCH_OLDPayment Method DZLSCHCHAR1Assigned to domainZLSCH
RBELKPFDDocument Number of Document Header (Loan) RBELKPFDCHAR10ALPHARBELKPFD
RPOSNRActivity number NVORGANGCHAR3CHAR3
SANLFProduct Category SANLFNUMC3Assigned to domainVVSANLF
GSARTProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
PRODUCT_IDInternal Product ID TB_PR_PRODINTCHAR18Assigned to domainT_PR_PRODINT
RKLAMMERClassification Number for Finance Projects RKLAMMERCHAR13ALPHARANL
FILL_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
FILL_USERUser Name UNAMECHAR12UNAME
FILL_RUNID16 Byte UUID in 16 Bytes (Raw Format) SYSUUID_X16RAW16SYSUUID_X16
FILL_TCODETransaction Code TCODECHAR20Assigned to domainTCODETCD
CORR_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
CORR_USERUser Name UNAMECHAR12UNAME
CORR_RUNID16 Byte UUID in 16 Bytes (Raw Format) SYSUUID_X16RAW16SYSUUID_X16
CORR_COLLECTION_DATEPayment Date DDISPODATS8DATUM
REMOVE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
REMOVE_USERUser Name UNAMECHAR12UNAME
REMOVE_RUNID16 Byte UUID in 16 Bytes (Raw Format) SYSUUID_X16RAW16SYSUUID_X16
UZAWE_OLDPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
UZAWE_NEWPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
ZLSPR_OLDPayment Block Key DZLSPRCHAR1Assigned to domainZAHLSSPE
FLG_COMPLETIONCheckbox XFELDCHAR1XFELD
STATUS_REASONCompletion reason (new auto debit) TB_NAD_STATUS_REASONINT13TB_NAD_STATUS_REASON_DOM
STATUS_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
STATUS_USERUser Name UNAMECHAR12UNAME
STATUS_RUNID16 Byte UUID in 16 Bytes (Raw Format) SYSUUID_X16RAW16SYSUUID_X16

Key field Non-key field



How do I retrieve data from SAP table VDSEPA_AUTODEB using ABAP code

The following ABAP code Example will allow you to do a basic selection on VDSEPA_AUTODEB to SELECT all data from the table
DATA: WA_VDSEPA_AUTODEB TYPE VDSEPA_AUTODEB.

SELECT SINGLE *
FROM VDSEPA_AUTODEB
INTO CORRESPONDING FIELDS OF WA_VDSEPA_AUTODEB
WHERE...

How to access SAP table VDSEPA_AUTODEB

Within an ECC or HANA version of SAP you can also view further information about VDSEPA_AUTODEB and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!