T5T1L SAP (Bank accounts of authorities (tax,insurance)) Table details

Dictionary Type: Table
Description: Bank accounts of authorities (tax,insurance)




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




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

T5T1L is a standard SAP Table which is used to store Bank accounts of authorities (tax,insurance) data and is available within R/3 SAP systems depending on the version and release level.

The T5T1L table consists of various fields, each holding specific information or linking keys about Bank accounts of authorities (tax,insurance) data available in SAP. These include TXTYP (Output options), KVSFR (Health insurance key for compulsory HI fund), KVGST (Health insurance fund - branch office), BUKRS (Company Code).. 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: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP T5T1L 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
TXTYPOutput options SORT_SUMCHAR4CHAR4
KVSFRHealth insurance key for compulsory HI fund P18_KVSCHCHAR8Assigned to domainP18_KVSCH
KVGSTHealth insurance fund - branch office P18_KVGSTCHAR6P18_KVGST
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
WERKSPersonnel Area PERSACHAR4Assigned to domainPERSAPBR
BTRTLPersonnel Subarea BTRTLCHAR4Assigned to domainBTRTLPBS
BANKSBank country key BANKSCHAR3Assigned to domainLAND1BKL
BANKLBank number BANKLCHAR15BANKLBLZ
BANKNBank account number BANKNCHAR18BANKN
PSKTOAccount Number of Bank Account At Post Office PSKTOCHAR16PSKTO
ESRNRISR Subscriber Number ESRNRCHAR11ESRNR
ESRREISR Reference Number ESRRECHAR27ALPHAESRRE
ZLSCHPayment Method PCODECHAR1Assigned to domainZLSCH
ZBUKRPaying company code DZBUKRCHAR4Assigned to domainBUKRS
HKTIDID for account details HKTIDCHAR5Assigned to domainHKTID
HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
ABWAESettlement currency for bank transfers ABWAECUKY5Assigned to domainWAERS
ANARTAddress Type ANARTCHAR2CHAR2
VARGULayout rule for address type VARGACHAR8VARGA
ANOWNAddress Type ANARTCHAR2CHAR2
VAOWNLayout rule for address type VARGACHAR8VARGA
KOMOKTransfer to FI/CO: Symbolic Account P_KOMOK40CHAR4Assigned to domainP_KOMOK40
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
IDENTReported identification - pension savings P18_PENSAV_IDENTCHAR4P18_PENSAV_IDENTHRCZ_P18_PENSAV_IDENT

Key field Non-key field



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

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

SELECT SINGLE *
FROM T5T1L
INTO CORRESPONDING FIELDS OF WA_T5T1L
WHERE...

How to access SAP table T5T1L

Within an ECC or HANA version of SAP you can also view further information about T5T1L 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!