SAP ABAP Table S117 (Receipt/article)

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	S117	Table Relationship Diagram
Short Description	Receipt/article

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	T000
2	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
3	BONNR	☑	W_BONNR	W_BONNR	NUMC	15	0	Transaction number (till receipt)
4	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
5	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
6	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
7	AFLAG	☑	MCW_AFLAG	MCW_AFLAG	NUMC	1	0	Promotion indicator
8	KALWOC	☑	MCW_KALWOC	NUM02	NUMC	2	0	Calendar week
9	WOCHTG	☑	MCW_WOCHTG	DAYS17	NUMC	1	0	Weekday
10	TGZTKL	☑	MCW_TGZTKL	MCW_TGZTKL	CHAR	4	0	Time of day class	TMCWW
11	VKSTD	☑	W_VKSTD	W_VKSTD	NUMC	2	0	Hour of sale
12	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
13	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
14	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
15	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
16	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
17	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
18	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
19	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
20	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
21	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
22	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
23	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
24	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
25	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
26	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
27	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
28	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
29	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
30	AKTYP	☐	W_AKTYP	AKTTY	CHAR	4	0	Promotion Category	TWTY
31	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
32	WMINR	☐	WMINR	WMINR	CHAR	10	0	Product catalog number	WWMI
33	KUNDK	☐	W_KUNDK	W_KUNDK	CHAR	1	0	Customer ID
34	KUNNR	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	KNA1
35	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
36	UMSMNG	☐	W_UMSMNG	MENGV15_3	QUAN	15	3	Transaction sales - quantity in base unit of measure
37	VKMNG	☐	W_VKMNG	MENGV15_3	QUAN	15	3	Transaction sales - quantity in sales unit
38	UMSATZ	☐	MCW_UMSATZ	WERTV10	CURR	19	2	Sales POS
39	PRSNLS	☐	W_PRSNLS	WERTV10	CURR	19	2	Price reduction from sales as per receipts/aggregated sales
40	ANZPOS	☐	MCW_ANZPOS	MCZAEHLINT	INT4	10	0	Number of transaction items (till receipts)
41	ANZAAR	☐	MCW_ANZAAR	MCZAEHLINT	INT4	10	0	Number of promotion items
42	KMONAT	☐	MCW_MONAT	AM_MONAT	NUMC	2	0	Calendar month
43	QUARTAL	☐	MCW_QUARTL	NUM01	NUMC	1	0	Quarter
44	JAHR	☐	MCJAHR	GJAHR	NUMC	4	0	Year
45	UHZEIT	☐	MCW_UHZEIT	UZEIT	TIMS	6	0	Time sale was entered

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S117	AKTHE	TWAT	AKTHE
2	S117	AKTNR	WAKH	AKTNR
3	S117	AKTYP	TWTY	AKTYP
4	S117	BASME	T006	MSEHI
5	S117	KUNNR	KNA1	KUNNR
6	S117	MANDT	T000	MANDT	KEY
7	S117	MATKL	T023	MATKL	KEY
8	S117	MATNR	MARA	MATNR	KEY
9	S117	MTART	T134	MTART
10	S117	PLGTP	TWPT	PLGTP
11	S117	SAISO	T6WSP	SAISO
12	S117	SATNR	MARA	MATNR
13	S117	TGZTKL	TMCWW	TGZTKL	KEY
14	S117	VRKME	T006	MSEHI
15	S117	WAERK	TCURC	WAERS
16	S117	WERKS	T001W	WERKS	KEY
17	S117	WMINR	WWMI	WMINR

History

Last changed by/on	SAP	20130529
SAP Release Created in