VRNG12 SAP (IS-H: FI Customer Update Structure) Structure details
Description: IS-H: FI Customer Update Structure
Structure field list including key, data, relationships and ABAP select examples
VRNG12 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "IS-H: FI Customer Update Structure" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_VRNG12 TYPE VRNG12.
The VRNG12 table consists of various fields, each holding specific information or linking keys about IS-H: FI Customer Update Structure data available in SAP. These include LFDNR (IS-H: Sequence Number of Insurance Relationship), NUMKZ (IS-H: (E)xternal or (I)nternal Number Assignment Customer), NO_B_SEGM (Company Code Data Is Missing for Customer), MANDT (Client).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP VRNG12 structure 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 |
LFDNR | IS-H: Sequence Number of Insurance Relationship | LFDVV | NUMC | 3 | LFDVV | ||||
NUMKZ | IS-H: (E)xternal or (I)nternal Number Assignment Customer | ISH_NUMKZ | CHAR | 1 | |||||
NO_B_SEGM | Company Code Data Is Missing for Customer | ISH_NO_B_SEGM | CHAR | 1 | ISH_ON_OFF | ||||
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
EINRI | Institution | EINRI | CHAR | 4 | Assigned to domain | ALPHA | EINRI | EIN | |
KUNNR | Customer Number of FI Customer | RF_KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | |
PATKZ | IS-H: Indicator for Self-Payer Insurance Relationship | ISH_PATKZ | CHAR | 1 | XFELD | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
KTOKD | Customer Account Group | KTOKD | CHAR | 4 | Assigned to domain | KTOKD | KGD | ||
NAME1 | IS-H: Last Name/ 1st Name | GPNAM1 | CHAR | 35 | NAME | NA1 | |||
NAME2 | First Name / Second Name | GPNAM2 | CHAR | 35 | NAME | ||||
NAME3 | Third Name | GPNAM3 | CHAR | 35 | NAME | ||||
ORT | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
ORT2 | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
LAND | Country Key | LAND1_GP | CHAR | 3 | Assigned to domain | LAND1 | C_LAND1 | ||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
TELF1 | IS-H: Telephone Number of Business Partner | TELEFON_GP | CHAR | 16 | TEXT16 | ||||
TELFX | Fax Number of Business Partner | TELEFAX_GP | CHAR | 31 | TEXT31 | ||||
TELEX | Telex Number of Business Partner | TELEX_GP | CHAR | 30 | TEXT30 | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
BANKS | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
BANKL | Bank number | BANKL | CHAR | 15 | BANKL | BLZ | |||
BANKN | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
XEZER | Indicator: Is there collection authorization ? | XEZER | CHAR | 1 | XFELD | ||||
AKONT | Reconciliation Account in General Ledger | AKONT | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
ZUAWA | Key for sorting according to assignment numbers | DZUAWA | CHAR | 3 | Assigned to domain | ZUAWA | |||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
VTEXT | Description of terms of payment | DZTERM_BEZ | CHAR | 30 | TEXT30 | ||||
MAHNA | Dunning Procedure | MAHNA | CHAR | 4 | Assigned to domain | MAHNA | |||
LANDX | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
BANAM | IS-H: Name of Bank | BANAM | CHAR | 35 | TEXT35 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
BEGRS | Authorization Group | BRGRU | CHAR | 4 | Assigned to domain | BRGRU | |||
ZWELS | List of the Payment Methods to be Considered | DZWELS | CHAR | 10 | ZWELS | ||||
BEGRF | Authorization Group | BRGRU | CHAR | 4 | Assigned to domain | BRGRU | |||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
BUSAB_MA | Dunning clerk | BUSAB_MA | CHAR | 2 | Assigned to domain | BUSAB | |||
BUSAB | Accounting clerk | BUSAB | CHAR | 2 | Assigned to domain | BUSAB | |||
TOGRU | Tolerance group for the business partner/G/L account | TOGRU | CHAR | 4 | Assigned to domain | TOGRU | |||
SELBZ | IS-H: Indicator whether Self-Payer or IS-H Customer Created | ISH_SELBZ | CHAR | 1 | XFELD | ||||
MAHNA_2 | Dunning Procedure | MAHNA | CHAR | 4 | Assigned to domain | MAHNA | |||
BUSAB_MA2 | Dunning clerk | BUSAB_MA | CHAR | 2 | Assigned to domain | BUSAB | |||
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
MABER_2 | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
FDGRV | Planning group | FDGRV | CHAR | 10 | Assigned to domain | ALPHA | FDGRP | ||
XZVER | Indicator: Record Payment History ? | XZVER | CHAR | 1 | XFELD | ||||
ZAHLS | Block Key for Payment | DZAHLS | CHAR | 1 | Assigned to domain | ZAHLS | |||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
TITEL | IS-H: Title | RI_TITEL | CHAR | 15 | Assigned to domain | TITEL | |||
NAMZU | IS-H: Name Affix | RI_NAMZU | CHAR | 15 | Assigned to domain | TITEL | |||
VORSW | IS-H: Name Prefix | RI_VORSW | CHAR | 15 | Assigned to domain | TITEL | |||
MGRUP | Key for dunning notice grouping | MGRUP | CHAR | 2 | Assigned to domain | MGRUP | |||
BRSCH | Industry key | BRSCH | CHAR | 4 | Assigned to domain | BRSCH | |||
ALTKN | Previous Master Record Number | ALTKN | CHAR | 10 | CHAR10 | ||||
ADRNR | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ISH_ADRNR | ||
ADROB | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
REGIO | IS-H: Region (Federal State, Province, County) | ISH_REGION | CHAR | 3 | Assigned to domain | REGIO | |||
STRAZ | IS-H: Other Designation Qualifying the Address | ISH_STRASZ | CHAR | 40 | TEXT40 | ||||
EINZG | IS-H: Geographical Area | EINZGEBIET | CHAR | 9 | EINZGEBIET | ||||
LANPF | Country of Post Office Box | ISH_LANDPB | CHAR | 3 | Assigned to domain | LAND1 | |||
ORTPF | IS-H: PO Box City | ISH_CITYPB | CHAR | 40 | TEXT40 | ||||
PSTLF | IS-H: Postal Code of Company (for Major Accounts) | ISH_PSTLZF | CHAR | 10 | PSTLZ | ||||
TELXT | Telephone Number - Extension | ISH_TELEXT | CHAR | 10 | CHAR10 | ||||
FAXXT | IS-H: Fax Number - Extension | ISH_FAXEXT | CHAR | 10 | CHAR10 | ||||
BUILD | IS-H: Block/House | ISH_BUILD | CHAR | 10 | TEXT10 | ||||
FLOOR | IS-H: Block/House Level | ISH_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOM | IS-H: Unit Number | ISH_ROOM | CHAR | 10 | TEXT10 | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
BKONT | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
BKREF | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
KOINH | Account Holder Name | KOINH_FI | CHAR | 60 | KOINH | ||||
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
KNRZA | Account number of an alternative payer | KNRZA | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
VZSKZ | Interest calculation indicator | VZSKZ | CHAR | 2 | T056 | VZSKZ | |||
ZINDT | Key date of the last interest calculation | DZINDT | DATS | 8 | DATUM | ||||
ZINRT | Interest calculation frequency in months | DZINRT | NUMC | 2 | ZINRT | ||||
ZSABE | User at customer | DZSABE_D | CHAR | 15 | TEXT15 | ||||
XAUSZ | Indicator for periodic account statements | XAUSZ | CHAR | 1 | T048K | AUSZG | |||
XZEMP | Indicator: Alternative payee in document allowed ? | XZEMP | CHAR | 1 | XFELD | ||||
PATNR | IS-H: Patient Number | PATNR | CHAR | 10 | Assigned to domain | ALPHA | PATNR | PAT | |
TELF2 | Second telephone number | TELF2 | CHAR | 16 | TEXT16 | ||||
KONZS | Group key | KONZS | CHAR | 10 | KONZS | ||||
COUNC | County Code | COUNC | CHAR | 3 | T005E | COUNC | |||
CITYC | City Code | CITYC | CHAR | 4 | T005G | CITYC | |||
SORT1 | Search Term 1 | AD_SORT1 | CHAR | 20 | CHAR20 | ||||
SORT2 | Search Term 2 | AD_SORT2 | CHAR | 20 | CHAR20 | ||||
HSNM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HSNM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
CITY3 | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
TZONE | Address time zone | AD_TZONE | CHAR | 6 | Assigned to domain | TZNZONE | |||
TXJCD | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
CONAM | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
STREET2 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STREET3 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
STKZN | Natural Person | STKZN | CHAR | 1 | STKZN | ||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
ANREDE | IS-H: Form-of-Address Text | RI_ANTXT | CHAR | 25 | TEXT25 | ||||
TELNR | IS-H: Telephone Number | ISH_TELNR | CHAR | 30 | CHAR30 | ||||
PO_BX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
TITEL1 | IS-H: Title | RI_TITEL | CHAR | 15 | Assigned to domain | TITEL | |||
IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
IBAN_DATE | Validity start of IBAN | IBAN_VALFR | DATS | 8 | DATUM | ||||
KZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | CDCHNGIND |
Key field | Non-key field |
How do I retrieve data from SAP structure VRNG12 using ABAP code?
As VRNG12 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VRNG12 as there is no data to select.How to access SAP table VRNG12
Within an ECC or HANA version of SAP you can also view further information about VRNG12 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