J_1ISTR_PMSO SAP (EXIM: PM POWL list for Sale order) Structure details
Description: EXIM: PM POWL list for Sale order
Structure field list including key, data, relationships and ABAP select examples
J_1ISTR_PMSO 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 "EXIM: PM POWL list for Sale order" 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_J_1ISTR_PMSO TYPE J_1ISTR_PMSO.
The J_1ISTR_PMSO table consists of various fields, each holding specific information or linking keys about EXIM: PM POWL list for Sale order data available in SAP. These include ERDAT (Date on Which Record Was Created), ERNAM (Name of Person who Created the Object), ANGDT (Quotation/Inquiry is valid from), BNDDT (Date until which bid/quotation is binding (valid-to date)).. 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 J_1ISTR_PMSO 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 |
VBELN | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ANGDT | Quotation/Inquiry is valid from | ANGDT_V | DATS | 8 | DATUM | ||||
BNDDT | Date until which bid/quotation is binding (valid-to date) | BNDDT | DATS | 8 | DATUM | ||||
AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | DATUM | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
AUART | Sales Document Type | AUART | CHAR | 4 | Assigned to domain | AUART | AUART | AAT | |
AUGRU | Order reason (reason for the business transaction) | AUGRU | CHAR | 3 | Assigned to domain | AUGRU | |||
FAKSK | Billing block in SD document | FAKSK | CHAR | 2 | Assigned to domain | FAKSP | |||
NETWR | Net Value of the Sales Order in Document Currency | NETWR_AK | CURR | 15(2) | WERTV8 | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
VKGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
VKBUR | Sales Office | VKBUR | CHAR | 4 | Assigned to domain | VKBUR | VKB | ||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
GSKST | Business area from cost center | GSKST | CHAR | 4 | Assigned to domain | GSBER | |||
GUEBG | Valid-from date (outline agreements, product proposals) | GUEBG | DATS | 8 | DATUM | ||||
GUEEN | Valid-to date (outline agreements, product proposals) | GUEEN | DATS | 8 | DATUM | ||||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | Assigned to domain | KALSM | |||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | Assigned to domain | VSBED | |||
FKARA | Proposed billing type for an order-related billing document | FKARA | CHAR | 4 | Assigned to domain | FKART | |||
BSTNK | Customer purchase order number | BSTNK | CHAR | 20 | BSTNK | ||||
BSARK | Customer purchase order type | BSARK | CHAR | 4 | Assigned to domain | BSARK | |||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
BSTZD | Purchase order number supplement | BSTZD | CHAR | 4 | BSTZD | ||||
BNAME | Name of orderer | BNAME_V | CHAR | 35 | NAME | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
STAFO | Update group for statistics update | STAFO | CHAR | 6 | Assigned to domain | ALPHA | STAFO | MCF | |
STWAE | Statistics currency | STWAE | CUKY | 5 | Assigned to domain | WAERS | |||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
KVGR1 | Customer group 1 | KVGR1 | CHAR | 3 | Assigned to domain | KVGR1 | |||
KVGR2 | Customer group 2 | KVGR2 | CHAR | 3 | Assigned to domain | KVGR2 | |||
KVGR3 | Customer group 3 | KVGR3 | CHAR | 3 | Assigned to domain | KVGR3 | |||
KVGR4 | Customer group 4 | KVGR4 | CHAR | 3 | Assigned to domain | KVGR4 | |||
KVGR5 | Customer group 5 | KVGR5 | CHAR | 3 | Assigned to domain | KVGR5 | |||
KNUMA | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | Assigned to domain | ALPHA | KNUMA | VMBO | |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
BUKRS_VF | Company code to be billed | BUKRS_VF | CHAR | 4 | Assigned to domain | BUKRS | BUK | ||
TAXK1 | Tax classification 1 for customer | TAXK1 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK2 | Tax classification 2 for customer | TAXK2 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK5 | Tax classification 5 for customer | TAXK5 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK6 | Tax classification 6 for customer | TAXK6 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK7 | Tax classification 7 for customer | TAXK7 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK8 | Tax classification 8 for customer | TAXK8 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK9 | Tax classification 9 for customer | TAXK9 | CHAR | 1 | Assigned to domain | TAXKD | |||
XBLNR | Reference Document Number | XBLNR_V1 | CHAR | 16 | XBLNR1 | ||||
VGTYP | Document category of preceding SD document | VBTYP_V | CHAR | 1 | VBTYP | ||||
KALSM_CH | Search procedure for batch determination | KALSMA_CH | CHAR | 6 | Assigned to domain | KALSM | |||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
VBELN_GRP | Mster contract number | VBELN_GRP | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
SCHEME_GRP | Referencing requirement: Procedure | SCHEME_GRP | CHAR | 4 | Assigned to domain | SCHEME_GRP | |||
ABRUF_PART | Check partner authorizations | ABRUF_PART | CHAR | 1 | ABRUF_PART | ||||
STCEG_L | Tax Destination Country | LAND1TX | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
LANDTX | Tax departure country | LANDTX | CHAR | 3 | Assigned to domain | LAND1 | LND |
Key field | Non-key field |
How do I retrieve data from SAP structure J_1ISTR_PMSO using ABAP code?
As J_1ISTR_PMSO 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 J_1ISTR_PMSO as there is no data to select.How to access SAP table J_1ISTR_PMSO
Within an ECC or HANA version of SAP you can also view further information about J_1ISTR_PMSO 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