P7900_EXP SAP (Infotype 7900 expanded structures) Structure details

Dictionary Type: Structure
Description: Infotype 7900 expanded structures




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




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

P7900_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 7900 expanded structures" 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_P7900_EXP TYPE P7900_EXP.

The P7900_EXP table consists of various fields, each holding specific information or linking keys about Infotype 7900 expanded structures 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 P7900_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
AVAL_EXTERNALAvailability of Participant /XLSO/E_AVAL_EXTERNALCHAR3/XLSO/D_AVAL_EXTERNAL
TABNRReference Number to Table Part HRTABNRCHAR32Assigned to domainHRTABNR
TABSEQNRSequence Number in Table Part of Table Infotype HRTABSEQNRNUMC6NUM06
SALESORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
DCHANNELDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
DIVISIONDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
AMOUNTRate (condition amount or percentage) where no scale exists KBETR_KONDCURR11(2) WERTV6
UNIT_AMTRate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
PRICE_UNIT_AMTCondition pricing unit KPEINDEC5KPEIN
UOM_AMTCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
VALID_FROM_AMTValidity start date of the condition record KODATABDATS8DATUM
VALID_TO_AMTValidity end date of the condition record KODATBIDATS8DATUM
CALC_TYP_AMTCalculation type for condition /XLSO/E_KRECHCHAR1/XLSO/D_KRECH
DISCOUNTDiscount /XLSO/E_DISCOUNTCURR11(2) WERTV6
UNIT_DCTRate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
PRICE_UNIT_DCTCondition pricing unit KPEINDEC5KPEIN
UOM_DCTCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
VALID_FROM_DCTValidity start date of the condition record KODATABDATS8DATUM
VALID_TO_DCTValidity end date of the condition record KODATBIDATS8DATUM
CALC_TYP_DCTCalculation type for condition /XLSO/E_KRECHCHAR1/XLSO/D_KRECH

Key field Non-key field



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

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

How to access SAP table P7900_EXP

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