P1691_EXP SAP (Infotype 1691 expanded structures) Structure details

Dictionary Type: Structure
Description: Infotype 1691 expanded structures




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




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

P1691_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 1691 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_P1691_EXP TYPE P1691_EXP.

The P1691_EXP table consists of various fields, each holding specific information or linking keys about Infotype 1691 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 P1691_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
LANGULanguage Key LANGULANG1T002ISOLASPRAS
FILLERDummy Function With Length 9 DUMMY_9CHAR9CHAR9
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
MOLGACountry Grouping MOLGACHAR2T500LMOLGAMOL
TRTYPTrainer Object Type HRTNM_TRTYPCHAR2HRTNM_ATTTY
TROBJTrainer Object ID HRTNM_TROBJNUMC8Assigned to domainHROBJID
KOBESCost item KOBESCHAR8T77KBKOBES
PRDIRDirect entry of price PRDIRCHAR1CHAR1_X
PRICEProposed amount PRICECURR15(2) WERT8
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
BUNITReference unit BUNITCHAR1BUNIT
BZGMETime Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-001 0
KOBES001Cost item KOBESCHAR8T77KBKOBES
PRDIR001Direct entry of price PRDIRCHAR1CHAR1_X
PRICE001Proposed amount PRICECURR15(2) WERT8
WAERS001Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT001Reference unit BUNITCHAR1BUNIT
BZGME001Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-002 0
KOBES002Cost item KOBESCHAR8T77KBKOBES
PRDIR002Direct entry of price PRDIRCHAR1CHAR1_X
PRICE002Proposed amount PRICECURR15(2) WERT8
WAERS002Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT002Reference unit BUNITCHAR1BUNIT
BZGME002Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-003 0
KOBES003Cost item KOBESCHAR8T77KBKOBES
PRDIR003Direct entry of price PRDIRCHAR1CHAR1_X
PRICE003Proposed amount PRICECURR15(2) WERT8
WAERS003Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT003Reference unit BUNITCHAR1BUNIT
BZGME003Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-004 0
KOBES004Cost item KOBESCHAR8T77KBKOBES
PRDIR004Direct entry of price PRDIRCHAR1CHAR1_X
PRICE004Proposed amount PRICECURR15(2) WERT8
WAERS004Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT004Reference unit BUNITCHAR1BUNIT
BZGME004Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-005 0
KOBES005Cost item KOBESCHAR8T77KBKOBES
PRDIR005Direct entry of price PRDIRCHAR1CHAR1_X
PRICE005Proposed amount PRICECURR15(2) WERT8
WAERS005Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT005Reference unit BUNITCHAR1BUNIT
BZGME005Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-006 0
KOBES006Cost item KOBESCHAR8T77KBKOBES
PRDIR006Direct entry of price PRDIRCHAR1CHAR1_X
PRICE006Proposed amount PRICECURR15(2) WERT8
WAERS006Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT006Reference unit BUNITCHAR1BUNIT
BZGME006Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-007 0
KOBES007Cost item KOBESCHAR8T77KBKOBES
PRDIR007Direct entry of price PRDIRCHAR1CHAR1_X
PRICE007Proposed amount PRICECURR15(2) WERT8
WAERS007Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT007Reference unit BUNITCHAR1BUNIT
BZGME007Time Unit PEBZGMEUNIT3T006CUNITMEINS
.INCLU-008 0
KOBES008Cost item KOBESCHAR8T77KBKOBES
PRDIR008Direct entry of price PRDIRCHAR1CHAR1_X
PRICE008Proposed amount PRICECURR15(2) WERT8
WAERS008Currency Key WAERSCUKY5TCURCWAERSFWS
BUNIT008Reference unit BUNITCHAR1BUNIT
BZGME008Time Unit PEBZGMEUNIT3T006CUNITMEINS
WERKS001Personnel Area PERSACHAR4T500PPERSAPBR
BTRTL001Personnel Subarea BTRTLCHAR4T001PBTRTLPBS
PERNR001Personnel number PERSNONUMC8Assigned to domainPERSNOPER
WERKS002Personnel Area PERSACHAR4T500PPERSAPBR
BTRTL002Personnel Subarea BTRTLCHAR4T001PBTRTLPBS
PERNR002Personnel number PERSNONUMC8Assigned to domainPERSNOPER
TABNRReference Number to Table Part HRTABNRCHAR32Assigned to domainHRTABNR
TABSEQNRSequence Number in Table Part of Table Infotype HRTABSEQNRNUMC6NUM06
BEGDTDate HRTNM_BEGDTDATS8DATS
NBHRSTime Unit: standard hours HRTNM_STHRSDEC8(2) DEC6_2
OVHRSTime Unit: special hours HRTNM_SPHRSDEC8(2) DEC6_2
ABHRSAbsence hours HRTNM_ABHRSDEC8(2) DEC6_2
RESONAbsence Reason HRTNM_REASNCHAR2Assigned to domainCHAR2

Key field Non-key field



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

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

How to access SAP table P1691_EXP

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