HRP1890 SAP (DB Table for Infotype 1890) Table details
Dictionary Type: Table
Description: DB Table for Infotype 1890
Description: DB Table for Infotype 1890
Table field list including key, data, relationships and ABAP select examples
HRP1890 is a standard SAP Table which is used to store DB Table for Infotype 1890 data and is available within R/3 SAP systems depending on the version and release level.
The HRP1890 table consists of various fields, each holding specific information or linking keys about DB Table for Infotype 1890 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP HRP1890 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 |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| PLVAR | Plan Version | PLVAR | CHAR | 2 | T778P | PLVAR | POP | ||
| OTYPE | Object Type | OTYPE | CHAR | 2 | T778O | OTYPE | POT | ||
| OBJID | Object ID | HROBJID | NUMC | 8 | PLOGI | HROBJID | PON | ||
| SUBTY | Subtype | SUBTYP | CHAR | 4 | Assigned to domain | SUBTYP | |||
| ISTAT | Planning Status | ISTAT_D | CHAR | 1 | T778S | ISTAT | PST | ||
| BEGDA | Start Date | BEGDATUM | DATS | 8 | DATUM | BEG | |||
| ENDDA | End Date | ENDDATUM | DATS | 8 | DATUM | END | |||
| VARYF | Variation Field for File PLOG | VARYF | CHAR | 10 | CHAR10 | ||||
| SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | NUM03 | ||||
| INFTY | Infotype | INFOTYP | CHAR | 4 | T778T | INFOTYP | HRBAS00INFTY | ||
| OTJID | Concatenation of Object Type and Object ID | OTJID | CHAR | 10 | CHAR10 | ||||
| AEDTM | Changed on | AEDTM | DATS | 8 | DATUM | ||||
| UNAME | User Name | USRNAME | CHAR | 12 | CHAR12 | ||||
| REASN | Reason | REASN | CHAR | 2 | CHAR2 | ||||
| HISTO | Historical Record Flag | HISTO | CHAR | 1 | CHAR1 | ||||
| ITXNR | Text Module for Infotype | ITXNR | NUMC | 8 | NUM08 | ||||
| SC_OBJID | Program ID | PIQSCOBJID | NUMC | 8 | Assigned to domain | HROBJID | PON | ||
| ADM_AYEAR | Academic Year | PIQPERYR | NUMC | 4 | Assigned to domain | PIQPERYR | |||
| ADM_PERID | Academic Session | PIQPERID | NUMC | 3 | Assigned to domain | PIQPERID | |||
| PAIDBY | Paid By | PIQ_NL_PAIDBY | CHAR | 1 | T7PIQ_NL_PAIDBY | PIQ_NL_PAIDBY | |||
| PAYMENTTYPE | Mode of Payment | PIQ_NL_PAYMENTTYPE | CHAR | 1 | T7PIQ_NL_PAYTY | PIQ_NL_PAYMENTTYPE | |||
| PAYMENTNAME | Name of Payee | PIQ_NL_PYMNTNAME | CHAR | 220 | PIQ_NL_PYMNTNAME | ||||
| FORMOFPAYBANKDUT | Account Number (Netherlands) | PIQ_NL_PAYMENTBANKGBA | NUMC | 10 | NUMC10 | ||||
| FORMOFPAYBANKFOR | Account Number (Foreign) | PIQ_NL_PAYMENTBANKFORE | CHAR | 34 | CHAR34 | ||||
| BANK | Name of Bank | PIQ_NL_BANK | CHAR | 50 | PIQ_NL_BANK | ||||
| BANKCOUNTRY | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
| INSTALLMENTS | Installments | PIQ_NL_INSTL | CHAR | 1 | XFELD | ||||
| PAID | Tuition Fee Refundable | PIQ_NL_PAID | CHAR | 1 | PIQ_NL_PAID | ||||
| AMOUNTFEE | Tuition Fee | PIQ_NL_AMOUNTFEE | DEC | 10(2) | PIQ_NL_AMOUNTFEE | ||||
| PROOFFEEPAID | Tuition Fee Paid | PIQ_NL_PROOFPD | CHAR | 1 | XFELD | ||||
| FEE_WAIVER | Fee Waiver | PIQ_NL_FEEWVR | CHAR | 1 | XFELD | ||||
| INVOICE | Invoice | PIQ_NL_INVOICE | CHAR | 1 | XFELD | ||||
| NOOFINST | No. of Installments | PIQ_NL_INSTALMENTS | NUMC | 2 | NUMC2 | ||||
| ADMINFEE | Administration Fee | PIQ_NL_ADMINFEE | DEC | 6(2) | PIQ_NL_ADMINFEE | ||||
| BARCODE | Barcode | PIQ_NL_BARCODE | NUMC | 12 | NUMC12 | ||||
| ORDERNUM | Electronic Payment Order Number | PIQ_NL_ORDERNUMBER | CHAR | 30 | CHAR30 | ||||
| PAIDATBRIN | Paid at BRIN Number | PIQ_NL_PAIDATBRIN | CHAR | 4 | CHAR4 | ||||
| PAIDATINST | Paid at Institute | PIQ_NL_PAIDATINST | CHAR | 70 | CHAR70 | ||||
| DOCNR | Number of Fee Calculation Document | CMAC_FEE_DOCNR | CHAR | 20 | CHAR20 | ||||
| AUTHFEEAMT | Authorized Fee Amount | PIQ_NL_AUTHFEEAMT | DEC | 10(2) | PIQ_NL_AMOUNTFEE | ||||
| AUTHSENT | Payment Authorization Sent | PIQ_NL_AUTHSENT | CHAR | 1 | XFELD | ||||
| AUTHSTACC | Authorization Accepted | PIQ_NL_AUTHSTACC | CHAR | 1 | PIQ_NL_INDICATE | ||||
| AUTHWTDRW | Authorization Withdrawn | PIQ_NL_AUTHWTDRW | CHAR | 1 | XFELD | ||||
| AUTHSENTDATE | Authorization Sent Date | PIQ_NL_AUTHSENTDATE | DATS | 8 | DATUM | ||||
| AUTHSENTTIME | Authorization Sent Time | PIQ_NL_AUTHSENTTIME | TIMS | 6 | UZEIT | ||||
| OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | 80B | |
| ADM_GUID | Unique Key (GUID) of the Admission | PIQADM_GUID | CHAR | 32 | SYSUUID_C | ||||
| PAID_INBRIN | Paid at BRIN Number for an Incoming Proof of Payment | PIQ_NL_INBRIN | CHAR | 4 | CHAR4 | ||||
| BRIN_SEQ | BRIN Sequence Number | PIQ_NL_BRINSEQ | NUMC | 2 | NUMC2 | ||||
| PAID_INSTNAME | Paid at Institute for an Incoming Proof of Payment | PIQ_NL_INSTNAME | CHAR | 70 | CHAR70 | ||||
| INITAMT | Initial Amount | PIQ_NL_INIAMOUNT | CURR | 10(2) | PIQ_NL_AMOUNT | ||||
| VALUTA_INIT | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| INSTAMT | Incoming Proof of Payment Legal Tuition Fee | PIQ_NL_LEGALTUTFEE | CURR | 10(2) | PIQ_NL_AMOUNT | ||||
| VALUTA_INST | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| PRF_INSTATUS | Incoming Proof of Payment Status | PIQ_NL_PINSTATUS | CHAR | 1 | PIQ_NL_PPSTATUS | ||||
| RECEIV_BY | Received By (User Name) | PIQ_NL_RECIEVBY | CHAR | 35 | CHAR35 | ||||
| RECEIPT_DATE | Receipt Date | PIQ_NL_RECEIPTDATE | DATS | 8 | DATS | ||||
| INCANCEL_BY | Incoming Proof of Payment Cancelled By (User Name) | PIQ_NL_INCANCELLEDBY | CHAR | 35 | CHAR35 | ||||
| INCANCEL_ON | Incoming Proof of Payment Cancellation Date | PIQ_NL_INCANCELLEDDATE | DATS | 8 | DATS | ||||
| TOTAL_AMT | Amount | PIQ_NL_AMOUNT | CURR | 10(2) | PIQ_NL_AMOUNT | ||||
| VALUTA_TOT | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| INST_BRIN | Institute BRIN Number | PIQ_NL_BRIN | CHAR | 4 | PIQ_NL_BRINNUMBER | ||||
| PRF_OUTSTATUS | Outgoing Proof of Payment Status | PIQ_NL_POUTSTATUS | CHAR | 1 | PIQ_NL_PPSTATUS | ||||
| REG_BY | Registered By (User Name) | PIQ_NL_REGISTBY | CHAR | 35 | CHAR35 | ||||
| REG_DATE | Registered Date | PIQ_NL_REGISTDATE | DATS | 8 | DATS | ||||
| OUTCANCEL_BY | Outgoing Proof of Payment Cancelled By (User Name) | PIQ_NL_OUTCANCELLEDBY | CHAR | 35 | CHAR35 | ||||
| OUTCANCEL_ON | Outgoing Proof of Payment Cancellation Date | PIQ_NL_OUTCANCELLEDDATE | DATS | 8 | DATS | ||||
| LEGAL_TUTFEE | Outgoing Proof of Payment Legal Tuition Fee | PIQ_NL_OUTLEGALTUTFEE | CURR | 10(2) | PIQ_NL_AMOUNT | ||||
| VALUTA_LEGLFEE | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| INST_TUTFEE | Institute Tuition Fee | PIQ_NL_INSTTUTFEE | CURR | 10(2) | PIQ_NL_AMOUNT | ||||
| VALUTA_INSTFEE | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
| MAND_REFID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
| BIC | SWIFT Code/Bank Identifier Code (BIC) | BICSW_KK | CHAR | 11 | SWIFT | ||||
| TABNR | Reference Number to Table Part | HRTABNR | CHAR | 32 | Assigned to domain | HRTABNR |
| Key field | Non-key field |
How do I retrieve data from SAP table HRP1890 using ABAP code
The following ABAP code Example will allow you to do a basic selection on HRP1890 to SELECT all data from the tableDATA: WA_HRP1890 TYPE HRP1890.
SELECT SINGLE *
FROM HRP1890
INTO CORRESPONDING FIELDS OF WA_HRP1890
WHERE...
How to access SAP table HRP1890
Within an ECC or HANA version of SAP you can also view further information about HRP1890 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects