SAP ABAP Table SDSM_ITEM (Item Data for Generating Sales Documents from Dynamic Items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VA (Package) Application development R/3 Sales

Basic Data

Table Category	INTTAB	Structure
Structure	SDSM_ITEM	Table Relationship Diagram
Short Description	Item Data for Generating Sales Documents from Dynamic Items

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	POSNR_V	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
2	SD_MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
3	MENGE	☐	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
4	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
5	FFPRF	☐	AD01PROFNR	AD01PROFNR	CHAR	8	0	Dynamic Item Processor Profile	*
6	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
7	KSCHL1	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	*
8	KBETR1	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
9	KWAER1	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
10	KPEIN1	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
11	KSCHL2	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	*
12	KBETR2	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
13	KWAER2	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
14	KPEIN2	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
15	KSCHL3	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	*
16	KBETR3	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
17	KWAER3	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
18	KPEIN3	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
19	KSCHL4	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	*
20	KBETR4	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
21	KWAER4	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
22	KPEIN4	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
23	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
24	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
25	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
26	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
27	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
28	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
29	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
30	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
31	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
32	MSGID	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
33	MSGTY	☐	SYMSGTY	SYCHAR01	CHAR	1	0	Message Type
34	MSGNO	☐	SYMSGNO	SYMSGNO	NUMC	3	0	Message Number
35	MSGV1	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
36	MSGV2	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
37	MSGV3	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
38	MSGV4	☐	SYMSGV	SYCHAR50	CHAR	50	0	Message Variable
39	KPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
40	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
41	FLMEH	☐	FLMEH	XFELD	CHAR	1	0	Conversion in Sales Unit/Base Unit of Measure
42	.INCLUDE	☐				0	0	All Parameters of Dynamic Items
43	.INCLUDE	☐				0	0	Independent Parameters of Dynamic Items
44	.INCLUDE	☐				0	0	Mandatory Parameters of Dynamic Items
45	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
46	POPER	☐	AD01PERIOD	JAHRPER	NUMC	7	0	Posting period
47	TWAER	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
48	MEINH	☐	CO_MEINH	MEINS	UNIT	3	0	Unit of Measure	T006
49	MANUAL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
50	.INCLUDE	☐				0	0	Independent Parameters of a Dynamic Item
51	KSTAR	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
52	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
53	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
54	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
55	STAGR	☐	STAGR	STAGR	CHAR	6	0	Statistical key figure	TKA03
56	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
57	WRTTP	☐	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
58	VERSN	☐	VERSN	COVERSI	CHAR	3	0	Version	TKVS
59	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
60	PRODU	☐	PRODN	MATNR	CHAR	18	0	Product number	MARA
61	FAKTF	☐	FAKTF	FAKTF	CHAR	2	0	Billing Form
62	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
63	BELNR	☐	CO_BELNR	CO_BELNR	CHAR	10	0	Document Number	*
64	BUZEI	☐	CO_BUZEI	BUZEI	NUMC	3	0	Posting row
65	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
66	AWERK	☐	AD01AWERK	WERKS	CHAR	4	0	Plant of Work Center	T001W
67	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	CBPR
68	ASNUM	☐	ASNUM	ASNUM	CHAR	18	0	Activity Number	ASMD
69	PERNR	☐	HR_PERNR	PERNR	NUMC	8	0	Personnel Number
70	.INCLUDE	☐				0	0
71	.INCLUDE	☐				0	0
72	.INCLU--AP	☐				0	0	Contract and Billing: Append
73	/CBAD/ORIG_OBJNR	☐	/CBAD/ORIG_OBJNR	J_OBJNR	CHAR	22	0	CBAD Original Object Number	*
74	/CBAD/BILL_WBS	☐	/CBAD/PS_POSNR	PS_POSNR	NUMC	8	0	CBAD WBS Element	*
75	.INCLU--AP	☐				0	0	Commercial Project Inception & Lean Staffing append.ATTRI2
76	PRS_WORK_PERIOD	☐	PRS_WORK_PERIOD	PRS_WORK_PERIOD	NUMC	7	0	Work Period (Internal Representation)
77	.INCLU--AP	☐				0	0	Append Structure for Additional Account Assignment Info
78	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
79	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	*
80	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
81	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
82	.INCLUDE	☐				0	0	Additional Characteristics for Billing from SRM
83	ORDERED_PROD	☐	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
84	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
85	AWSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	*
86	SERV_AGENT_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
87	REF_OBJECT_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
88	REF_OBJECT_ITEM	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
89	.INCLU--AP	☐				0	0	Additional Characteristics for Billing Between Company Codes
90	.INCLUDE	☐				0	0	Additional Characteristics for Billing Between Company Codes
91	ORIG_OBJNR	☐	DPICB_OBJNR	J_OBJNR	CHAR	22	0	Object Number of Original Object	*
92	.INCLU--AP	☐				0	0	Characteristics for Grants Mgmt.
93	.INCLUDE	☐				0	0	Additional characteristics for Grants Mgmt.
94	FAREA	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	*
95	RGRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
96	WBS_ELEMENT	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
97	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
98	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
99	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
100	SPONSORED_PROG	☐	GM_SPONSORED_PROG	GM_SPONSORED_PROG	CHAR	20	0	Sponsored Program	*
101	SPONSORED_CLASS	☐	GM_SPONSORED_CLASS	GM_SPONSORED_CLASS	CHAR	20	0	Sponsored Class	*
102	GL_SIRID	☐	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
103	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
104	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
105	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
106	GM_VALUETYPE	☐	GM_VALUETYPE	GM_VALUETYPE	CHAR	2	0	GM Value Type
107	ASSETMAINO	☐	BF_ANLN1	BF_ANLN1	CHAR	12	0	Main Asset Number
108	ASSETSUBNO	☐	BF_ANLN2	BF_ANLN2	CHAR	4	0	Asset Subnumber
109	.INCLUDE	☐				0	0	Derived Parameters of Dynamic Items
110	OBART	☐	J_OBART	J_OBART	CHAR	2	0	Object Type	TBO00
111	.INCLUDE	☐				0	0
112	.INCLU--AP	☐				0	0	Append Structure for Structure SDSM_ITEM
113	.INCLUDE	☐				0	0	Reference to Billing Plan Date
114	DPBP_REF_FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	*
115	DPBP_REF_FPLTR	☐	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards	*
116	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
117	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SDSM_ITEM	ASNUM	ASMD	ASNUM
2	SDSM_ITEM	AWERK	T001W	WERKS
3	SDSM_ITEM	BEMOT	TBMOT	BEMOT
4	SDSM_ITEM	FIPOS	FMFPO	FIPOS
5	SDSM_ITEM	KOSTL	CSKS	KOSTL
6	SDSM_ITEM	KSTAR	CSKA	KSTAR
7	SDSM_ITEM	LSTAR	CSLA	LSTAR
8	SDSM_ITEM	MATNR	MARA	MATNR	KEY	1	CN
9	SDSM_ITEM	MEINH	T006	MSEHI	KEY	1	CN
10	SDSM_ITEM	OBART	TBO00	OBART
11	SDSM_ITEM	OBJNR	ONR00	OBJNR	KEY	1	CN
12	SDSM_ITEM	PRODU	MARA	MATNR
13	SDSM_ITEM	PRZNR	CBPR	PRZNR
14	SDSM_ITEM	STAGR	TKA03	STAGR
15	SDSM_ITEM	TWAER	TCURC	WAERS	KEY	1	CN
16	SDSM_ITEM	VERSN	TKVS	VERSI
17	SDSM_ITEM	WERKS	T001W	WERKS		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in