SAP T7PIQ_NL_INSTIT table - Institutes and Education Details details in SAP

SAP T7PIQ_NL_INSTIT table summary

Object Name: T7PIQ_NL_INSTIT
Dictionary Type: Transparent table
Description: Institutes and Education Details

Field list for T7PIQ_NL_INSTIT table on an S/4 SAP system

Details

T7PIQ_NL_INSTIT-MANDT table field - Client ▼

Description: Client
Field Name: MANDT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MANDT

T7PIQ_NL_INSTIT-BRINNUMBER table field - BRIN Number ▼

Description: BRIN Number
Field Name: BRINNUMBER
Data Element: PIQ_NL_BRINNUMBER
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: PIQ_NL_BRINNUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BRINNUMBER

T7PIQ_NL_INSTIT-TRAIT table field - Trait ▼

Description: Trait
Field Name: TRAIT
Data Element: PIQ_NL_TRAIT
Data Type: NUMC
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: NUMC1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRAIT

T7PIQ_NL_INSTIT-BEGINDATE table field - Start Date ▼

Description: Start Date
Field Name: BEGINDATE
Data Element: BEGDA
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BEGINDATE

T7PIQ_NL_INSTIT-CHANGEDATE table field - Last Changed On ▼

Description: Last Changed On
Field Name: CHANGEDATE
Data Element: CHANGDATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGEDATE

T7PIQ_NL_INSTIT-BRINSEQUENCE table field - BRIN Sequence Number ▼

Description: BRIN Sequence Number
Field Name: BRINSEQUENCE
Data Element: PIQ_NL_BRINSEQUENCE
Data Type: NUMC
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: NUMC2
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BRINSEQUENCE

T7PIQ_NL_INSTIT-ENDDATE table field - End Date ▼

Description: End Date
Field Name: ENDDATE
Data Element: ENDDA
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ENDDATE

T7PIQ_NL_INSTIT-INSTNAMELONG table field - Institute Name ▼

Description: Institute Name
Field Name: INSTNAMELONG
Data Element: PIQ_NL_INSTITUTENAME
Data Type: CHAR
length (Dec): 70(0)
Check table:
Conversion Routine:
Domain Name: CHAR70
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSTNAMELONG

T7PIQ_NL_INSTIT-INSTNAMESHORT table field - Name of the Supplying Instituition ▼

Description: Name of the Supplying Instituition
Field Name: INSTNAMESHORT
Data Element: PIQ_NL_BRINSHORT
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: CHAR35
MemoryID:
AppClass: MW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSTNAMESHORT

T7PIQ_NL_INSTIT-DEFRAYMENTCODE table field - Defrayment Code ▼

Description: Defrayment Code
Field Name: DEFRAYMENTCODE
Data Element: PIQ_NL_DEFRAYMENT
Data Type: NUMC
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: PIQ_NL_DEFRAYMENT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEFRAYMENTCODE

T7PIQ_NL_INSTIT-STREET1 table field - Street ▼

Description: Street
Field Name: STREET1
Data Element: AD_STREET
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: TEXT60
MemoryID:
AppClass: SAP
SHLP: CLSTRTNAME
SHLP Field: STREET
ConvExit:

See all SAP tables containing field STREET1

T7PIQ_NL_INSTIT-HOUSENUMBER1 table field - House Number ▼

Description: House Number
Field Name: HOUSENUMBER1
Data Element: AD_HSNM1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSENUMBER1

T7PIQ_NL_INSTIT-HOUSENUMREF1 table field - House number supplement ▼

Description: House number supplement
Field Name: HOUSENUMREF1
Data Element: AD_HSNM2
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSENUMREF1

T7PIQ_NL_INSTIT-LOCATIONREF1 table field - Street 5 ▼

Description: Street 5
Field Name: LOCATIONREF1
Data Element: AD_LCTN
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCATIONREF1

T7PIQ_NL_INSTIT-POSTCODE1 table field - City postal code ▼

Description: City postal code
Field Name: POSTCODE1
Data Element: AD_PSTCD1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTCODE1

T7PIQ_NL_INSTIT-CITY1 table field - City ▼

Description: City
Field Name: CITY1
Data Element: AD_CITY1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLCITYNAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field CITY1

T7PIQ_NL_INSTIT-STREET2 table field - Street ▼

Description: Street
Field Name: STREET2
Data Element: AD_STREET
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: TEXT60
MemoryID:
AppClass: SAP
SHLP: CLSTRTNAME
SHLP Field: STREET
ConvExit:

See all SAP tables containing field STREET2

T7PIQ_NL_INSTIT-HOUSENUMBER2 table field - House Number ▼

Description: House Number
Field Name: HOUSENUMBER2
Data Element: AD_HSNM1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSENUMBER2

T7PIQ_NL_INSTIT-HOUSENUMREF2 table field - House number supplement ▼

Description: House number supplement
Field Name: HOUSENUMREF2
Data Element: AD_HSNM2
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSENUMREF2

T7PIQ_NL_INSTIT-LOCATIONREF2 table field - Street 5 ▼

Description: Street 5
Field Name: LOCATIONREF2
Data Element: AD_LCTN
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCATIONREF2

T7PIQ_NL_INSTIT-POSTCODE2 table field - City postal code ▼

Description: City postal code
Field Name: POSTCODE2
Data Element: AD_PSTCD1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTCODE2

T7PIQ_NL_INSTIT-CITY2 table field - City ▼

Description: City
Field Name: CITY2
Data Element: AD_CITY1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLCITYNAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field CITY2

T7PIQ_NL_INSTIT-MUNICIPALITY table field - City ▼

Description: City
Field Name: MUNICIPALITY
Data Element: AD_CITY1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLCITYNAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field MUNICIPALITY

T7PIQ_NL_INSTIT-PHONE table field - Telephone no.: dialling code+number ▼

Description: Telephone no.: dialling code+number
Field Name: PHONE
Data Element: AD_TLNMBR
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PHONE

T7PIQ_NL_INSTIT-FAX table field - Fax number: dialling code+number ▼

Description: Fax number: dialling code+number
Field Name: FAX
Data Element: AD_FXNMBR
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAX

T7PIQ_NL_INSTIT-EMAIL table field - E-Mail Address ▼

Description: E-Mail Address
Field Name: EMAIL
Data Element: AD_SMTPADR
Data Type: CHAR
length (Dec): 241(0)
Check table:
Conversion Routine: SXIDN
Domain Name: AD_SMTPADR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: SXIDN

See all SAP tables containing field EMAIL

T7PIQ_NL_INSTIT-WEB table field - E-Mail Address ▼

Description: E-Mail Address
Field Name: WEB
Data Element: AD_SMTPADR
Data Type: CHAR
length (Dec): 241(0)
Check table:
Conversion Routine: SXIDN
Domain Name: AD_SMTPADR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: SXIDN

See all SAP tables containing field WEB

View list of all SAP tables(S4H/ECC)

Select data from SAP table