SAP ABAP Table NKSP (IS-H: Insurance verification/certificate - item data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NPVS (Package) Application development patient management system

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	NKSP	Table Relationship Diagram
Short Description	IS-H: Insurance verification/certificate - item data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BELNR	☑	KS_BELNR	KS_BELNR	CHAR	10	0	IS-H: Document Number of IV Document/Treatment Certificate	NKSK
3	POSNR	☑	KS_POSNR	KS_POSNR	NUMC	4	0	Item Number per Insurance Verification/Certificate
4	TARID	☐	TARID	TARID	CHAR	2	0	IS-H: Service Catalog Identification Key	TNK01
5	LEIID	☐	TARLS	TARLS	CHAR	10	0	IS-H: Service in Service Catalog	*
6	KOSTR	☐	KH_KOSTR	RI_KUNNR	CHAR	10	0	IS-H: Insurance Provider	*
7	LFDNR	☐	LFDVV	LFDVV	NUMC	3	0	IS-H: Sequence Number of Insurance Relationship
8	BEGDT	☐	KS_BEGDP	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Item
9	ENDDT	☐	KS_ENDDP	RI_DATUM	DATS	8	0	IS-H: Valid-To Date of Item
10	PSTAT	☐	KS_PSTAT	KS_PSTAT	CHAR	1	0	IS-H: Processing Status of Insurance Verification Item
11	ABGDT	☐	KS_PABDT	KS_ABGDT	DATS	8	0	IS-H: Date when Item Was Completed
12	UEBAB	☐	KS_UEBAB	XFELD	CHAR	1	0	IS-H: Ind. Whether Coverage of Service Is Rejected
13	KTEXT	☐	KS_PTEXT	TEXT30	CHAR	30	0	IS-H: Comment on item IV/certificate (no long text call up)
14	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
15	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
16	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
17	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
18	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
19	VBEGD	☐	ISHZUBEGDP	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Item
20	VENDD	☐	ISHZUENDDP	RI_DATUM	DATS	8	0	IS-H: Valid-To Date of Item
21	VPROZ	☐	ISHZUANTEI	KS_ANTEI	DEC	5	2	IS-H: Rate of Coverage per Item
22	VPREIS	☐	ISHZUBTRAG	ISH_WERTV6	CURR	11	2	IS-H: Total Amount of Coverage Confirmed
23	VMENGE	☐	ISHZUMENGE	LEISMENGE	NUMC	4	0	IS-H: Maximum quantity of confirmation of coverage
24	VBTRAG	☐	ISHZUBTRAG	ISH_WERTV6	CURR	11	2	IS-H: Total Amount of Coverage Confirmed
25	KPROZ	☐	KS_ANTEI	KS_ANTEI	DEC	5	2	IS-H: Coverage Rate per Item of IV/Treatment Certificate
26	KBTRAG	☐	KS_BTRAG	ISH_WERTV6	CURR	11	2	Total Amount Covered
27	KPREIS	☐	KS_PREIS	ISH_WERTV6	CURR	11	2	IS-H: Maximum Price for Insurance Coverage
28	KMENGE	☐	KS_MENGE	LEISMENGE	NUMC	4	0	IS-H: Maximum Quantity Covered
29	REST	☐	KZ_REST	XFELD	CHAR	1	0	IS-H: Ind. Rem. for Rounding Errors/Ins. Coverage IV Request
30	SEKZ	☐	KS_SEKZ	XFELD	CHAR	1	0	IS-H: Self-Payer Indicator (Insurance Verification)
31	TGRKZ	☐	TGRU_KZ	XFELD	CHAR	1	0	IS-H: Indicator Denoting a Service Group
32	TCODE	☐	ISH_TCODE	TCODE	CHAR	20	0	IS-H: Report Control: Transaction Code for Application	*
33	ABLGR	☐	ISH_ABGRU	ISH_ABGRU	CHAR	2	0	IS-H AT: Reason for Rejection	TN19G
34	REFNR	☐	NKSP_REFNR	NKSP_REFNR	CHAR	20	0	IS-H: Reference field of an IV item (external reference)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	NKSP	ABLGR	TN19G	ABLGR	REF	C	CN
2	NKSP	BELNR	NKSK	BELNR	KEY	1	CN
3	NKSP	MANDT	T000	MANDT	KEY	1	CN
4	NKSP	TARID	TNK01	KATID

History

Last changed by/on	SAP	20050224
SAP Release Created in