1. Home
  2. Resources
  3. SAP Tables
  4. -

SAP Table

() is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link to other SAP tables.

table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EINRI Institution EINRI TN01 CHAR 4 0
SELID NSELID CHAR 7 0
KTEXT General Name KTEXT CHAR 20 0
SYBAK SYBAK CHAR 1 0
SYBSK SYBSK CHAR 1 0
TABAK TABAK CHAR 1 0
TABSK TABSK CHAR 1 0
TARIF IS-H: Service Catalog Identification Key TARID TNK01 CHAR 2 0
TALST Service in Service Catalog TARLS NTPK CHAR 10 0
BFORP IS-H: Valuation Formula for Extended Services BFORMEL CHAR 2 0
NULL No Valuation Formula
01 Patient Days (According to Midnight Patient Census)
02 Billing Days (according to BPflV Par.9 Section 2,3)
03 --- Obsolete. No longer use!----------------
04 Patient Days + Discharge Day
05 Service Days
06 Billing Days According to BPflV 1995
07 Service Days Without Discharge Day
10 Billing Days (Netherlands)
11 Patient Days Netherlandds (8 p.m. Rule)
20 Billing Days Austria 1 (as 02, but No 24 Hour Rule)
21 Billing Days Austria 2 (as 20, Including Discharge Day)
22 Billing Days Austria 3 (as 20, but Not Always Disch. Day)
30 CH Patient Days (Admission and Discharge Day, 24-Hour Rule)
31 CH Patient Days (as 30, but Not Always Admission Day)
32 CH Patient Days (as 30, but Not Always Discharge Day)
40 Patient Days (as 01 Except Deceased, 1-Day Stay)
Z0 Area for Customer-Defined Valuation Formulas
BFORB IS-H: Valuation Formula for Extended Services BFORMEL CHAR 2 0
NULL No Valuation Formula
01 Patient Days (According to Midnight Patient Census)
02 Billing Days (according to BPflV Par.9 Section 2,3)
03 --- Obsolete. No longer use!----------------
04 Patient Days + Discharge Day
05 Service Days
06 Billing Days According to BPflV 1995
07 Service Days Without Discharge Day
10 Billing Days (Netherlands)
11 Patient Days Netherlandds (8 p.m. Rule)
20 Billing Days Austria 1 (as 02, but No 24 Hour Rule)
21 Billing Days Austria 2 (as 20, Including Discharge Day)
22 Billing Days Austria 3 (as 20, but Not Always Disch. Day)
30 CH Patient Days (Admission and Discharge Day, 24-Hour Rule)
31 CH Patient Days (as 30, but Not Always Admission Day)
32 CH Patient Days (as 30, but Not Always Discharge Day)
40 Patient Days (as 01 Except Deceased, 1-Day Stay)
Z0 Area for Customer-Defined Valuation Formulas
VTRTY IS-H: Insurance Contract Scheme ISH_VTRTY TN16 CHAR 6 0
BTARI IS-H: Service Catalog Identification Key TARID TNK01 CHAR 2 0
BTALS Service in Service Catalog TARLS NTPK CHAR 10 0
FORAK NBEWLEI CHAR 1 0

foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TNA30A BTALS TNA30A MANDT NTPK IS-H: Header Data of Service Item MANDT
TNA30A BTALS TNA30A EINRI NTPK IS-H: Header Data of Service Item EINRI
TNA30A BTALS TNA30A BTARI NTPK IS-H: Header Data of Service Item TARIF
TNA30A BTALS TNA30A BTALS NTPK IS-H: Header Data of Service Item TALST
TNA30A BTARI TNA30A BTARI TNK01 IS-H: Service Catalog Types KATID
TNA30A BTARI TNA30A MANDT TNK01 IS-H: Service Catalog Types MANDT
TNA30A BTARI TNA30A EINRI TNK01 IS-H: Service Catalog Types EINRI
TNA30A EINRI TNA30A MANDT TN01 IS-H: Institutions MANDT
TNA30A EINRI TNA30A EINRI TN01 IS-H: Institutions EINRI
TNA30A MANDT TNA30A MANDT T000 Clients MANDT
TNA30A TALST TNA30A TARIF NTPK IS-H: Header Data of Service Item TARIF
TNA30A TALST TNA30A TALST NTPK IS-H: Header Data of Service Item TALST
TNA30A TALST TNA30A MANDT NTPK IS-H: Header Data of Service Item MANDT
TNA30A TALST TNA30A EINRI NTPK IS-H: Header Data of Service Item EINRI
TNA30A TARIF TNA30A MANDT TNK01 IS-H: Service Catalog Types MANDT
TNA30A TARIF TNA30A EINRI TNK01 IS-H: Service Catalog Types EINRI
TNA30A TARIF TNA30A TARIF TNK01 IS-H: Service Catalog Types KATID
TNA30A VTRTY TNA30A MANDT TN16 IS-H: Insurance Contract Schemes MANDT
TNA30A VTRTY TNA30A EINRI TN16 IS-H: Insurance Contract Schemes EINRI
TNA30A VTRTY TNA30A VTRTY TN16 IS-H: Insurance Contract Schemes VTRTY