SAP ABAP Table VNVBRK (IS-H: Update Structure for NVBRK)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	VNVBRK	Table Relationship Diagram
Short Description	IS-H: Update Structure for NVBRK

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	IS-H: Billing document header data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	VBUK
4	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	TVFK
5	FKTYP	☐	ISH_FKTYP	ISH_FKTYP	CHAR	1	0	IS-H: Billing Category (Provisional, Final)
6	FKHKT	☐	ISH_FKHKT	ISH_FKHKT	CHAR	1	0	IS-H: Source of billing document
7	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
8	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
9	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
10	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
11	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
12	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
13	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
14	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
15	RFBSK	☐	RFBSK	RFBSK	CHAR	1	0	Status for transfer to accounting
16	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
17	CPKUR	☐	CPKUR	CPKUR	CHAR	1	0	ID:Exchange rate setting (no new rate determ.in bill.doc.)
18	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
19	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
20	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
21	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
22	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
23	LAND1	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
24	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
25	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
26	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
27	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
28	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer	*
29	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
30	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
31	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
32	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
33	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
34	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
35	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
36	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
37	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
38	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
39	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
40	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
41	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
42	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
43	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
44	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
45	SFAKN	☐	SFAKN	VBELN	CHAR	10	0	Cancelled billing document number	VBUK
46	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
47	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
48	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
49	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
50	HITYP_PR	☐	HITYP_PR	HITYP	CHAR	1	0	Hierarchy type for pricing	THIT
51	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	*
52	LANDTX	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country	*
53	XBLNR	☐	XBLNR_V1	XBLNR1	CHAR	16	0	Reference Document Number
54	ZUONR	☐	ORDNR_V	ZUONR	CHAR	18	0	Assignment Number
55	MWSBK	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
56	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
57	FKSTO	☐	ISH_FKSTO	ISH_FKSTO	CHAR	1	0	IS-H: Invoice Is Canceled (Fully/Partially)
58	EINRI	☐	EINRIF	EINRIF	CHAR	4	0	IS-H: Institution (Especially Required for Billing)
59	ORGID	☐	ORGID	ORGID	CHAR	8	0	IS-H: Organizational Unit Identification Key	*
60	FALAR	☐	FALLARTF	FALLART	CHAR	1	0	IS-H: Case Type
61	FALNR	☐	FALNRF	FALNRF	CHAR	10	0	IS-H: Case Number (Required for Billing)
62	KOSTR	☐	KH_KOSTRF	KH_KOSTRF	CHAR	10	0	IS-H: Insurance Provider
63	KTART	☐	KOSTR_ARTF	KOSTR_ARTF	CHAR	3	0	IS-H: Insurance Provider Type (e.g. Private, Statutory)
64	LFDVV	☐	LFDVV	LFDVV	NUMC	3	0	IS-H: Sequence Number of Insurance Relationship
65	DATZW	☐	ISH_ZWIABR_DAT	RI_DATUM	DATS	8	0	IS-H: Date up to which Interim Billing Is to Be Performed
66	SAMNR	☐	ISH_VBELNS	VBELN	CHAR	10	0	IS-H: Collective Invoice Number	*
67	FPKZF	☐	ISH_FPKZ	XFELD	CHAR	1	0	IS-H: Ind. whether the Case Has a Flat Rate (at Least 1)
68	SEKZF	☐	ISH_SEKZ	XFELD	CHAR	1	0	IS-H: Procedure Surcharge is Defined for Case (at Least 1)
69	AKRKZ	☐	ABRKZ_FK	ABRKZ_FK	CHAR	1	0	IS-H: Billing Indicator for Invoice
70	EMTYP	☐	ISH_EMTYPE	ISH_EMTYPE	CHAR	2	0	IS-H: Employee Type	*
71	LFDBEW	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement	*
72	ISHSTOID	☐	ISH_FAKSTOID	N1STOID	CHAR	3	0	IS-H: Reason for Canceling Billing Document	*
73	.INCLUDE	☐				0	0	IS-H SG: Header d
74	FALRN	☐	ISH_VBELNF	VBELN	CHAR	10	0	IS-H SG: Logical invoice number	*
75	RESID	☐	ISH_RESID	XFELD	CHAR	1	0	IS-H: Indicator that Patient is Non-Resident
76	.INCLUDE	☐				0	0	IS-H NL: Billing Document Header Data
77	KTARI	☐	ISH_KTARTI	ISH_KTARTI	CHAR	4	0	IS-H NL: Internal insurance provider type
78	ADINS	☐	ISH_ADINS	XFELD	CHAR	1	0	IS-H NL: Supplementary Insurance Indicator (NL)
79	FORNR	☐	ISH_FORNR	NUMC2	NUMC	2	0	Subsequent Invoice Number for Invoice Split
80	.INCLUDE	☐				0	0	Structures for generating change document update programs
81	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VNVBRK	BUKRS	T001	BUKRS	REF	1	CN
2	VNVBRK	CITYC	T005G	CITYC	REF	C	CN
3	VNVBRK	COUNC	T005E	COUNC	REF	C	CN
4	VNVBRK	FKART	TVFK	FKART	REF	1	CN
5	VNVBRK	HITYP_PR	THIT	HITYP	REF	C	CN
6	VNVBRK	KALSM	T683	KALSM	REF	1	CN
7	VNVBRK	KTGRD	TVKT	KTGRD	REF	C	CN
8	VNVBRK	KUNAG	KNA1	KUNNR	REF	1	CN
9	VNVBRK	KUNRG	KNA1	KUNNR	REF	1	CN
10	VNVBRK	KURST	TCURV	KURST	REF	C	CN
11	VNVBRK	LAND1	T005	LAND1	REF	C	CN
12	VNVBRK	MABER	T047M	MABER	REF	C	CN
13	VNVBRK	MANDT	T000	MANDT	KEY	1	CN
14	VNVBRK	MANSP	T040S	MANSP	REF	C	CN
15	VNVBRK	MSCHL	T040	MSCHL	REF	C	CN
16	VNVBRK	PLTYP	T189	PLTYP	REF	C	CN
17	VNVBRK	REGIO	T005S	BLAND	REF	C	CN
18	VNVBRK	SFAKN	VBUK	VBELN	REF	C	CN
19	VNVBRK	SPART	TSPA	SPART	REF	C	CN
20	VNVBRK	VBELN	VBUK	VBELN	KEY	1	C
21	VNVBRK	VKORG	TVKO	VKORG	REF	C	CN
22	VNVBRK	VTWEG	TVTW	VTWEG	REF	C	CN
23	VNVBRK	WAERK	TCURC	WAERS	REF	1	CN
24	VNVBRK	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in