SAP ABAP Table S008 (Communications Table SD -> CO/Projects)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S008	Table Relationship Diagram
Short Description	Communications Table SD -> CO/Projects

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	*
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
9	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
10	ETENR	☑	ETENR	ETENR	NUMC	4	0	Schedule line	VBEP
11	FPLNR	☑	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	*
12	FPLTR	☑	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards	*
13	KSCHL	☑	KSCHA	KSCHL	CHAR	4	0	Condition Type	*
14	STUNR	☑	STUNR	STUNR	NUMC	3	0	Level Number	*
15	ZAEHK	☑	DZAEHK	ZAEHK	NUMC	2	0	Condition counter
16	ALTNEU	☑	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
17	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	*
18	FKTYP	☐	FKTYP	FKTYP	CHAR	1	0	Billing Category
19	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
20	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
21	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
22	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
23	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
24	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
25	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
26	ANGDT	☐	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
27	BNDDT	☐	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
28	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
29	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
30	SKFBT	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
31	ABSTA	☐	ABSTA	ABSTA	CHAR	1	0	Release status (current release, old release)
32	ERLMENGE_L	☐	ERLMENGE_L	MENG13	QUAN	13	3	Completed quantity (delivery)
33	ERLMENGE_F	☐	ERLMENGE_F	MENG13	QUAN	13	3	Invoiced quantity in basic unit of measure
34	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
35	FKREL	☐	FKREL	FKREL	CHAR	1	0	Relevant for Billing
36	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
37	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
38	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
39	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
40	KBVER	☐	KBVER	PACK2	DEC	3	0	Allowed deviation in quantity (in percent)
41	KEVER	☐	KEVER	PACK2	DEC	3	0	Days by which the quantity can be shifted
42	STDAT	☐	STDAT	DATUM	DATS	8	0	Date of Bill of Material
43	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
44	STPOS	☐	STPOS_D	STPOS	DEC	4	0	Bill of material item number
45	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
46	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
47	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
48	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
49	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
50	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
51	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	*
52	LAND1	☐	LLAND	LAND1	CHAR	3	0	Destination Country	*
53	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
54	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
55	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
56	BONUS	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group	*
57	PROVG	☐	PROVG	PROVG	CHAR	2	0	Commission group	*
58	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
59	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
60	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
61	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
62	WADAT	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
63	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
64	AUBEL	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
65	AUPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
66	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
67	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
68	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
69	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
70	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
71	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
72	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
73	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
74	ZMENG	☐	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
75	ZIEME	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	*
76	UMZIZ	☐	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
77	UMZIN	☐	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
78	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
79	LFIMG	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
80	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
81	FKLMG	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
82	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
83	LMENG	☐	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
84	BDDAT	☐	BDDAT	DATUM	DATS	8	0	Requirement date (deadline for procurement)
85	WMENG	☐	WMENG	MENG13	QUAN	13	3	Order quantity in sales units
86	BMENG	☐	BMENG	MENG13	QUAN	13	3	Confirmed quantity
87	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
88	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	*
89	KNTYP	☐	KNTYP	KNTYP	CHAR	1	0	Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost
90	KWERT	☐	KWERT	WERTV7	CURR	13	2	Condition Value
91	WAERK	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
92	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
93	KWERH	☐	KWERH	WERTV7	CURR	13	2	Condition value in local currency
94	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
95	SAKN1	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
96	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
97	OBJNR	☐	OBJPO	J_OBJNR	CHAR	22	0	Object number at item level	*
98	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
99	GRPOS	☐	GRPOS	GRPOS	NUMC	6	0	Item for which this item is an alternative
100	VBELV	☐	VBELV	VBELN	CHAR	10	0	Originating document	*
101	POSNV	☐	POSNV	POSNR	NUMC	6	0	Originating item	*
102	ERLMENGE	☐	ERLMENGE	MENG13	QUAN	13	3	Quantity for completion (sales) in basic unit of measure
103	FAREG	☐	FAREG	FAREG	CHAR	1	0	Rule in billing plan/invoice plan
104	FPROZ	☐	FPROZ	PRZ32	DEC	5	2	Percentage of value to be billed

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S008	AUBEL	VBUK	VBELN	REF	1	CN
2	S008	AUFNR	AUFK	AUFNR	REF	1	CN
3	S008	AUPOS	VBUP	POSNR	REF	1	CN
4	S008	ETENR	VBEP	ETENR	KEY	1	CN
5	S008	KAPPL	T681A	KAPPL	REF	1	CN
6	S008	MATWA	MARA	MATNR	REF	1	CN
7	S008	PMATN	MARA	MATNR	REF	1	CN
8	S008	PS_PSP_PNR	PRPS	PSPNR	REF	1	CN
9	S008	VGBEL	VBUK	VBELN	REF	1	CN
10	S008	VGPOS	VBUP	POSNR	REF	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in