SAP Netherlands Tables

Are you looking for the right table related to SAP Netherlands Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Netherlands (IS-HER-CM-NL) module.

Top 10 tables in Netherlands

TableDescription
T7PIQ_NL_CTRYMMapping for NL Country codes and Nationalities
T7PIQ_NL_PRESUBPrevious Education Subject Details
T7PIQ_NL_BRINLOCMapping for Location object to BRIN number and BRIN sequence
HRT1891Table Part Infotype 1891
HRP1890DB Table for Infotype 1890
PIQDB_NL_IBGTFCRIHO: Legal Tuition Fees
HRP1893DB Table for Infotype 1893
PIQDB_NL_DUOTUITTuition fee
HRT1894Table Part Infotype 1894
PIQDB_NL_DUOILOGDUO Incoming Message Error Log Table

List of tables in Netherlands

TableDescription
T7PIQ_NL_CTRYMMapping for NL Country codes and Nationalities
T7PIQ_NL_PRESUBPrevious Education Subject Details
T7PIQ_NL_BRINLOCMapping for Location object to BRIN number and BRIN sequence
HRT1891Table Part Infotype 1891
HRP1890DB Table for Infotype 1890
PIQDB_NL_IBGTFCRIHO: Legal Tuition Fees
HRP1893DB Table for Infotype 1893
PIQDB_NL_DUOTUITTuition fee
HRT1894Table Part Infotype 1894
PIQDB_NL_DUOILOGDUO Incoming Message Error Log Table
T7PIQ_NL_ENRFOMTEnrollment form code texts
T7PIQ_NL_EDUPHAEducation program phase code
T7PIQ_NL_LTESTLanguage Test
PIQDB_NL_IBGHIBG History
T7PIQ_NL_FMRELTStatus of Relationship Descriptions
HRP1894DB Table for Infotype 1894
T7PIQ_NL_ENRSMMapping for Enrollment Status
T7PIQ_NL_ENRLSTTEnrollment Status Texts
T7PIQ_NL_LOTRESTLottery Result
T7PIQ_NL_PREEDUTPrevious Education Code Text
PIQDB_NL_DUOINERTable for storing errors of incoming messages in BRONHO
T7PIQ_NL_REJECTTReason for Rejection
T7PIQ_NL_VERSTAPersonal Data Cerification Status
T7PIQ_NL_REJECTReason for Rejection
T7PIQ_NL_WSTAT_TWaiting List Statuses Description
T7PIQ_NL_SUBMAPMapping table for subjects
PIQDB_NL_LOTTERYStudent's Data for Lottery Process
T7PIQ_NL_EDUPHAMMapping for Education phase code to Registration type
T7PIQ_NL_ACTYTActivity Status Texts
T7PIQ_NL_CRIPCTCRIHO Processing Codes Texts
T7PIQ_NL_FMRELMMapping for Status of Relationship
PIQDB_NL_ADDRMaintain GBA Address
T7PIQ_NL_VERSTATPersonal Details Verification Status Texts
T7PIQ_NL_VERCERTDiploma Status
T7PIQ_NL_DUODREGDeregistration Reason
T7PIQ_NL_LTDRWLottery Draw
PIQDB_NL_DUOMERDUO Message Error
T7PIQ_NL_LETTERPrevious Education Subject Letter
PIQDB_NL_DPRGStudents Without Addtional Admission Details
T7PIQ_NL_STCDTState Codes
T7PIQ_NL_CRIPCCRIHO Processing Codes
PIQDB_NL_OELDuo Outgoing Error Message
T7PIQ_NL_CRISCTCRIHO Signal Codes Texts
PIQDB_NL_DUOMSGDUO Messages
T7PIQ_NL_EDUPGMEducational Program Details
T7PIQ_NL_CMPREQTComplementary Requirements Text
PIQDB_NL_INLOGError log of the Incoming messages
T7PIQ_NL_VERSUBVerification Subject Status
PIQDB_NL_GRDCRIHO - IBG Tuition Fee ( Graduation Data )
PIQDB_NL_TKGCRIHO - IBG Tuition Fee ( Return Data )
PIQDB_NL_FBPCRIHO - IBG Tuition Fee ( Functional Limitation Data )
T7PIQ_NL_EDUCEducation Details
T7PIQ_NL_PREEDUPrevious Education Signal Code
T7PIQ_NL_TMATEReason for Termination
T7PIQ_NL_COBJMaintain Contract Object Types for Fee Calculation
T7PIQ_NL_VERCERDiploma Status
T7PIQ_NL_RESERVReason for Reservation
T7PIQ_NL_EDUMAPMap Studielink Educational Program to SLcM Program of Study
T7PIQ_NL_ENRLSTEnrollment Status
T7PIQ_NL_DFCYDeficiency Status
PIQDB_NL_CRIHOCRIHO Changes
PIQDB_NL_ISGCRIHO - IBG Tuition Fee ( Registration Data )
T7PIQ_NL_LTRYTLottery Texts
T7PIQ_NL_INSBRINBRIN Number of the Institute
T7PIQ_NL_ERCDTExam Reuslt Codes
PIQDB_NL_DUODEFTDefrayment Statuses
HRT1890Table Part Infotype 1890
HRP1891DB Table for Infotype 1891
T7PIQ_NL_ENRFOMEnrollment form code
T7PIQ_NL_CRISCCRIHO Signal Codes
T7PIQ_NL_ACTYActivity Status
T7PIQ_NL_IBGSTTIBG Groep Status
PIQDB_NL_DUOTUIDUO Tuition Fee Details
T7PIQ_NL_STCDMMap State Codes to Region
HRP1892DB Table for Infotype 1892
T7PIQ_NL_ENRNMMapping Table for Year/ Session and Enrollment Moment Code
T7PIQ_NL_PAYTYTPayment Type Text
T7PIQ_NL_ERCDExam Reuslt Codes
T7PIQ_NL_VRFCDSignal Codes
PIQDB_NL_OUTLOGStatus log of the Outgoing messages
T7PIQ_NL_VRFCDTVerification Code Text
HRT1892Table Part Infotype 1892
T7PIQ_NL_INSTMMapping for BRIN number to Org. Unit and Ext. Oraganization
T7PIQ_NL_PREMAPMapping for Previous education to the External Qualification
T7PIQ_NL_LTRYLottery
T7PIQ_NL_SMTRGTrigger CRIHO Messages
T7PIQ_NL_COUNTRYCountries
T7PIQ_NL_LOTDRAWApplication period second lottery drawing
T7PIQ_NL_DFCYTDeficiency Status Text
T7PIQ_NL_SFCSudent Fee Category
HRT1893Table Part Infotype 1893
T7PIQ_NL_PAYTYPayment Type
T7PIQ_NL_PAIDBYTPaid By Person
T7PIQ_NL_VERSUBTVerification Subject Status
T7PIQ_NL_PREEDUCPrevious Education Details
PIQDB_NL_ERRLOGError log table for Incoming messages
T7PIQ_NL_RESERVTReason for Reservation - Text Table
T7PIQ_NL_CMPREQComplemetary Requirements
PIQDB_NL_DEREGNL Deregistration Details
T7PIQ_NL_NATITYNationalities
T7PIQ_NL_STCDState Codes
PIQDB_NL_DUODEFPreliminary details
T7PIQ_NL_NUFFICNuffic Entries
T7PIQ_NL_STR_TYPMaintain the Active Struture for BRON-HO Messages
T7PIQ_NL_SUBSubjects
T7PIQ_NL_IBGSTIBG Groep Status
T7PIQ_NL_ADMREQAdmission Requirements
T7PIQ_NL_VISADEFMapping Visa and Residence Status for Visa defrayment
T7PIQ_NL_SFCTSudent Fee Category
T7PIQ_NL_EDUPHATEducation program phase code descriptions
T7PIQ_NL_LTDRWTLottery Draw Texts
T7PIQ_NL_LTESTTLanguage Test Text
T7PIQ_NL_NUMBERTPrevious Education Subject Number Texts
T7PIQ_NL_RESSTResidential Status
T7PIQ_NL_FMRELStatus of Relationships
T7PIQ_NL_LOTRESLottery Result
T7PIQ_NL_PAIDBYPaid By Person
T7PIQ_NL_STR_TYMaintain the active struture (Obselete Not to be used!)
T7PIQ_NL_SFCMMapping: Student Fee Category
T7PIQ_NL_TMATETReason for Termination
T7PIQ_NL_WSTATUSWaiting List Statuses
T7PIQ_NL_RESIDMMapping for SLM Residence Status to SL Status of residence
T7PIQ_NL_UPDCHKCheck the Fields for Updating
T7PIQ_NL_INSTITInstitutes and Education Details
T7PIQ_NL_LETTERTPrevious Education Subject Letter Texts
T7PIQ_NL_NUMBERPrevious Education Subject Number