SAP ABAP Table OIASCC (Document Header View for Billing)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIA (Package) Exg exchanges

Basic Data

Table Category	INTTAB	Structure
Structure	OIASCC	Table Relationship Diagram
Short Description	Document Header View for Billing

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	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
2	BALANCE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
3	DATUM	☐	DATUM	DATUM	DATS	8	0	Date
4	SPRAS_VKO	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
5	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
6	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
7	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
8	MESSAGE	☐	OIA_MESS18	CHAR18	CHAR	18	0	Message data element
9	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
10	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
11	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
12	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
13	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
14	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
15	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
16	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
17	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
18	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
19	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
20	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
21	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
22	TEXT	☐	CHAR80	CHAR80	CHAR	80	0	Char 80
23	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
24	SLAND	☐	SLAND	LAND1	CHAR	3	0	Sending country for processing address	*
25	.INCLUDE	☐				0	0	Exchange Statement Print Requests
26	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
27	PREQNO	☐	OIA_PREQNO	OIA_PREQNO	CHAR	10	0	Exchange statement print request document number
28	NETDOC	☐	OIA_NETDOC	XFELD	CHAR	1	0	Movement-based netting document
29	PREQTYP	☐	OIA_PREQTY	FKART	CHAR	4	0	Exchange statement print request document type	TVFK
30	EXGPTR	☐	OIA_EXGPTR	LIFNR	CHAR	10	0	Exchange partner (vendor number)	LFA1
31	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
32	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
33	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
34	WAERS	☐	OIA_DWAERS	WAERS	CUKY	5	0	Currency for exchange statement	TCURC
35	VEXGNUM	☐	OIA_VEXNUM	OIA_EXGNUM	CHAR	10	0	From exchange agreement number	OIA01
36	BEXGNUM	☐	OIA_BEXNUM	OIA_EXGNUM	CHAR	10	0	To exchange agreement number	OIA01
37	VEXGTYP	☐	OIA_VEXTYP	OIA_EXGTYP	CHAR	4	0	From exchange type	TOIA2
38	BEXGTYP	☐	OIA_BEXTYP	OIA_EXGTYP	CHAR	4	0	To exchange type	TOIA2
39	VMATREF	☐	OIA_VMATRF	OIA_MATREF	CHAR	20	0	From mat. group reference for exchange balance reporting
40	BMATREF	☐	OIA_BMATRF	OIA_MATREF	CHAR	20	0	To - mat. group reference for exchange balance reporting
41	VMATNR	☐	OIA_VMATNR	MATNR	CHAR	18	0	From material number	MARA
42	BMATNR	☐	OIA_BMATNR	MATNR	CHAR	18	0	To material number	MARA
43	VOIBASPROD	☐	OIA_VSBMAT	MATNR	CHAR	18	0	From base product number	*
44	BOIBASPROD	☐	OIA_BSBMAT	MATNR	CHAR	18	0	To base product number	*
45	VWERKS	☐	OIA_VWERKS	WERKS	CHAR	4	0	From plant	T001W
46	BWERKS	☐	OIA_BWERKS	WERKS	CHAR	4	0	To plant	T001W
47	VSPMON	☐	OIA_VSPMON	RSCALMONTH	NUMC	6	0	From period to analyze - month
48	BSPMON	☐	OIA_BSPMON	RSCALMONTH	NUMC	6	0	To period to analyze - month
49	VSPTAG	☐	OIA_VSPTAG	DATUM	DATS	8	0	From period to analyze -daytime reference
50	BSPTAG	☐	OIA_BSPTAG	DATUM	DATS	8	0	To period to analyze - day
51	VSPWOC	☐	OIA_VSPWOC	MCPERIOD	NUMC	6	0	From period to analyze - week
52	BSPWOC	☐	OIA_BSPWOC	MCPERIOD	NUMC	6	0	To period to analyze - week
53	VSPBUP	☐	OIA_VSPBUP	MCPERIOD	NUMC	6	0	From period to analyze - posting period
54	BSPBUP	☐	OIA_BSPBUP	MCPERIOD	NUMC	6	0	To period to analyze - posting period
55	DOCSTAT	☐	OIA_DOCSTA	OIA_DOCSTA	CHAR	1	0	Exchange - netting document status
56	NJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
57	MAPPE	☐	MAPPE	MAPPE	CHAR	12	0	Session name
58	BICNT	☐	OIA_BICNT	OIA_BICNT	DEC	6	0	Counter created batch inputs per netting document
59	NETBAL	☐	OIA_NETBAL	WERT7	CURR	13	2	Net balance check TOTAL
60	.INCLUDE	☐				0	0	Date, time and name of creation and change in txn-data
61	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
62	ERTIM	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
63	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
64	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
65	AETIM	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
66	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
67	.INCLUDE	☐				0	0	Invoice cycle included indicator active 1-n (grouped)
68	OIINVCYC1	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
69	OIINVCYC2	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
70	OIINVCYC3	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
71	OIINVCYC4	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
72	OIINVCYC5	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
73	OIINVCYC6	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
74	OIINVCYC7	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
75	OIINVCYC8	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
76	OIINVCYC9	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
77	OIINCLIA	☐	OIA_INCLIA	KREUZ	CHAR	1	0	LIA included indicator (X/ )
78	OIINCPFA	☐	OIA_INCPFA	KREUZ	CHAR	1	0	PFA included indicator (X/ )
79	DISPME	☐	OIA_OUTMEI	MEINS	UNIT	3	0	Output unit of measure (for exchange and netting statement)	T006
80	OIAMWOFI	☐	OIA_MWOFI	OI0_SELKZ	CHAR	1	0	Movements without financials indicator
81	OIABALAN	☐	OIA_BALAN	OI0_SELKZ	CHAR	1	0	Include balances indicator
82	.INCLUDE	☐				0	0	Customer defined fields for heading section of exg report
83	PDUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIASCC	BEXGNUM	OIA01	EXGNUM	KEY	1	CN
2	OIASCC	BEXGTYP	TOIA2	EXGTYP	KEY	1	CN
3	OIASCC	BMATNR	MARA	MATNR	REF	1	CN
4	OIASCC	BWERKS	T001W	WERKS	KEY	1	CN
5	OIASCC	DISPME	T006	MSEHI
6	OIASCC	EXGPTR	LFA1	LIFNR	KEY	1	CN
7	OIASCC	LAND1	T005	LAND1
8	OIASCC	MANDT	T000	MANDT	KEY	1	CN
9	OIASCC	PREQTYP	TVFK	FKART	KEY	1	CN
10	OIASCC	REGIO	T005S	BLAND
11	OIASCC	SPART	TSPA	SPART	REF	1	CN
12	OIASCC	SPRAS_VKO	T002	SPRAS
13	OIASCC	VEXGNUM	OIA01	EXGNUM	KEY	1	CN
14	OIASCC	VEXGTYP	TOIA2	EXGTYP	KEY	1	CN
15	OIASCC	VKORG	TVKO	VKORG	REF	1	CN
16	OIASCC	VMATNR	MARA	MATNR	REF	1	CN
17	OIASCC	VTWEG	TVTW	VTWEG	REF	1	CN
18	OIASCC	VWERKS	T001W	WERKS	KEY	1	CN
19	OIASCC	WAERK	TCURC	WAERS
20	OIASCC	WAERS	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in