SDSM_MAIN_ITEM SAP (Main Item for Generating Sales Documents from Dynamic Items) Structure details
Description: Main Item for Generating Sales Documents from Dynamic Items
Related tables to SDSM_MAIN_ITEM
Access table SDSM_MAIN_ITEM
Structure field list including key, data, relationships and ABAP select examples
SDSM_MAIN_ITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Main Item for Generating Sales Documents from Dynamic Items" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_SDSM_MAIN_ITEM TYPE SDSM_MAIN_ITEM.
The SDSM_MAIN_ITEM table consists of various fields, each holding specific information or linking keys about Main Item for Generating Sales Documents from Dynamic Items data available in SAP. These include POSNR_V (Item number of the SD document), SD_MATNR (Material Number), MENGE (Target quantity in sales units), PRSDT (Date for pricing and exchange rate).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP SDSM_MAIN_ITEM structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
POSNR_V | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
SD_MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MENGE | Target quantity in sales units | DZMENG | QUAN | 13(3) | MENG13 | ||||
PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
FFPRF | Dynamic Item Processor Profile | AD01PROFNR | CHAR | 8 | Assigned to domain | AD01PROFNR | AD0 | DIP_PROFILE | |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
KSCHL1 | Condition type | KSCHA | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
KBETR1 | Rate (condition amount or percentage) | KBETR | CURR | 11(2) | WERTV6 | ||||
KWAER1 | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
KPEIN1 | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
KSCHL2 | Condition type | KSCHA | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
KBETR2 | Rate (condition amount or percentage) | KBETR | CURR | 11(2) | WERTV6 | ||||
KWAER2 | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
KPEIN2 | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
KSCHL3 | Condition type | KSCHA | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
KBETR3 | Rate (condition amount or percentage) | KBETR | CURR | 11(2) | WERTV6 | ||||
KWAER3 | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
KPEIN3 | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
KSCHL4 | Condition type | KSCHA | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
KBETR4 | Rate (condition amount or percentage) | KBETR | CURR | 11(2) | WERTV6 | ||||
KWAER4 | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
KPEIN4 | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
POSNR | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13(2) | WERTV7 | ||||
KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13(2) | WERTV7 | ||||
KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13(2) | WERTV7 | ||||
KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13(2) | WERTV7 | ||||
KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13(2) | WERTV7 | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
NETWR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
MSGID | Message Class | SYMSGID | CHAR | 20 | Assigned to domain | ARBGB | |||
MSGTY | Message Type | SYMSGTY | CHAR | 1 | SYCHAR01 | ||||
MSGNO | Message Number | SYMSGNO | NUMC | 3 | SYMSGNO | ||||
MSGV1 | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
MSGV2 | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
MSGV3 | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
MSGV4 | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
KPOSN | Condition item number | KPOSN | NUMC | 6 | NUM6 | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
FLMEH | Conversion in Sales Unit/Base Unit of Measure | FLMEH | CHAR | 1 | XFELD | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
POPER | Posting period | AD01PERIOD | NUMC | 7 | PERI7 | JAHRPER | |||
TWAER | Transaction Currency | TWAER | CUKY | 5 | TCURC | WAERS | FWS | ||
MEINH | Unit of Measure | CO_MEINH | UNIT | 3 | T006 | CUNIT | MEINS | ||
MANUAL | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
KSTAR | Cost Element | KSTAR | CHAR | 10 | CSKA | ALPHA | KSTAR | KAT | |
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
LSTAR | Activity Type | LSTAR | CHAR | 6 | CSLA | LSTAR | LAR | LART_EMPTY | |
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
STAGR | Statistical key figure | STAGR | CHAR | 6 | TKA03 | STAGR | STA | ||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | FMFPO | FIPOS | FIP | ||
WRTTP | Value Type | CO_WRTTP | CHAR | 2 | CO_WRTTP | ||||
VERSN | Version | VERSN | CHAR | 3 | TKVS | ALPHA | COVERSI | KVS | |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
PRODU | Product number | PRODN | CHAR | 18 | MARA | MATN1 | MATNR | ||
FAKTF | Billing form | FAKTF | CHAR | 2 | FAKTF | ||||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | TBMOT | BEMOT | |||
BELNR | Document Number | CO_BELNR | CHAR | 10 | Assigned to domain | ALPHA | CO_BELNR | BLN | |
BUZEI | Posting row | CO_BUZEI | NUMC | 3 | BUZEI | ||||
ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
AWERK | Plant of Work Center | AD01AWERK | CHAR | 4 | T001W | WERKS | H_T001W | ||
PRZNR | Business Process | CO_PRZNR | CHAR | 12 | CBPR | ALPHA | CO_PRZNR | KWP | |
ASNUM | Activity Number | ASNUM | CHAR | 18 | ASMD | ALPHA | ASNUM | ASN | |
PERNR | Personnel Number | HR_PERNR | NUMC | 8 | PERNR | PER | |||
Z_OBJNR2 | 0 | Assigned to domain | |||||||
Z_PRS_OFFSHORE | 0 | ||||||||
Z_PRS_BILL_FLAG | 0 | ||||||||
Z_PRS_COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
Z_PRS_CHARGELEVL | 0 | ||||||||
.INCLU--AP | 0 | ||||||||
/CBAD/ORIG_OBJNR | CBAD Original Object Number | /CBAD/ORIG_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | |||
/CBAD/BILL_WBS | CBAD WBS Element | /CBAD/PS_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
.INCLU--AP | 0 | ||||||||
PRS_WORK_PERIOD | Work Period (Internal Representation) | PRS_WORK_PERIOD | NUMC | 7 | PRSWP | PRS_WORK_PERIOD | |||
.INCLU--AP | 0 | ||||||||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PARGB | Trading partner's business area | PARGB | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PPRCTR | Partner Profit Center | PPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PPC | |
.INCLU--AP | 0 | ||||||||
WTY_IND | Warranty indicator | WTYSC_WTY_INDICATOR | CHAR | 1 | WTYSC_WTY_INDICATOR | ||||
ORDERED_PROD | Product Name Entered | CRMT_ORDERED_PROD_DB | CHAR | 54 | CRM_ORDERED_PROD | ||||
CATEGORY_ID | Category ID | COMT_CATEGORY_ID | CHAR | 20 | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | ||
AWSYS | Logical system of source document | AWSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
SERV_AGENT_ID | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
REF_OBJECT_ID | Transaction Number | CRMT_OBJECT_ID_DB | CHAR | 10 | ALPHA | CRM_OBJECT_ID | |||
REF_OBJECT_ITEM | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
.INCLU--AP | 0 | ||||||||
CPD_DLIID | Billing ID for Commercial Project Management | /CPD/PWS_BILLING_DLIID | NUMC | 10 | /CPD/PWS_BILLING_DLIID | ||||
.INCLU--AP | 0 | ||||||||
ORIG_OBJNR | Object Number of Original Object | DPICB_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | |||
.INCLU--AP | 0 | ||||||||
FAREA | Functional Area | FM_FAREA | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
RGRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
WBS_ELEMENT | WBS Element | PS_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
ORDERID | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
FUNDS_CTR | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
FUND | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
SPONSORED_PROG | Sponsored Program | GM_SPONSORED_PROG | CHAR | 20 | Assigned to domain | GM_SPONSORED_PROG | GM_SPONSORED_PROG | ||
SPONSORED_CLASS | Sponsored Class | GM_SPONSORED_CLASS | CHAR | 20 | Assigned to domain | GM_SPONSORED_CLASS | GM_SPONSORED_CLASS | ||
GL_SIRID | Record number of the line item record | GU_RECID | CHAR | 18 | OBJNR | OBN | |||
REFDOCNR | Reference document number of an accounting document | REFBELNR | CHAR | 10 | ALPHA | BELNR | BLN | ||
REFDOCLN | Six-digit number of the reference posting line | REFBUZEI6 | NUMC | 6 | BUZEI6 | BUZ | |||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
GM_VALUETYPE | GM Value Type | GM_VALUETYPE | CHAR | 2 | GM_VALUETYPE | GMVALUETYPE | |||
ASSETMAINO | Main Asset Number | BF_ANLN1 | CHAR | 12 | ALPHA | BF_ANLN1 | AN1 | ||
ASSETSUBNO | Asset Subnumber | BF_ANLN2 | CHAR | 4 | ALPHA | BF_ANLN2 | AN2 | ||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
OBART | Object Type | J_OBART | CHAR | 2 | TBO00 | J_OBART | |||
.INCLU--AP | 0 | ||||||||
DPBP_REF_FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10 | Assigned to domain | FPLNR | |||
DPBP_REF_FPLTR | Item for billing plan/invoice plan/payment cards | FPLTR | NUMC | 6 | Assigned to domain | FPLTR | |||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
CUOBJ | Configuration | CUOBJ_VA | NUMC | 18 | CUOBJ | ||||
POS_HANDLE | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
AGEXI | Quotation exists | AGEXI | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP structure SDSM_MAIN_ITEM using ABAP code?
As SDSM_MAIN_ITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SDSM_MAIN_ITEM as there is no data to select.How to access SAP table SDSM_MAIN_ITEM
Within an ECC or HANA version of SAP you can also view further information about SDSM_MAIN_ITEM and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects