PIQDBLOC_INFTY SAP (Country specific enhancement for infotypes) Table details

Dictionary Type: Table
Description: Country specific enhancement for infotypes




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




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

PIQDBLOC_INFTY is a standard SAP Table which is used to store Country specific enhancement for infotypes data and is available within R/3 SAP systems depending on the version and release level.

The PIQDBLOC_INFTY table consists of various fields, each holding specific information or linking keys about Country specific enhancement for infotypes 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP PIQDBLOC_INFTY table 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
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
LOC_DATA 0

Key field Non-key field



How do I retrieve data from SAP table PIQDBLOC_INFTY using ABAP code

The following ABAP code Example will allow you to do a basic selection on PIQDBLOC_INFTY to SELECT all data from the table
DATA: WA_PIQDBLOC_INFTY TYPE PIQDBLOC_INFTY.

SELECT SINGLE *
FROM PIQDBLOC_INFTY
INTO CORRESPONDING FIELDS OF WA_PIQDBLOC_INFTY
WHERE...

How to access SAP table PIQDBLOC_INFTY

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