NVBRK SAP (IS-H: Billing document header data) Table details
Dictionary Type: Table
Description: IS-H: Billing document header data
Description: IS-H: Billing document header data
Table field list including key, data, relationships and ABAP select examples
NVBRK is a standard SAP Table which is used to store IS-H: Billing document header data data and is available within R/3 SAP systems depending on the version and release level.
The NVBRK table consists of various fields, each holding specific information or linking keys about IS-H: Billing document header data data available in SAP. These include VBELN (Billing Document), FKART (Billing Type), FKTYP (IS-H: Billing Category (Provisional, Final)), FKHKT (IS-H: Source of billing document).. 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 (character-type or numeric)
SAP NVBRK 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 | |||
| VBELN | Billing Document | VBELN_VF | CHAR | 10 | VBUK | ALPHA | VBELN | VF | |
| FKART | Billing Type | FKART | CHAR | 4 | TVFK | FKART | |||
| FKTYP | IS-H: Billing Category (Provisional, Final) | ISH_FKTYP | CHAR | 1 | ISH_FKTYP | ||||
| FKHKT | IS-H: Source of billing document | ISH_FKHKT | CHAR | 1 | ISH_FKHKT | ||||
| VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
| WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
| VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
| KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | T683 | KALSM | |||
| KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
| FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
| PLTYP | Price list type | PLTYP | CHAR | 2 | T189 | PLTYP | VPL | ||
| RFBSK | Status for transfer to accounting | RFBSK | CHAR | 1 | RFBSK | ||||
| KURRF | Exchange rate for FI postings | KURRF | DEC | 9(5) | KURRF | ||||
| CPKUR | ID:Exchange rate setting (no new rate determ.in bill.doc.) | CPKUR | CHAR | 1 | CPKUR | ||||
| VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
| VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
| ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | T042Z | ZLSCH | |||
| KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | TVKT | KTGRD | |||
| LAND1 | Country of Destination | LLAND | CHAR | 3 | T005 | LAND1 | VLL | ||
| REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
| COUNC | County Code | COUNC | CHAR | 3 | T005E | COUNC | |||
| CITYC | City Code | CITYC | CHAR | 4 | T005G | CITYC | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| TAXK1 | Tax classification 1 for customer | TAXK1 | CHAR | 1 | Assigned to domain | TAXKD | |||
| TAXK2 | Tax classification 2 for customer | TAXK2 | CHAR | 1 | Assigned to domain | TAXKD | |||
| TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1 | Assigned to domain | TAXKD | |||
| TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | Assigned to domain | TAXKD | |||
| TAXK5 | Tax classification 5 for customer | TAXK5 | CHAR | 1 | Assigned to domain | TAXKD | |||
| TAXK6 | Tax classification 6 for customer | TAXK6 | CHAR | 1 | Assigned to domain | TAXKD | |||
| TAXK7 | Tax classification 7 for customer | TAXK7 | CHAR | 1 | Assigned to domain | TAXKD | |||
| TAXK8 | Tax classification 8 for customer | TAXK8 | CHAR | 1 | Assigned to domain | TAXKD | |||
| TAXK9 | Tax classification 9 for customer | TAXK9 | CHAR | 1 | Assigned to domain | TAXKD | |||
| NETWR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
| ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
| KUNRG | Payer | KUNRG | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
| KUNAG | Sold-to party | KUNAG | CHAR | 10 | KNA1 | ALPHA | KUNNR | VAG | |
| MABER | Dunning Area | MABER | CHAR | 2 | T047M | MABER | |||
| AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
| SFAKN | Cancelled billing document number | SFAKN | CHAR | 10 | VBUK | ALPHA | VBELN | VF | |
| KURST | Exchange Rate Type | KURST | CHAR | 4 | TCURV | KURST | KUT | ||
| MSCHL | Dunning key | MSCHL | CHAR | 1 | T040 | MSCHL | |||
| MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
| SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
| HITYP_PR | Hierarchy type for pricing | HITYP_PR | CHAR | 1 | THIT | HITYP | |||
| KAPPL | Application | KAPPL | CHAR | 2 | Assigned to domain | KAPPL | KAP | ||
| LANDTX | Tax departure country | LANDTX | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
| XBLNR | Reference Document Number | XBLNR_V1 | CHAR | 16 | XBLNR1 | ||||
| ZUONR | Assignment number | ORDNR_V | CHAR | 18 | ZUONR | ||||
| MWSBK | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
| LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| FKSTO | IS-H: Invoice Is Canceled (Fully/Partially) | ISH_FKSTO | CHAR | 1 | ISH_FKSTO | ||||
| EINRI | Institution (Especially Required for Billing) | EINRIF | CHAR | 4 | ALPHA | EINRIF | |||
| ORGID | Identification Key of Organizational Unit | ORGID | CHAR | 8 | Assigned to domain | ALPHA | ORGID | OGE | |
| FALAR | IS-H: Case Type | FALLARTF | CHAR | 1 | FALLART | ||||
| FALNR | IS-H: Case Number (Required for Billing) | FALNRF | CHAR | 10 | ALPHA | FALNRF | |||
| KOSTR | IS-H: Insurance Provider | KH_KOSTRF | CHAR | 10 | ALPHA | KH_KOSTRF | KOT | ||
| KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | KOSTR_ARTF | CHAR | 3 | ALPHA | KOSTR_ARTF | |||
| LFDVV | IS-H: Sequence Number of Insurance Relationship | LFDVV | NUMC | 3 | LFDVV | ||||
| DATZW | IS-H: Date up to which Interim Billing Is to Be Performed | ISH_ZWIABR_DAT | DATS | 8 | RI_DATUM | ||||
| SAMNR | IS-H: Collective Invoice Number | ISH_VBELNS | CHAR | 10 | Assigned to domain | ALPHA | VBELN | SAR | SANR |
| FPKZF | IS-H: Ind. whether the Case Has a Flat Rate (at Least 1) | ISH_FPKZ | CHAR | 1 | XFELD | ||||
| SEKZF | Procedure Surcharge Is Defined for Case (at Least 1) | ISH_SEKZ | CHAR | 1 | XFELD | ||||
| AKRKZ | IS-H: Billing Indicator for Invoice | ABRKZ_FK | CHAR | 1 | ABRKZ_FK | ||||
| EMTYP | IS-H: Employee Type | ISH_EMTYPE | CHAR | 2 | Assigned to domain | ALPHA | ISH_EMTYPE | ||
| LFDBEW | IS-H: Sequence Number of Movement | LFDBEW | NUMC | 5 | Assigned to domain | LFDBEW | |||
| ISHSTOID | IS-H: Reason for Canceling Billing Document | ISH_FAKSTOID | CHAR | 3 | Assigned to domain | N1STOID | N_FAKSTO | ||
| FALRN | IS-H SG: Logical invoice number | ISH_VBELNF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
| RESID | Indicator That Patient Is Non-Resident | ISH_RESID | CHAR | 1 | XFELD | ||||
| KTARI | IS-H NL: Internal insurance provider type | ISH_KTARTI | CHAR | 4 | ALPHA | ISH_KTARTI | |||
| ADINS | IS-H NL: Supplementary Insurance Indicator (NL) | ISH_ADINS | CHAR | 1 | XFELD | ||||
| FORNR | Subsequent Invoice Number for Invoice Split | ISH_FORNR | NUMC | 2 | NUMC2 |
| Key field | Non-key field |
How do I retrieve data from SAP table NVBRK using ABAP code
The following ABAP code Example will allow you to do a basic selection on NVBRK to SELECT all data from the tableDATA: WA_NVBRK TYPE NVBRK.
SELECT SINGLE *
FROM NVBRK
INTO CORRESPONDING FIELDS OF WA_NVBRK
WHERE...
How to access SAP table NVBRK
Within an ECC or HANA version of SAP you can also view further information about NVBRK 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