SAP ABAP Table SDSM_MAIN_ITEM (Main Item 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_MAIN_ITEM | Table Relationship Diagram |
Short Description | Main Item 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 | .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 | CUOBJ | CUOBJ_VA | CUOBJ | NUMC | 18 | 0 | Configuration | ||
120 | POS_HANDLE | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
121 | AGEXI | AGEXI | XFELD | CHAR | 1 | 0 | Quotation exists |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | SDSM_MAIN_ITEM | ASNUM | ASMD | ASNUM | |||
2 | SDSM_MAIN_ITEM | AWERK | T001W | WERKS | |||
3 | SDSM_MAIN_ITEM | BEMOT | TBMOT | BEMOT | |||
4 | SDSM_MAIN_ITEM | FIPOS | FMFPO | FIPOS | |||
5 | SDSM_MAIN_ITEM | KOSTL | CSKS | KOSTL | |||
6 | SDSM_MAIN_ITEM | KSTAR | CSKA | KSTAR | |||
7 | SDSM_MAIN_ITEM | LSTAR | CSLA | LSTAR | |||
8 | SDSM_MAIN_ITEM | MATNR | MARA | MATNR | KEY | 1 | CN |
9 | SDSM_MAIN_ITEM | MEINH | T006 | MSEHI | KEY | 1 | CN |
10 | SDSM_MAIN_ITEM | OBART | TBO00 | OBART | |||
11 | SDSM_MAIN_ITEM | OBJNR | ONR00 | OBJNR | KEY | 1 | CN |
12 | SDSM_MAIN_ITEM | PRODU | MARA | MATNR | |||
13 | SDSM_MAIN_ITEM | PRZNR | CBPR | PRZNR | |||
14 | SDSM_MAIN_ITEM | STAGR | TKA03 | STAGR | |||
15 | SDSM_MAIN_ITEM | TWAER | TCURC | WAERS | KEY | 1 | CN |
16 | SDSM_MAIN_ITEM | VERSN | TKVS | VERSI | |||
17 | SDSM_MAIN_ITEM | WERKS | T001W | WERKS | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |