ISH_VBRK_DETAIL SAP (IS-H: VBRK with Extra Details) Structure details
Description: IS-H: VBRK with Extra Details
Related tables to ISH_VBRK_DETAIL
Access table ISH_VBRK_DETAIL
Structure field list including key, data, relationships and ABAP select examples
ISH_VBRK_DETAIL 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: VBRK with Extra Details" 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_ISH_VBRK_DETAIL TYPE ISH_VBRK_DETAIL.
The ISH_VBRK_DETAIL table consists of various fields, each holding specific information or linking keys about IS-H: VBRK with Extra Details data available in SAP. These include MANDT (Client), VBELN (Billing Document), FKART (Billing Type), FKTYP (Billing category).. 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 or numeric)
SAP ISH_VBRK_DETAIL 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 |
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 | Billing category | FKTYP | CHAR | 1 | FKTYP | ||||
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 | ||||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | TVSB | VSBED | |||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
KONDA | Price group (customer) | KONDA | CHAR | 2 | T188 | KONDA | VKA | ||
KDGRP | Customer group | KDGRP | CHAR | 2 | T151 | KDGRP | VKD | ||
BZIRK | Sales district | BZIRK | CHAR | 6 | T171 | BZIRK | BZI | ||
PLTYP | Price list type | PLTYP | CHAR | 2 | T189 | PLTYP | VPL | ||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
EXPKZ | Export indicator | EXPKZ | CHAR | 1 | EXPKZ | ||||
RFBSK | Status for transfer to accounting | RFBSK | CHAR | 1 | RFBSK | ||||
MRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | XFELD | ||||
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 | ||||
ZUKRI | Combination criteria in the billing document | DZUKRI | CHAR | 40 | CHAR40 | ||||
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 | ||||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | Assigned to domain | ALPHA | STAFO | MCF | |
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 | |||
STWAE | Statistics currency | STWAE | CUKY | 5 | TCURC | WAERS | |||
EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | EIKP | EXNUM | |||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
SFAKN | Cancelled billing document number | SFAKN | CHAR | 10 | VBUK | ALPHA | VBELN | VF | |
KNUMA | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | KONA | ALPHA | KNUMA | VMBO | |
FKART_RL | Invoice list type | FKART_RL | CHAR | 4 | TVFK | FKART | |||
FKDAT_RL | Billing date for the invoice list | FKDAT_RL | DATS | 8 | DATUM | ||||
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 | |
KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
KNKLI | Customer's account number with credit limit reference | KNKLI | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
CMWAE | Currency key of credit control area | WAERS_CM | CUKY | 5 | TCURC | WAERS | |||
CMKUF | Credit data exchange rate at billing document rate | CMKUF | DEC | 9(5) | KURRF | ||||
HITYP_PR | Hierarchy type for pricing | HITYP_PR | CHAR | 1 | THIT | HITYP | |||
BSTNK_VF | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
FKART_AB | Accrual billing type | FKART_AB | CHAR | 4 | Assigned to domain | FKART | |||
KAPPL | Application | KAPPL | CHAR | 2 | Assigned to domain | KAPPL | KAP | ||
LANDTX | Tax departure country | LANDTX | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
STCEG_H | Origin of sales tax ID number | STCEG_H | CHAR | 1 | STCEG_H | ||||
STCEG_L | Country of Sales Tax ID Number | STCEG_L | 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 | Billing document is cancelled | FKSTO | CHAR | 1 | XFELD | ||||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
RPLNR | Number of payment card plan type | RPLNR | CHAR | 10 | FPLA | FPLNR | |||
LCNUM | Financial doc. processing: Internal financial doc. number | LCNUM | CHAR | 10 | AKKP | ALPHA | LCNUM | AKN | |
J_1AFITP | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITP | J_1AFITP | |||
KURRF_DAT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
AKWAE | Currency key for letter-of-credit procg in foreign trade | AKWAE | CUKY | 5 | TCURC | WAERS | FWS | ||
AKKUR | Exchange rate for letter-of-credit procg in foreign trade | AKKUR | DEC | 9(5) | KURRF | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
NUMPG | Number of pages of invoice | J_1ANOPG | NUMC | 3 | J_1ANOPG | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | J_1BBRANCH | |||
VKONT | Contract Account Number | CORR_VKONT_KK | CHAR | 12 | ALPHA | CORR_VKONT_KK | |||
FKK_DOCSTAT | Additional Status Transfer to Fin. Accounting (Res. RFBSK) | DOCSTAT_KK | CHAR | 1 | DOCSTAT_KK | ||||
NRZAS | Character Field of Length 12 | CHAR12 | CHAR | 12 | CHAR12 | ||||
SPE_BILLING_IND | EWM Billing Indicator | /SPE/DE_BILLING_IND | CHAR | 1 | /SPE/DE_BILLING_IND | ||||
VTREF | Reference Specifications from Contract | CORR_VTREF_KK | CHAR | 20 | ALPHA | CORR_VTREF_KK | |||
FK_SOURCE_SYS | Source System | FK_SOURCE_SYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
FKTYP_CRM | Billing Category in CRM | FKTYP_CRM | CHAR | 1 | FKTYP | ||||
STGRD | Reason for Reversal | STGRD | CHAR | 2 | T041C | STGRD | FSG | ||
VBTYP_EXT | Extension of SD Document Category | TDD_VBTYP_EXT | CHAR | 4 | DOM_VBTYP_EXT | ||||
.INCLU--AP | 0 | ||||||||
DPC_REL | Flag: DPC relevant | /SAPPCE/DPC_REL | CHAR | 1 | CHAR01 | ||||
.INCLU--AP | 0 | ||||||||
AD01BASDOC | Initial document | AD01BASDOC | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
AD01FAREG | Rule for billing | AD01FAREG | CHAR | 1 | AD01FAREG | ||||
.INCLU--AP | 0 | ||||||||
VCHRNMBR | Voucher Number | AD04VCHNR | NUMC | 8 | AD04VCHNR | ||||
.INCLU--AP | 0 | ||||||||
SWENR | Business Entity Number | HB_SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | |
SMENR | Number of Sales Unit | HB_SMENR | CHAR | 8 | VIMI01 | SMENR | SMENR | MEH | |
PHASE | Sales Phase | HB_SPHSE | CHAR | 11 | HBSSPH | HBS_PHASE | |||
MTLAUR | Marker for Low Income Housing | HB_MTLAUR | CHAR | 1 | CHBSNCM | HBS_MTLAUR | |||
STAGE | Construction Stage | HB_STAGE | INT4 | 10 | INT4 | ||||
HB_CONT_REASON | Contingency data | HB_CONT | CHAR | 2 | CHAR2 | ||||
HB_EXPDATE | Expiration date | HB_EXP | DATS | 8 | DATS | ||||
HB_RESDATE | Resolution date | HB_RES | DATS | 8 | DATS | ||||
.INCLU--AP | 0 | ||||||||
J_3GKBAUL | ETM-Relevant Indicator | J_3GKBAUL | CHAR | 1 | J_3GKBAUL | ||||
J_3GKENIE | Indicator for I(nternal) or E(xternal) Posting | J_3GKENIE | CHAR | 1 | J_3GKENIE | ||||
KUNWE | Ship-to party | KUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
.INCLU--AP | 0 | ||||||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
PAY_TYPE | SEPA: Transaction Type | SEPA_PAY_TYPE | CHAR | 1 | SEPA_PAY_TYPE | ||||
SEPON | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | SD_SEPA_FLAG | ||||
MNDVG | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | SD_SEPA_FLAG | ||||
.INCLU--AP | 0 | ||||||||
SPPAYM | Payment Form for Special Payment Method | SPPAYM | CHAR | 2 | SPPAYM | ||||
SPPORD | Sales Order for Special Payment Method | SPPORD | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
.INCLU--AP | 0 | ||||||||
DRDAT | IS-H: Date Invoice Printed | ISH_DRDAT | DATS | 8 | DATUM | ||||
EDIDAT | IS-H: EDI Transmission Date | ISH_EDIDAT | DATS | 8 | DATS | ||||
DRUCK | IS-H: Invoice Already Printed | ISH_DRUCK | CHAR | 1 | XFELD | ||||
ARCHIV | IS-H: Invoice Has Been Archived | ISH_ARCHIV | CHAR | 1 | CHAR1 | ||||
BRUWR | IS-H: Gross Value of Billing Item in Document Currency | ISH_BRUWR | CURR | 11(2) | ISH_WERTV6 | ||||
INVSTA | IS-H: Invoice Status (Canellation Doc. Invoice, Prov.Inv.) | 0 | |||||||
AUGDT | Clearing Date | AUGDT | DATS | 8 | DATUM | ||||
PROVBILL | IS-H: 'Provisional Invoice' Indicator | 0 | |||||||
WAERK_LOCAL | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
NETWR_LOCAL | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
BRUWR_LOCAL | IS-H: Gross Value of Billing Item in Document Currency | ISH_BRUWR | CURR | 11(2) | ISH_WERTV6 | ||||
STORN | IS-H: Cancellation Indicator | 0 | |||||||
AKTIV | IS-H: Indicator for Active Invoice | ISH_REAKTIV | CHAR | 1 | CHAR01 | ||||
KUNRG_NAME | IS-H: Short Name of Business Partner | KZNAME | CHAR | 12 | ISH_C12 | ||||
ANZU | IS-H: Indicator for Copayment/Down Payment | ISH_ANZU | CHAR | 1 | ISH_ZUANZ | ||||
RFBSK_TXT | Short Text for Fixed Values | VAL_TEXT | CHAR | 60 | DDTEXT | ||||
CLEARED | IS-H: Clearing of Receivables through Incoming Payments | ISH_CLEAR | CHAR | 1 | CHAR01 | ||||
STORN_TXT | Text for Cancellation Reason | N1STOTX | CHAR | 15 | N1C015 | ||||
LTEXT_ICON | IS-H: Comment on Billing Document | 0 | |||||||
KOSTR_NAME | IS-H: Last Name/ 1st Name | GPNAM1 | CHAR | 35 | NAME | NA1 | |||
/ISHFR/SEND_STAT | IS-H FR: Send Status | /ISHFR/SEND_STAT | CHAR | 60 | /ISHFR/ICON | ||||
/ISHFR/RECEIVE_STAT | IS-H FR: Receipt Status | /ISHFR/RECEIVE_STAT | CHAR | 60 | /ISHFR/ICON | ||||
/ISHFR/RECEIVE_DAT | IS-H FR: Receipt Date | /ISHFR/RECEIVE_DAT | DATS | 8 | /ISHFR/DAT | ||||
/ISHFR/RECEIVE_CODE | IS-H FR: Receipt Code | /ISHFR/RECEIVE_CODE | CHAR | 10 | /ISHFR/ISH_REC_CODE | ||||
/ISHFR/RECEIVE_CODETXT | IS-H FR: Receipt Code Text | /ISHFR/RECEIVE_CODETXT | CHAR | 80 | TEXT_80 | ||||
/ISHFR/B2_GROUPNR | IS-H FR: B2 Group Number | /ISHFR/B2_GROUPNR | NUMC | 3 | |||||
/ISHFR/B2_FILE | B2 File Name | /ISHFR/B2_FILE | CHAR | 30 | |||||
SEND_STAT | NWAT_EDI_SEND_STAT | CHAR | 60 | NWAT_EDI_ICON | |||||
SEND_LF301 | NWAT_EDI_SEND_LF301 | NUMC | 20 | Assigned to domain | ALPHA | ISH_LF301 | |||
RECEIVE_STAT | NWAT_EDI_RECEIVE_STAT | CHAR | 60 | NWAT_EDI_ICON | |||||
RECEIVE_DAT | NWAT_EDI_RECEIVE_DAT | DATS | 8 | NWAT_EDI_DAT | |||||
RECEIVE_LF301 | NWAT_EDI_RECEIVE_LF301 | NUMC | 20 | Assigned to domain | ALPHA | ISH_LF301 |
Key field | Non-key field |
How do I retrieve data from SAP structure ISH_VBRK_DETAIL using ABAP code?
As ISH_VBRK_DETAIL 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 ISH_VBRK_DETAIL as there is no data to select.How to access SAP table ISH_VBRK_DETAIL
Within an ECC or HANA version of SAP you can also view further information about ISH_VBRK_DETAIL 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