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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in