E3OILSA SAP (Partner in TD-Shipment) Structure details

Dictionary Type: Structure
Description: Partner in TD-Shipment




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




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

E3OILSA 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 "Partner in TD-Shipment" 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_E3OILSA TYPE E3OILSA.

The E3OILSA table consists of various fields, each holding specific information or linking keys about Partner in TD-Shipment data available in SAP. These include POSNR (Item number of the SD document), PARVW (Partner Function), KUNNR (Customer Numbers), LIFNR (Account Number of Vendor or Creditor).. 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: Cannot Be Enhanced


SAP E3OILSA 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
VBELNSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
POSNRItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
PARVWPartner Function PARVWCHAR2Assigned to domainPARVWPARVWPAR
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
PARNRNumber of contact person PARNRNUMC10PARNRVPA
ADRNRAddress ADRNRCHAR10Assigned to domainALPHAADRNR
ABLADUnloading Point ABLADCHAR25TEXT25
LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
ADRDAAddress indicator ADRDACHAR1ADRDA
XCPDKIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
HITYPCustomer hierarchy type HITYP_KHCHAR1Assigned to domainHITYP
PRFRERelevant for price determination ID PRFRECHAR1XFELD
BOKREIndicator: Customer Is Rebate-Relevant BOKRECHAR1XFELD
HISTUNRLevel number within hierarchy HISTUNRNUMC2NUM2
KNREFCustomer description of partner (plant, storage location) KNREFCHAR30KNREFKNREF
LZONETransportation zone to or from which the goods are delivered LZONECHAR10Assigned to domainZONE
HZUORAssignment to Hierarchy HZUORNUMC2HZUOR
UPDATEFLAGTransaction type TRTYPCHAR1TRTYP
PA_LEVELPartner level for TD shipment OIK_PA_LEVCHAR1OIK_PA_LEV

Key field Non-key field



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

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

How to access SAP table E3OILSA

Within an ECC or HANA version of SAP you can also view further information about E3OILSA 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!