SAP ABAP Table ISA_DOC_RESULT (View: Order Items for Material)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ WEC-APP-SLS-ERP (Application Component) WebChannel Sales using ERP-SD
     ⤷ ISA_R3 (Package) Internet Sales R/3

Basic Data

Table Category	INTTAB	Structure
Structure	ISA_DOC_RESULT	Table Relationship Diagram
Short Description	View: Order Items for Material

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	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
2	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
3	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
4	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
5	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
6	DATAB	☐	DATAB_VI	DATUM	DATS	8	0	Quotation or contract valid from
7	DATBI	☐	DATBI_VI	DATUM	DATS	8	0	Quotation or contract valid to
8	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
10	NETWR_AK	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
11	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
12	STATUS	☐	STATUS_VB	STATV	CHAR	1	0	Status of the document
13	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
14	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
15	KTEXT	☐	KTEXT_V	TEXT40	CHAR	40	0	Search term for product proposal
16	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
17	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	TVAG
18	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
19	VLAUFZ	☐	VLAUF_VEDA	NUM3	NUMC	3	0	Contract Term
20	VLAUEZ	☐	VLAUE_VEDA	KDZEH	CHAR	1	0	Unit of validity period of contract
21	VKUEGRU	☐	VKGRU_VEDA	KUEGRU	CHAR	2	0	Reason for cancellation of contract	*
22	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
23	.INCLUDE	☐				0	0	Statuses for document search results(subset of VBUK)
24	RFSTK	☐	RFSTK	STATV	CHAR	1	0	Reference document header status
25	RFGSK	☐	RFGSK	STATV	CHAR	1	0	Total reference status of all items
26	LFSTK	☐	LFSTK	STATV	CHAR	1	0	Delivery status
27	LFGSK	☐	LKGSK	STATV	CHAR	1	0	Overall delivery status for all items
28	WBSTK	☐	WBSTK	STATV	CHAR	1	0	Total goods movement status
29	FKSTK	☐	FKSTK	STATV	CHAR	1	0	Billing status
30	FKSAK	☐	FKSAK	STATV	CHAR	1	0	Billing status (order-related billing document)
31	BUCHK	☐	BUCHK	STATV	CHAR	1	0	Posting Status of Billing Document
32	ABSTK	☐	ABSTK	STATV	CHAR	1	0	Overall rejection status of all sales document items
33	GBSTK	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
34	KOSTK	☐	KOSTK	STATV	CHAR	1	0	Overall picking / putaway status
35	UVALS	☐	UVALL_SU	STATV	CHAR	1	0	Total incompletion status of all items in general
36	UVVLS	☐	UVVLS_SU	STATV	CHAR	1	0	Total incompletion status of all items: Delivery
37	UVFAS	☐	UVFAK_SU	STATV	CHAR	1	0	Total incompletion status of all items: Billing
38	UVALL	☐	UVALL_UK	STATV	CHAR	1	0	General incompletion status of the header
39	PKSTK	☐	PKSTK	STATV_PKST	CHAR	1	0	Overall packing status of all items
40	KOQUK	☐	KOQUK	STATV	CHAR	1	0	Status of pick confirmation
41	UVPAS	☐	UVPAK_SU	STATV	CHAR	1	0	Totals incomplete status for all items: packaging
42	UVPIS	☐	UVPIK_SU	STATV	CHAR	1	0	Totals incomplete status for all items: Picking
43	UVWAS	☐	UVWAK_SU	STATV	CHAR	1	0	Total incomplete status of all items: post goods movement
44	DCSTK	☐	DCSTK	STATV	CHAR	1	0	Delay status
45	FSSTK	☐	FSSTK	STATV	CHAR	1	0	Overall billing block status
46	LSSTK	☐	LSSTK_G	STATV	CHAR	1	0	Overall delivery block status
47	SPSTG	☐	SPSTG	STATV	CHAR	1	0	Overall blocked status
48	PDSTK	☐	PDSTK	STATV	CHAR	1	0	POD status on header level

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISA_DOC_RESULT	ABGRU	TVAG	ABGRU
2	ISA_DOC_RESULT	AUART	TVAK	AUART
3	ISA_DOC_RESULT	AUGRU	TVAU	AUGRU
4	ISA_DOC_RESULT	KUNNR	KNA1	KUNNR
5	ISA_DOC_RESULT	MATNR	MARA	MATNR
6	ISA_DOC_RESULT	SPART	TSPA	SPART
7	ISA_DOC_RESULT	VBELN	VBUK	VBELN
8	ISA_DOC_RESULT	VKORG	TVKO	VKORG
9	ISA_DOC_RESULT	VTWEG	TVTW	VTWEG

History

Last changed by/on	SAP	20130529
SAP Release Created in	2005_1_46C