T7SKA1 SAP (External transfers) Table details

Dictionary Type: Table
Description: External transfers




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




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

T7SKA1 is a standard SAP Table which is used to store External transfers data and is available within R/3 SAP systems depending on the version and release level.

The T7SKA1 table consists of various fields, each holding specific information or linking keys about External transfers data available in SAP. These include LAUFD (Date on Which the Program Is to Be Run), LAUFI (Additional Identification), PERNR (Personnel Number), BTZNR (Sequence number (four characters)).. 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 T7SKA1 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 MANDTCLNT3T000MANDT
LAUFDDate on Which the Program Is to Be Run LAUFDDATS8DATUM
LAUFIAdditional Identification LAUFICHAR6LAUFI
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
BTZNRSequence number (four characters) PSK_LFDNR4NUMC4NUMC4
PERIDPersonnel ID Number PRDNICHAR20CHAR20
NACHNLast Name NACHNCHAR25NACHN
VORNAFirst Name VORNACHAR25VORNM
ABKRSPayroll Area ABKRSCHAR2Assigned to domainABKRSABK
JUPERLegal Person JUPERCHAR4JUPER
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
WERKSPersonnel Area PERSACHAR4T500PPERSAPBR
BTRTLPersonnel Subarea BTRTLCHAR4T001PBTRTLPBS
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PERSGEmployee Group PERSGCHAR1T501PERSGPRG
PERSKEmployee Subgroup PERSKCHAR2T503KPERSKPKR
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
VDSK1Organizational Key VDSK1CHAR14Assigned to domainVDSK1
VBAFMType of investment/asset for capital formation VBAFMCHAR1Assigned to domainVBAFM
SEQNRSequential number of cluster directory SEQN0DEC5DEC5
SACHAPayroll Administrator SACHACHAR3SACHA
LGARTWage Type LGARTCHAR4T512WLGART
BETRGWage Type Amount for Payments PAD_AMT7SCURR13(2) P_AMT07V
FBETRHR payroll: Maximum amount PRBETCURR9(2) BETRG
ZLSCHPayment Method DZLSCHCHAR1T042ZZLSCH
EMFSLPayee key for bank transfers EMFSL_521BCHAR8T521BEMFSL_521B
EMFTXPayee Text EMFTXCHAR40TEXT40
CTRANCollective transfer CTRANCHAR1XFELD
BKONTBank Control Key BKONTCHAR2BKONT
BANKSCountry Key LAND1CHAR3T005LAND1LND
BANKLBank number BANKLCHAR15BANKLBLZ
BANKNBank account number BANKNCHAR18BANKN
BKPLZPostal Code BKPLZCHAR10PSTLZ
STRASHouse number and street STRASCHAR30TEXT30
BKORTCity ORT01CHAR25TEXT25
PSKTOAccount Number of Bank Account At Post Office PSKTOCHAR16PSKTO
ESRNRISR Subscriber Number ESRNRCHAR11ESRNR
ESRREISR Reference Number ESRRECHAR27ALPHAESRRE
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
ZWECKPurpose of Bank Transfers DZWECKCHAR40TEXT40
MODIF3Modif 3 for transfer to FI*CO PSK_MODI3CHAR1CHAR1
FI_CO1Symbolic account PSK_FI_COCHAR2CHAR2
SUCET1Symbolic account FI/CO PSK_SUCETCHAR2CHAR2
FI_CO2Symbolic account PSK_FI_COCHAR2CHAR2
SUCET2Symbolic account FI/CO PSK_SUCETCHAR2CHAR2
FI_CO3Symbolic account PSK_FI_COCHAR2CHAR2
SUCET3Symbolic account FI/CO PSK_SUCETCHAR2CHAR2
PR_BANKNHR CZ - Non cumulative account PSK_BUCETCHAR10CHAR10
PR_ESRRESubAccount PSK_PUCETCHAR10CHAR10
PR_JMENOC/O Name CONAMCHAR25NACHN
PR_ULICEHouse number and street STRASCHAR30TEXT30
PR_CORIENTHouse Number HSNMRNUMC6NUMC6
PR_CPOPISIdentification of an Apartment in a Building POSTACHAR6TEXT6
PR_UCEL2nd Address Line LOCATCHAR30TEXT30
PR_PSCPostal Code PSTLZCHAR10PSTLZ
PR_OBECCity ORT01CHAR25TEXT25
PR_CASTOBCDistrict ORT02CHAR25TEXT25
PR_STATCountry Key LAND1CHAR3T005LAND1LND
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
PLATNYIndicator: active/inactive AKTKNCHAR1CHAR1
IBANIBAN (International Bank Account Number) IBANCHAR34IBAN

Key field Non-key field



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

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

SELECT SINGLE *
FROM T7SKA1
INTO CORRESPONDING FIELDS OF WA_T7SKA1
WHERE...

How to access SAP table T7SKA1

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