SAP ABAP Table CFS_S_PRT_ITEM_DETAIL (Sales Summary: Data for Adobe Print)

Hierarchy

☛

SAP_APPL (Software Component) Logistics and Accounting
⤷

SD-BF-OC (Application Component) Output Determination
⤷

VD_PDF (Package) Sales: PDF Print

Basic Data

Table Category	INTTAB	Structure
Structure	CFS_S_PRT_ITEM_DETAIL	Table Relationship Diagram
Short Description	Sales Summary: Data for Adobe Print

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	KUNNR	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
2	ADDRESS_DATA	TDS_CFS_ADDRESS_DATA		STRU	0	0
3	TITLE	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key
4	TITLE_TEXT	AD_TITLETX	TEXT30	CHAR	30	0	Title text
5	NAME1	AD_NAME1	TEXT40	CHAR	40	0	Name 1
6	NAME2	AD_NAME2	TEXT40	CHAR	40	0	Name 2
7	NAME3	AD_NAME3	TEXT40	CHAR	40	0	Name 3
8	NAME4	AD_NAME4	TEXT40	CHAR	40	0	Name 4
9	NAME_TXT	AD_NAMETXT	TEXT50	CHAR	50	0	Converted name field (with form of address)
10	NAME_CO	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
11	STREET	AD_STREET	TEXT60	CHAR	60	0	Street
12	HOUSE_NUM1	AD_HSNM1	TEXT10	CHAR	10	0	House Number
13	POST_CODE1	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
14	POST_CODE2	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
15	POST_CODE3	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
16	CITY1	AD_CITY1	TEXT40	CHAR	40	0	City
17	CITY2	AD_CITY2	TEXT40	CHAR	40	0	District
18	PO_BOX	AD_POBX	CHAR10	CHAR	10	0	PO Box
19	PO_BOX_LOC	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
20	PO_BOX_REG	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)
21	PO_BOX_CTY	AD_POBXCTY	LAND1	CHAR	3	0	PO box country
22	COUNTRY	LAND1	LAND1	CHAR	3	0	Country Key
23	LANGU	SPRAS	SPRAS	LANG	1	0	Language Key
24	REGION	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
25	TRANSPZONE	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
26	TELNR_LONG	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
27	MOBILE_LONG	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
28	FAXNR_LONG	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
29	EMAIL	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
30	HOME_PAGE	AD_URI	AD_URI	LCHR	2048	0	Universal Resource Identifier (URI)
31	ADRNR	ADRNR	ADRNR	CHAR	10	0	Address
32	SENDING_COUNTRY	SLAND	LAND1	CHAR	3	0	Sending country for processing address
33	CLASSIFICATION	TDS_CFS_CLASSIFICATION		STRU	0	0
34	NIELS	NIELS	NIELS	CHAR	2	0	Nielsen ID
35	NIELSBEZ	BEZEI20	TEXT20	CHAR	20	0	Description
36	RPMKR	RPMKR	RPMKR	CHAR	5	0	Regional market
37	KUKLA	KUKLA	KUKLA	CHAR	2	0	Customer classification
38	KUKLABEZ	BEZEI20	TEXT20	CHAR	20	0	Description
39	BRSCH	BRSCH	BRSCH	CHAR	4	0	Industry key
40	BRSCHBEZ	TEXT1_016T	TEXT20	CHAR	20	0	Description of the Industry Key
41	BRAN1	BRAN1_D	BRACO	CHAR	10	0	Industry code 1
42	BRAN1BEZ	VTEXT	TEXT20	CHAR	20	0	Description
43	BRAN2	BRAN2	BRACO	CHAR	10	0	Industry code 2
44	BRAN2BEZ	VTEXT	TEXT20	CHAR	20	0	Description
45	BRAN3	BRAN3	BRACO	CHAR	10	0	Industry code 3
46	BRAN3BEZ	VTEXT	TEXT20	CHAR	20	0	Description
47	BRAN4	BRAN4	BRACO	CHAR	10	0	Industry code 4
48	BRAN4BEZ	VTEXT	TEXT20	CHAR	20	0	Description
49	BRAN5	BRAN5	BRACO	CHAR	10	0	Industry code 5
50	BRAN5BEZ	VTEXT	TEXT20	CHAR	20	0	Description
51	KEY_FIGURES	TDS_CFS_KEY_FIGURES		STRU	0	0
52	UMSA1	UMSA1	UMSA1	CURR	15	2	Annual sales
53	UWAER	UWAER	WAERS	CUKY	5	0	Currency of Sales Volume
54	UMJAH	UMJAH	JAHR	NUMC	4	0	Year For Which Sales are Given
55	JMZAH	JMZAH	JMZAH	NUMC	6	0	Yearly number of employees
56	JMJAH	JMJAH	JAHR	NUMC	4	0	Year for which the number of employees is given
57	PERIV	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant
58	PERIVBEZ	LTEXT_009	TEXT30	CHAR	30	0	Description of fiscal year variant
59	GFORM	GFORM	GFORM	CHAR	2	0	Legal status
60	GFORMBEZ	VTEXT	TEXT20	CHAR	20	0	Description
61	CONTACT_PERSON	TDT_CFS_CONTACT_PERSON		TTYP	0	0
62	ORDER_INFO_CUST	TDT_CFS_ORDER_INFO_CUST		TTYP	0	0
63	PRICING_CUST	TDT_CFS_PRICING_CUST		TTYP	0	0
64	SHIPPING_CUST	TDT_CFS_SHIPPING_CUST		TTYP	0	0
65	PART_DELIVERIES	TDT_CFS_PART_DELIVERIES		TTYP	0	0
66	TRANSP_DATA	TDS_CFS_TRANSP_DATA		STRU	0	0
67	BBBNR	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
68	BBSNR	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
69	BUBKZ	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
70	BRSCH	BRSCH	BRSCH	CHAR	4	0	Industry key
71	BRSCHTXT	TEXT1_016T	TEXT20	CHAR	20	0	Description of the Industry Key
72	BAHNS	BAHNS	BAHNH	CHAR	25	0	Train station
73	BAHNE	BAHNE	BAHNH	CHAR	25	0	Express train station
74	LZONE	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
75	LZONETEXT	BEZEI20	TEXT20	CHAR	20	0	Description
76	LOCCO	LOCCO	LOCCO	CHAR	10	0	City Coordinates
77	BILLING_DATA	TDT_CFS_BILLING_DATA		TTYP	0	0
78	DELIVERY_TERMS	TDT_CFS_DELIVERY_TERMS		TTYP	0	0
79	PARTNER_DATA	TDT_CFS_PARTNER_DATA		TTYP	0	0
80	STATISTICS_S001	TDT_CFS_STATISTICS_S001		TTYP	0	0
81	STATISTICS_MEAS	TDT_CFS_STATISTICS_MEAS		TTYP	0	0
82	LAST_SD_DOC	TDT_CFS_LAST_SD_DOC		TTYP	0	0
83	Q_NOTIFICATIONS	TDT_CFS_Q_NOTIFICATIONS		STRU	0	0
84	ZHLMELD	QZHLMELD	INT4	INT4	10	0	No. of Notifications
85	ZHLMOFN	QZHLMOFN	INT4	INT4	10	0	No. of Notifications with Status Outstanding
86	ZHLMIAR	QZHLMIAR	INT4	INT4	10	0	No. of Notifications with Status Being Processed
87	ZHLMMAB	QZHLMMAB	INT4	INT4	10	0	No. of Notifications with Status Completed
88	QMELDTAB	TDT_CFS_QMELDTAB		TTYP	0	0
89	S_NOTIFICATIONS	TDT_CFS_S_NOTIFICATIONS		STRU	0	0
90	SMOFN	SMOFN	MCZAEHLER	DEC	9	0	No.of recorded notifications
91	SMMAB	SMMAB	MCZAEHLER	DEC	9	0	No. of completed notifications
92	SGAUSZT	SGAUSZT	MENG13	QUAN	13	3	Downtime entered
93	SUNIT	MAUEH	MEINS	UNIT	3	0	Unit for Breakdown Duration
94	QMELDTAB	TDT_CFS_QMELDTAB		TTYP	0	0
95	CREDIT_INFO	TDT_CFS_CREDIT_INFO		TTYP	0	0
96	PROMOTIONS	TDT_CFS_PROMOTIONS		TTYP	0	0
97	PAYMENT_CARDS	TDT_CFS_PAYMENT_CARDS		TTYP	0	0
98	QUICKINFO	TDS_CFS_QUICKINFO		STRU	0	0
99	KUNNR	KUNNR	KUNNR	CHAR	10	0	Customer Number
100	NUM_DELIVERY_BLOCK	NUM10	NUM10	NUMC	10	0	10 digit number
101	NUM_INVOICE_BLOCK	NUM10	NUM10	NUMC	10	0	10 digit number
102	NUM_BACKLOG	NUM10	NUM10	NUMC	10	0	10 digit number
103	NUM_OPEN_ORDER	NUM10	NUM10	NUMC	10	0	10 digit number
104	NUM_OPEN_DELIVERY	NUM10	NUM10	NUMC	10	0	10 digit number
105	NUM_OPEN_INVOICE	NUM10	NUM10	NUMC	10	0	10 digit number
106	CONSUMPTION_CREDIT_LIMIT	KLPRZ_CM	ABPRC	NUMC	3	0	Credit limit used in %
107	FLAG_CUSTOMER_HIERARCHY	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
108	FLAG_CUSTOMER_MATERIAL_INFO	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
109	FLAG_CREDIT_INFO	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
110	FLAG_REMINDER	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
111	DATE_LAST_REMINDER	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
112	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code
113	LAST_ORDER	VBELN_VA	VBELN	CHAR	10	0	Sales Document
114	LAST_INVOICE	VBELN_VF	VBELN	CHAR	10	0	Billing document
115	NEXT_CONTACT	CAS_VBELN	VBELN	CHAR	10	0	SD document no. of a sales activity in sales support
116	LAST_DELIVERY	VBELN_VL	VBELN	CHAR	10	0	Delivery
117	DATE_LAST_ORDER	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
118	DATE_LAST_INVOICE	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
119	DATE_NEXT_CONTACT	ERDAT	DATUM	DATS	8	0	Date on which the record was created
120	DATE_LAST_DELIVERY	LFDAT	DATUM	DATS	8	0	Delivery date
121	BACKORDERS	TDT_CFS_BACKORDERS		TTYP	0	0
122	.INCLUDE				0	0	Control Table for Sales Summary
123	EX_ADDRESS_DATA	XFELD	XFELD	CHAR	1	0	Checkbox
124	EX_CLASSIFICATION	XFELD	XFELD	CHAR	1	0	Checkbox
125	EX_KEY_FIGURES	XFELD	XFELD	CHAR	1	0	Checkbox
126	EX_CONTACT_PERSON	XFELD	XFELD	CHAR	1	0	Checkbox
127	EX_ORDER_INFO_CUST	XFELD	XFELD	CHAR	1	0	Checkbox
128	EX_PRICING_CUST	XFELD	XFELD	CHAR	1	0	Checkbox
129	EX_SHIPPING_CUST	XFELD	XFELD	CHAR	1	0	Checkbox
130	EX_PART_DELIVERIES	XFELD	XFELD	CHAR	1	0	Checkbox
131	EX_TRANSP_DATA	XFELD	XFELD	CHAR	1	0	Checkbox
132	EX_BILLING_DATA	XFELD	XFELD	CHAR	1	0	Checkbox
133	EX_DELIVERY_TERMS	XFELD	XFELD	CHAR	1	0	Checkbox
134	EX_PARTNER_DATA	XFELD	XFELD	CHAR	1	0	Checkbox
135	EX_STATISTICS_S001	XFELD	XFELD	CHAR	1	0	Checkbox
136	EX_STATISTICS_MEAS	XFELD	XFELD	CHAR	1	0	Checkbox
137	EX_LAST_SD_DOC	XFELD	XFELD	CHAR	1	0	Checkbox
138	EX_Q_NOTIFICATIONS	XFELD	XFELD	CHAR	1	0	Checkbox
139	EX_Q_MELDTAB	XFELD	XFELD	CHAR	1	0	Checkbox
140	EX_S_NOTIFICATIONS	XFELD	XFELD	CHAR	1	0	Checkbox
141	EX_S_MELDTAB	XFELD	XFELD	CHAR	1	0	Checkbox
142	EX_CREDIT_INFO	XFELD	XFELD	CHAR	1	0	Checkbox
143	EX_PROMOTIONS	XFELD	XFELD	CHAR	1	0	Checkbox
144	EX_PAYMENT_CARDS	XFELD	XFELD	CHAR	1	0	Checkbox
145	EX_QUICKINFO	XFELD	XFELD	CHAR	1	0	Checkbox
146	EX_BACKORDERS	XFELD	XFELD	CHAR	1	0	Checkbox