SAP ABAP Table ISH_VBRK_DETAIL (IS-H: VBRK with Extra Details)

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	ISH_VBRK_DETAIL	Table Relationship Diagram
Short Description	IS-H: VBRK with Extra Details

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	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	☐	FKTYP	FKTYP	CHAR	1	0	Billing Category
6	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
7	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
8	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
9	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
10	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
11	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
12	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
13	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
14	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
15	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
16	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
17	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
18	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
19	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
20	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
21	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
22	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
23	EXPKZ	☐	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
24	RFBSK	☐	RFBSK	RFBSK	CHAR	1	0	Status for transfer to accounting
25	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
26	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
27	CPKUR	☐	CPKUR	CPKUR	CHAR	1	0	ID:Exchange rate setting (no new rate determ.in bill.doc.)
28	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
29	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
30	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
31	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
32	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
33	LAND1	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
34	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
35	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
36	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
37	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
38	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer	*
39	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
40	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
41	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
42	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
43	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
44	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
45	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
46	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
47	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
48	ZUKRI	☐	DZUKRI	CHAR40	CHAR	40	0	Combination criteria in the billing document
49	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
50	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
51	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
52	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
53	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
54	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
55	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
56	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
57	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	EIKP
58	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
59	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
60	SFAKN	☐	SFAKN	VBELN	CHAR	10	0	Cancelled billing document number	VBUK
61	KNUMA	☐	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)	KONA
62	FKART_RL	☐	FKART_RL	FKART	CHAR	4	0	Invoice list type	TVFK
63	FKDAT_RL	☐	FKDAT_RL	DATUM	DATS	8	0	Billing date for the invoice list
64	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
65	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
66	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
67	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
68	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
69	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
70	CMWAE	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area	TCURC
71	CMKUF	☐	CMKUF	KURRF	DEC	9	5	Credit data exchange rate at billing document rate
72	HITYP_PR	☐	HITYP_PR	HITYP	CHAR	1	0	Hierarchy type for pricing	THIT
73	BSTNK_VF	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
74	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
75	FKART_AB	☐	FKART_AB	FKART	CHAR	4	0	Accrual billing type	*
76	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	*
77	LANDTX	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country	*
78	STCEG_H	☐	STCEG_H	STCEG_H	CHAR	1	0	Origin of sales tax ID number
79	STCEG_L	☐	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number	*
80	XBLNR	☐	XBLNR_V1	XBLNR1	CHAR	16	0	Reference Document Number
81	ZUONR	☐	ORDNR_V	ZUONR	CHAR	18	0	Assignment Number
82	MWSBK	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
83	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
84	FKSTO	☐	FKSTO	XFELD	CHAR	1	0	Billing document is cancelled
85	XEGDR	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
86	RPLNR	☐	RPLNR	FPLNR	CHAR	10	0	Installment Plan Number	FPLA
87	LCNUM	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number	AKKP
88	J_1AFITP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITP
89	KURRF_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
90	AKWAE	☐	AKWAE	WAERS	CUKY	5	0	Currency key for letter-of-credit procg in foreign trade	TCURC
91	AKKUR	☐	AKKUR	KURRF	DEC	9	5	Exchange rate for letter-of-credit procg in foreign trade
92	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
93	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
94	NUMPG	☐	J_1ANOPG	J_1ANOPG	NUMC	3	0	Number of pages of invoice
95	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
96	VKONT	☐	CORR_VKONT_KK	CORR_VKONT_KK	CHAR	12	0	Contract Account Number
97	FKK_DOCSTAT	☐	DOCSTAT_KK	DOCSTAT_KK	CHAR	1	0	Additional Status Transfer to Fin. Accounting (Res. RFBSK)
98	NRZAS	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
99	SPE_BILLING_IND	☐	/SPE/DE_BILLING_IND	/SPE/DE_BILLING_IND	CHAR	1	0	EWM Billing Indicator
100	VTREF	☐	CORR_VTREF_KK	CORR_VTREF_KK	CHAR	20	0	Reference Specifications from Contract
101	FK_SOURCE_SYS	☐	FK_SOURCE_SYS	LOGSYS	CHAR	10	0	Source System	*
102	FKTYP_CRM	☐	FKTYP_CRM	FKTYP	CHAR	1	0	Billing Category in CRM
103	STGRD	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal	T041C
104	VBTYP_EXT	☐	TDD_VBTYP_EXT	DOM_VBTYP_EXT	CHAR	4	0	Extension of SD Document Category
105	.INCLU--AP	☐				0	0	VBRK append for Down Payment Chain
106	DPC_REL	☐	/SAPPCE/DPC_REL	CHAR01	CHAR	1	0	Flag: DPC relevant
107	.INCLU--AP	☐				0	0	VBRK_SEPA
108	.INCLUDE	☐				0	0	SEPA SD Struktur
109	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
110	PAY_TYPE	☐	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
111	SEPON	☐	SD_SEPA_FLAG	SD_SEPA_FLAG	CHAR	1	0	SEPA-Relevance
112	MNDVG	☐	SD_SEPA_FLAG	SD_SEPA_FLAG	CHAR	1	0	SEPA-Relevance
113	.INCLU--AP	☐				0	0	Append Structure for Special Paymenents
114	SPPAYM	☐	SPPAYM	SPPAYM	CHAR	2	0	Payment Form for Special Payment Method
115	SPPORD	☐	SPPORD	VBELN	CHAR	10	0	Sales Order for Special Payment Method	*
116	DRDAT	☐	ISH_DRDAT	DATUM	DATS	8	0	IS-H: Date Invoice Printed
117	EDIDAT	☐	ISH_EDIDAT	DATS	DATS	8	0	IS-H: EDI Transmission Date
118	DRUCK	☐	ISH_DRUCK	XFELD	CHAR	1	0	IS-H: Invoice Already Printed
119	ARCHIV	☐	ISH_ARCHIV	CHAR1	CHAR	1	0	IS-H: Invoice Has Been Archived
120	BRUWR	☐	ISH_BRUWR	ISH_WERTV6	CURR	11	2	IS-H: Gross Value of Billing Item in Document Currency
121	INVSTA	☐			CHAR	20	0
122	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
123	PROVBILL	☐			CHAR	1	0
124	WAERK_LOCAL	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
125	NETWR_LOCAL	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
126	BRUWR_LOCAL	☐	ISH_BRUWR	ISH_WERTV6	CURR	11	2	IS-H: Gross Value of Billing Item in Document Currency
127	STORN	☐			CHAR	1	0
128	AKTIV	☐	ISH_REAKTIV	CHAR01	CHAR	1	0	IS-H: Indicator for Active Invoice
129	KUNRG_NAME	☐	KZNAME	ISH_C12	CHAR	12	0	IS-H: Short Name of Business Partner
130	ANZU	☐	ISH_ANZU	ISH_ZUANZ	CHAR	1	0	IS-H: Indicator for Copayment/Down Payment
131	RFBSK_TXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
132	CLEARED	☐	ISH_CLEAR	CHAR01	CHAR	1	0	IS-H: Clearing of Receivables through Incoming Payments
133	STORN_TXT	☐	N1STOTX	N1C015	CHAR	15	0	Text for Cancellation Reason
134	LTEXT_ICON	☐			CHAR	30	0
135	KOSTR_NAME	☐	GPNAM1	NAME	CHAR	35	0	IS-H: Last Name/ 1st Name
136	.INCLUDE	☐				0	0	VBRK-Detailfelder
137	SEND_STAT	☐	NWAT_EDI_SEND_STAT	NWAT_EDI_ICON	CHAR	60	0	Sende-Status
138	SEND_LF301	☐	NWAT_EDI_SEND_LF301	ISH_LF301	NUMC	20	0	Versand-Nachrichtennummer	*
139	RECEIVE_STAT	☐	NWAT_EDI_RECEIVE_STAT	NWAT_EDI_ICON	CHAR	60	0	Empfang-Status
140	RECEIVE_DAT	☐	NWAT_EDI_RECEIVE_DAT	NWAT_EDI_DAT	DATS	8	0	Empfangs-Datum
141	RECEIVE_LF301	☐	NWAT_EDI_RECEIVE_LF301	ISH_LF301	NUMC	20	0	Empfang-Nachrichtennummer	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISH_VBRK_DETAIL	AKWAE	TCURC	WAERS	REF	1	CN
2	ISH_VBRK_DETAIL	BUKRS	T001	BUKRS	REF	1	CN
3	ISH_VBRK_DETAIL	BUPLA	J_1BBRANCH	BRANCH		C	CN
4	ISH_VBRK_DETAIL	BZIRK	T171	BZIRK	REF	C	CN
5	ISH_VBRK_DETAIL	CITYC	T005G	CITYC	REF	C	CN
6	ISH_VBRK_DETAIL	CMWAE	TCURC	WAERS	REF	C	CN
7	ISH_VBRK_DETAIL	COUNC	T005E	COUNC	REF	C	CN
8	ISH_VBRK_DETAIL	EXNUM	EIKP	EXNUM	REF	C	CN
9	ISH_VBRK_DETAIL	FKART	TVFK	FKART	REF	1	CN
10	ISH_VBRK_DETAIL	FKART_RL	TVFK	FKART	REF	C	CN
11	ISH_VBRK_DETAIL	HITYP_PR	THIT	HITYP	REF	C	CN
12	ISH_VBRK_DETAIL	INCO1	TINC	INCO1	REF	C	CN
13	ISH_VBRK_DETAIL	J_1AFITP	J_1AFITP	J_1AFITP		1	CN
14	ISH_VBRK_DETAIL	KALSM	T683	KALSM	REF	1	CN
15	ISH_VBRK_DETAIL	KDGRP	T151	KDGRP	REF	C	CN
16	ISH_VBRK_DETAIL	KKBER	T014	KKBER	REF	C	CN
17	ISH_VBRK_DETAIL	KNKLI	KNA1	KUNNR	REF	C	CN
18	ISH_VBRK_DETAIL	KNUMA	KONA	KNUMA	REF	C	CN
19	ISH_VBRK_DETAIL	KONDA	T188	KONDA	REF	C	CN
20	ISH_VBRK_DETAIL	KTGRD	TVKT	KTGRD	REF	C	CN
21	ISH_VBRK_DETAIL	KUNAG	KNA1	KUNNR	REF	1	CN
22	ISH_VBRK_DETAIL	KUNRG	KNA1	KUNNR	REF	1	CN
23	ISH_VBRK_DETAIL	KURST	TCURV	KURST	REF	C	CN
24	ISH_VBRK_DETAIL	LAND1	T005	LAND1	REF	C	CN
25	ISH_VBRK_DETAIL	LCNUM	AKKP	LCNUM		C	CN
26	ISH_VBRK_DETAIL	MABER	T047M	MABER	REF	C	CN
27	ISH_VBRK_DETAIL	MANDT	T000	MANDT	KEY	1	CN
28	ISH_VBRK_DETAIL	MANSP	T040S	MANSP	REF	C	CN
29	ISH_VBRK_DETAIL	MSCHL	T040	MSCHL	REF	C	CN
30	ISH_VBRK_DETAIL	PLTYP	T189	PLTYP	REF	C	CN
31	ISH_VBRK_DETAIL	REGIO	T005S	BLAND	REF	C	CN
32	ISH_VBRK_DETAIL	RPLNR	FPLA	FPLNR	REF	C	C
33	ISH_VBRK_DETAIL	SFAKN	VBUK	VBELN	REF	C	CN
34	ISH_VBRK_DETAIL	SPART	TSPA	SPART	REF	C	CN
35	ISH_VBRK_DETAIL	STGRD	T041C	STGRD		1	CN
36	ISH_VBRK_DETAIL	STWAE	TCURC	WAERS	REF	C	CN
37	ISH_VBRK_DETAIL	VBELN	VBUK	VBELN	KEY	1	C
38	ISH_VBRK_DETAIL	VBUND	T880	RCOMP	REF	C	CN
39	ISH_VBRK_DETAIL	VKORG	TVKO	VKORG	REF	C	CN
40	ISH_VBRK_DETAIL	VSBED	TVSB	VSBED	REF	C	CN
41	ISH_VBRK_DETAIL	VTWEG	TVTW	VTWEG	REF	C	CN
42	ISH_VBRK_DETAIL	WAERK	TCURC	WAERS	REF	1	CN
43	ISH_VBRK_DETAIL	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in