P1018_EXP SAP (Infotype 1018 Expanded) Structure details

Dictionary Type: Structure
Description: Infotype 1018 Expanded




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




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

P1018_EXP 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 "Infotype 1018 Expanded" 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_P1018_EXP TYPE P1018_EXP.

The P1018_EXP table consists of various fields, each holding specific information or linking keys about Infotype 1018 Expanded data available in SAP. These include MANDT (Client), PLVAR (Plan Version), OTYPE (Object Type), OBJID (Object ID).. 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 P1018_EXP 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 MANDTCLNT3T000MANDT
PLVARPlan Version PLVARCHAR2T778PPLVARPOP
OTYPEObject Type OTYPECHAR2T778OOTYPEPOT
OBJIDObject ID OBJEKTIDNUMC8NUM08PON
INFTYInfotype INFOTYPCHAR4T778TINFOTYPHRBAS00INFTY
SUBTYSubtype SUBTYPCHAR4T778USUBTYP
ISTATPlanning Status ISTAT_DCHAR1T778SISTATPST
PRIOXPriority PRIOXCHAR2CHAR2
BEGDAStart Date BEGDATUMDATS8DATUMBEG
ENDDAEnd Date ENDDATUMDATS8DATUMEND
VARYFVariation Field for File PLOG VARYFCHAR10CHAR10
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged on AEDTMDATS8DATUM
UNAMEUser Name USRNAMECHAR12CHAR12
REASNReason REASNCHAR2CHAR2
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXNRText Module for Infotype ITXNRNUMC8NUM08
TABNRReference Number to Table Part HRTABNRCHAR32Assigned to domainHRTABNR
TABSEQNRSequence Number in Table Part of Table Infotype HRTABSEQNRNUMC6NUM06
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
ROTYPEObject type of real CO account assignment (internal only) OTYPE_REALCHAR2Assigned to domainOTYPE
KOSTLCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
POSNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
FIKRSFinancial Management Area FIKRSCHAR4Assigned to domainFIKRSFIK
FINCODEFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
DARTService Type (Public Service Germany) DARTCHAR2T5D7CDARTDAR
UDARTService Category (Public Service Germany) UDARTCHAR2T5D7EUDARTUDA
SGMNTSegment for Segmental Reporting FB_SEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
PROZTWeighting Percentage PROZTDEC5(2) DEC3_2

Key field Non-key field



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

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

How to access SAP table P1018_EXP

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