J1SORDER SAP (CH Interface) Structure details

Dictionary Type: Structure
Description: CH Interface




ABAP Code to SELECT data from J1SORDER
Related tables to J1SORDER
Access table J1SORDER




Structure field list including key, data, relationships and ABAP select examples

J1SORDER 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 "CH Interface" 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_J1SORDER TYPE J1SORDER.

The J1SORDER table consists of various fields, each holding specific information or linking keys about CH Interface data available in SAP. These include MANDT (Client), LFNGNR (IS-M: Sequence Number for Delivery), NACHLFNGNR (Sequence number of subsequent delivery), VBELN (IS-M/SD: Publishing Sales Order).. 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 J1SORDER 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
LFNGNRIS-M: Sequence Number for Delivery LFNGNRNUMC12Assigned to domainLFNGNRLFG
NACHLFNGNRSequence number of subsequent delivery NACHLFNGNRNUMC2NUM2
VBELNIS-M/SD: Publishing Sales Order AVNRCHAR10Assigned to domainALPHAAVNRJK1MJK1
POSNRSales Order Item APNRNUMC6Assigned to domainAPNR
ETENRSales Order Schedule Line JAENRNUMC4Assigned to domainAENR
JPARVWIS-M: Business Partner Role JPARVWCHAR2Assigned to domainPARVWJPARVWJGR
PARZAIS-M: Partner Role Counter JPARZANUMC3JPARZA
GUELTIGVONDate from Which Partner Data in Sales Order is Valid JKPAVONDATS8DATUM
GUELTIGBISDate to Which Partner Data in Sales Order is Valid JKPABISDATS8DATUM
ADRNRIS-M: Address Number JADRNRCHAR10Assigned to domainALPHAJADRNR
PLZ_ORDERIS-M: Postal Code PLZ_ISPCHAR10PSTLZ
MENGEINZUOSch.line qty in order-delivery assignment for partial susp. MENGEINZUODEC9STMENGE
ETARTSchedule Line Type for Internal Sales Order Schedule Line ETART_ISPCHAR2Assigned to domainETART_ISPJAE
ETMENGEIS-M: Sales Order Schedule Line Quantity ETMENGEQUAN10MENGGPOS
ETMEINSIS-M: Sales Unit for Sales Order ETMEINSUNIT3Assigned to domainCUNITMEINS
ADRESSVARIS-M: Address Variant ADRESSVARCHAR1ERSTADR
LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
ORIGINIS-M/SD: Origin of order JV_ORDER_ORIGINCHAR1JV_ORDER_ORIGIN
SHIPORDNBRAddress-Based Shipping Order Number SHIPORDNBRCHAR10Assigned to domainALPHASHIPORDNBRJVSONMJVSOA
SHIPORDPOSNBRAddress-Based Shipping Order Item Number SHIPORDPOSNBRNUMC8Assigned to domainALPHASHIPORDPOSNBRJVSOPN
POSTEINORTIS-M: City Number (Unique) JALORTCHAR8Assigned to domainALPHAALORTJSO
POSTEINSTRIS-M: Street Number STRASSENNRCHAR10Assigned to domainALPHASTRASSENNRJSS
STRASStreet Name STRAS_ISPCHAR35TEXT35
HAUSNIS-M: House Number HSNMR1CHAR10HAUSNUMMER
HSNMR2IS-M: House Number Affix HSNMR2CHAR8CHAR8

Key field Non-key field



How do I retrieve data from SAP structure J1SORDER using ABAP code?

As J1SORDER 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 J1SORDER as there is no data to select.

How to access SAP table J1SORDER

Within an ECC or HANA version of SAP you can also view further information about J1SORDER and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!