/GSINS/INH_EXTDE SAP (External Transfers (in HCM infotype 0011)) Table details
Dictionary Type: Table
Description: External Transfers (in HCM infotype 0011)
Description: External Transfers (in HCM infotype 0011)
ABAP Code to SELECT data from /GSINS/INH_EXTDE
Related tables to /GSINS/INH_EXTDE
Access table /GSINS/INH_EXTDE
Related tables to /GSINS/INH_EXTDE
Access table /GSINS/INH_EXTDE
Table field list including key, data, relationships and ABAP select examples
/GSINS/INH_EXTDE is a standard SAP Table which is used to store External Transfers (in HCM infotype 0011) data and is available within R/3 SAP systems depending on the version and release level.
The /GSINS/INH_EXTDE table consists of various fields, each holding specific information or linking keys about External Transfers (in HCM infotype 0011) data available in SAP. These include CLAIM (Number of Claim), SUBCLAIM (Subclaim), PARTNER (Business Partner Number), ADD_ID (Timestamp + Sequence Number).. 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 /GSINS/INH_EXTDE 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 | Assigned to domain | MANDT | |||
CLAIM | Number of Claim | ICL_CLAIM | CHAR | 17 | ICLCLAIM | ALPHA | ICL_CLAIM | ICL_CLAIM | ICL_CLAIMNO_COL |
SUBCLAIM | Subclaim | ICL_SUBCL | CHAR | 3 | ICLSUBCL | ICL_SUBCL | ICL_SUBCLAIM | ||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ADD_ID | Timestamp + Sequence Number | /GSINS/INSH_ED_SN | CHAR | 18 | /GSINS/INSH_ED_SN | ||||
STATUS | Status of External Transfer | /GSINS/INSH_ED_STS | CHAR | 1 | /GSINS/INSH_ED_STS | ||||
PAYEE | External Transfer Recipient | /GSINS/INSH_RECIPIENT | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | ||
BENTYPE | Benefit Type | ICL_BENTYPE | CHAR | 10 | /GSINS/INH_B2E_C | ICL_BENTYPE | ICL_BENTYPE | ||
ACCID | Bank details ID | BU_BKVID | CHAR | 4 | BUT0BK | CHAR4 | |||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
INFTY | Infotype | INFTY | CHAR | 4 | INFOTYP | ITP | |||
SUBTY | Subtype | SUBTY | CHAR | 4 | SUBTY | SUB | |||
OBJPS | Object Identification | OBJPS | CHAR | 2 | OBJPS | OPS | |||
SPRPS | Lock Indicator for HR Master Data Record | SPRPS | CHAR | 1 | SPRPS | ||||
ENDDA | End Date | ENDDA | DATS | 8 | DATUM | ||||
BEGDA | Start Date | BEGDA | DATS | 8 | DATUM | ||||
SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | NUM03 | ||||
AEDTM | Changed On | AEDAT | DATS | 8 | DATUM | ||||
UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
HISTO | Historical Record Flag | HISTO | CHAR | 1 | CHAR1 | ||||
ITXEX | Text Exists for Infotype | ITXEX | CHAR | 1 | XFELD | ||||
REFEX | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | XFELD | ||||
ORDEX | Confirmation Fields Exist | ORDEX | CHAR | 1 | XFELD | ||||
ITBLD | Infotype Screen Control | ITBLD | CHAR | 2 | CHAR2 | ||||
PREAS | Reason for Changing Master Data | PREAS | CHAR | 2 | Assigned to domain | PREAS | |||
FLAG1 | Reserved Field/Unused Field | NUSED | CHAR | 1 | NUSED | ||||
FLAG2 | Reserved Field/Unused Field | NUSED | CHAR | 1 | NUSED | ||||
FLAG3 | Reserved Field/Unused Field | NUSED | CHAR | 1 | NUSED | ||||
FLAG4 | Reserved Field/Unused Field | NUSED | CHAR | 1 | NUSED | ||||
RESE1 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | NUSED2 | ||||
RESE2 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | NUSED2 | ||||
GRPVL | Grouping Value for Personnel Assignments | PCCE_GPVAL | CHAR | 4 | PCCE_GPVAL | ||||
LGART | Wage Type | LGART | CHAR | 4 | Assigned to domain | LGART | |||
OPKEN | Operation Indicator for Wage Types | OPKEN | CHAR | 1 | OPKEN | ||||
BETRG | Wage Type Amount for Payments | PAD_AMT7S | CURR | 13(2) | P_AMT07V | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
ANZHL | Number | ANZHL | DEC | 7(2) | ANZHL | ||||
ZEINH | Time/Measurement Unit | PT_ZEINH | CHAR | 3 | Assigned to domain | RPMSH | |||
ZDATE | First payment date | DZDATE | DATS | 8 | DATUM | ||||
ZFPER | First payment period | DZFPER | NUMC | 2 | PABRP | ||||
ZANZL | Number for determining further payment dates | DZANZL | DEC | 3 | DEC3 | ||||
ZEINZ | Time unit for determining next payment | DZEINZ | CHAR | 3 | Assigned to domain | RPMSH | |||
PRITY | Priority | PPRIO | CHAR | 1 | PRITY | ||||
EMFSL | Payee key for bank transfers | EMFSL | CHAR | 8 | EMFSL | ||||
EMFTX | Payee Text | EMFTX | CHAR | 40 | TEXT40 | ||||
BKPLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
BKORT | City | ORT01 | CHAR | 25 | TEXT25 | ||||
BANKS | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
BANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
BANKN | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BANKP | Check Digit for Bank No./Account | BANKP | CHAR | 2 | BANKP | ||||
BKONT | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
SWIFT | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | Assigned to domain | DTAWS | |||
DTAMS | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | DTAMS | ||||
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
PSKTO | Account Number of Bank Account At Post Office | PSKTO | CHAR | 16 | PSKTO | ||||
ESRNR | ISR Subscriber Number | ESRNR | CHAR | 11 | ESRNR | ||||
ESRRE | ISR Reference Number | ESRRE | CHAR | 27 | ALPHA | ESRRE | |||
ESRPZ | ISR Check Digit | ESRPZ | CHAR | 2 | CHAR2 | ||||
ZWECK | Purpose of Bank Transfers | DZWECK | CHAR | 40 | TEXT40 | ||||
ZLSCH | Payment Method | PCODE | CHAR | 1 | Assigned to domain | ZLSCH | |||
UWDAT | Date of Bank Transfer | UWDAT | DATS | 8 | DATUM | ||||
BKREF | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
STRAS | House number and street | STRAS | CHAR | 30 | TEXT30 | ||||
STATE | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
ENDDA_NEW | Proposed End Date | /GSINS/INSH_ENDDA_NEW | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP table /GSINS/INH_EXTDE using ABAP code
The following ABAP code Example will allow you to do a basic selection on /GSINS/INH_EXTDE to SELECT all data from the tableDATA: WA_/GSINS/INH_EXTDE TYPE /GSINS/INH_EXTDE.
SELECT SINGLE *
FROM /GSINS/INH_EXTDE
INTO CORRESPONDING FIELDS OF WA_/GSINS/INH_EXTDE
WHERE...
How to access SAP table /GSINS/INH_EXTDE
Within an ECC or HANA version of SAP you can also view further information about /GSINS/INH_EXTDE 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