SAP Table TN19B

IS-H: Certificate Types per Certificate Category

TN19B (IS-H: Certificate Types per Certificate Category) 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 TN19B to other SAP tables.

TN19B table fields

Field

Data element

Checktable

Datatype

Length

Decimals

MANDT

Client

MANDT

T000

CLNT

EINRI

Institution

EINRI

TN01

CHAR

KSTYP

IS-H: External Category of IV Document/Treatment Certificate

KS_TYP

TN19A

CHAR

KSART

IS-H: Type of IV Document/Treatment Certificate per Category

KS_ART

CHAR

SUNTG

IS-H: Certificate Subgroup (Int. Certif. Type PPA Billing)

SUNTG

CHAR

Possible values

NULL	Not Defined
00	Default SA 0101
20	Self-Referral
21	Target Order
22	Outline Order
23	2nd Opinion
24	Consultation/Treatment
25	Referral for Other Reasons
26	Inpatient Consultation
27	Referral/Billing Certificate for Laboratory Examination
28	Request Certificate for Laboratory Examinations by CL
30	Treatment by Ext. Physician
31	Consultation by Ext. Physician
32	Locum Tenency (Vacation and Illness) for Ext. Phy. Treatment
41	Emergency Department
42	Locum Tenency (Vacation/Illness)
43	Emergency Case
44	Emergency Service with Taxi Cab
45	Ambulance
46	Central Emergency Service
90	Direct Pat. Billing Default SA 0190
91	Direct Pat. Billing 2nd Opinion
92	Direct Pat. Billing Consultation Reimb. at Inp. Basic Rate
93	Direct Pat. Billing Consultation Reimb. at Outp. Basic Rate
94	Direct Pat. Billing Ext. Physician Treatment

TN19B foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
TN19B	EINRI	TN19B	MANDT	TN01	IS-H: Institutions	MANDT
TN19B	EINRI	TN19B	EINRI	TN01	IS-H: Institutions	EINRI
TN19B	KSTYP	TN19B	MANDT	TN19A	IS-H: Certificate Categories	MANDT
TN19B	KSTYP	TN19B	EINRI	TN19A	IS-H: Certificate Categories	EINRI
TN19B	KSTYP	TN19B	KSTYP	TN19A	IS-H: Certificate Categories	KSTYP
TN19B	MANDT	TN19B	MANDT	T000	Clients	MANDT