P1794_EXP SAP (Infotype 1794 expanded structures) Structure details

Dictionary Type: Structure
Description: Infotype 1794 expanded structures




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




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

P1794_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 1794 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_P1794_EXP TYPE P1794_EXP.

The P1794_EXP table consists of various fields, each holding specific information or linking keys about Infotype 1794 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: Cannot Be Enhanced


SAP P1794_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
CENTRE_IDCenter Id PIQ_ES_CENTR_IDCHAR8PIQ_ES_CENTR_ID
CENTRE_NAMECenter Name PIQ_ES_CENTR_NAMECHAR100PIQ_ES_CENTR_NAME
SCH_STATUSSchool Status PIQ_ES_SCH_STATUSCHAR2T7PIQ_ES_SCSTATPIQ_ES_SCH_STATUS
GEN_CODEGeneric Code PIQ_ES_GEN_CODENUMC3T7PIQ_ES_GENCDPIQ_ES_GEN_CODE
CENTR_TYPType of Center PIQ_ES_CENTRE_TYPECHAR2T7PIQ_ES_CTYPPIQ_ES_CENTRE_TYPE
SCH_NTRNature of School PIQ_ES_SCH_NATURECHAR2T7PIQ_ES_SCNATRPIQ_ES_SCH_NATURE
SCH_TYPType of School PIQ_ES_SCH_TYPECHAR2T7PIQ_ES_SCHTYPPIQ_ES_SCH_TYPE
OWNR_NIFPrevious NIF Owner name PIQ_ES_OWNER_NIFCHAR40PIQ_ES_OWNER_NIF
NIFNIF PIQ_ES_NIFCHAR9PIQ_ES_NIF
GRPNGGrouping PIQ_ES_GROUPINGNUMC2T7PIQ_ES_GRPPIQ_ES_GROUPING
ORDER_NOOrder Number PIQ_ES_ORDER_NOCHAR9PIQ_ES_ORDER_NO
RULE_DATRule date PIQ_ES_RULE_DATSDATS8PIQ_ES_RULE_DATS
PBLCTN_DATPublication Date PIQ_ES_PUBLICATION_DATSDATS8PIQ_ES_PUBLICATION_DATS
MGZN_TYPMagazine Type PIQ_ES_MAGAZINE_TYPECHAR4T7PIQ_ES_MG_TYPPIQ_ES_MAGAZINE_TYPE
DSBLTY_TYPDisability Type PIQ_ES_DISABILITY_TYPECHAR2T7PIQCHTYPPIQCHTYP
BILINGUALBilingual PIQ_ES_BILINGUALCHAR1XFELD
BRTSH_AGRMNTAgreement from British PIQ_ES_BRITISH_AGREEMENTCHAR1XFELD
FSE_CNFNCDCofinanced by FSE PIQ_ES_FSE_CONFIANCEDCHAR1XFELD
MIN_IDENTIFIERCouncil Org Unit PIQ_ES_MIN_IDNTFRCHAR1PIQ_ES_MIN_IDNTFR
NIF_SCH_CNTRNIF/School Centre PIQ_ES_NIF_SCHCHAR9PIQ_ES_NIF_SCH
OWNR_ENTOwner Entity PIQ_ES_OWNER_ENTCHAR60PIQ_ES_OWNER_ENT
RANGE_REGRange/Regulation rule PIQ_ES_RANGE_REGCHAR2T7PIQ_ES_RA_REGPIQ_ES_RANGE_REG
TABNRReference Number to Table Part HRTABNRCHAR32Assigned to domainHRTABNR
TABSEQNRSequence Number in Table Part of Table Infotype HRTABSEQNRNUMC6NUM06
ORG_ATTRIBOrganizational Attribute PIQ_ES_ORG_ATTRIBCHAR10T7PIQ_ES_ORG_ATPIQ_ES_ORG_ATTRIB
ATTRIBVALOrganization Attribute Value PIQ_ES_ATTRIB_VALCHAR40CHAR40

Key field Non-key field



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

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

How to access SAP table P1794_EXP

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