T5BSD SAP (SI Declaration: directory table) Table details
Dictionary Type: Table
Description: SI Declaration: directory table
Description: SI Declaration: directory table
Table field list including key, data, relationships and ABAP select examples
T5BSD is a standard SAP Table which is used to store SI Declaration: directory table data and is available within R/3 SAP systems depending on the version and release level.
The T5BSD table consists of various fields, each holding specific information or linking keys about SI Declaration: directory table data available in SAP. These include DECID (SI Declaration identifier), DYEAR (Year the declaration refers to), DQART (Quarter the declaration refers to), DSQNR (Sequence number per declaration step).. 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: Cannot Be Enhanced
SAP T5BSD 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
DECID | SI Declaration identifier | P12_DECID | NUMC | 6 | NUM06 | ||||
DYEAR | Year the declaration refers to | P12_DYEAR | NUMC | 4 | NUMC4 | ||||
DQART | Quarter the declaration refers to | P12_DQART | NUMC | 1 | NUMC1 | ||||
DSQNR | Sequence number per declaration step | P12_DSQNR | NUMC | 2 | Assigned to domain | BSEQF | |||
DSTAT | Status SI declaration | P12_DSTAT | CHAR | 1 | P12_DSTAT | ||||
CDATE | Creation date SI declaration | P12_CDATE | DATS | 8 | DATS | ||||
CTIME | Time Creation SI declaration | 0 | |||||||
RDATE | Release date SI declaration | P12_RDATE | DATS | 8 | DATS | ||||
RTIME | Time Release SI declaration | 0 | |||||||
DDATE | Rejection date SI declaration | P12_DDATE | DATS | 8 | DATS | ||||
DTIME | Time Rejection SI declaration | 0 | |||||||
ADATE | Acceptance date SI declaration | P12_ADATE | DATS | 8 | DATS | ||||
ATIME | Time Acceptance SI declaration | 0 | |||||||
SDATE | Selection date payroll results in SI declaration | P12_SDATE | DATS | 8 | DATS | ||||
ADMIN | User Name in User Master Record | XUBNAME | CHAR | 12 | Assigned to domain | XUBNAME | XUS | ||
STREF | Reference pointing to the detailed declaration info | P12_STREF | NUMC | 3 | P12_STREF | ||||
ONECO | Corrective declarations limited to one | P12_ONECO | CHAR | 1 | CHAR1 |
Key field | Non-key field |
How do I retrieve data from SAP table T5BSD using ABAP code
The following ABAP code Example will allow you to do a basic selection on T5BSD to SELECT all data from the tableDATA: WA_T5BSD TYPE T5BSD.
SELECT SINGLE *
FROM T5BSD
INTO CORRESPONDING FIELDS OF WA_T5BSD
WHERE...
How to access SAP table T5BSD
Within an ECC or HANA version of SAP you can also view further information about T5BSD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects