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
⤷ 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 |