WB2_SI_LST_DATA SAP (Data From Sales Documents: Invoice List) Structure details
Description: Data From Sales Documents: Invoice List
Related tables to WB2_SI_LST_DATA
Access table WB2_SI_LST_DATA
Structure field list including key, data, relationships and ABAP select examples
WB2_SI_LST_DATA 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 "Data From Sales Documents: Invoice List" 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_WB2_SI_LST_DATA TYPE WB2_SI_LST_DATA.
The WB2_SI_LST_DATA table consists of various fields, each holding specific information or linking keys about Data From Sales Documents: Invoice List data available in SAP. These include ITEM_KEY (Item Key), VBELN (Invoice list), POSNR (Invoice list item), VBRK ().. 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 WB2_SI_LST_DATA 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 |
DOC_KEY | Document Key | WB2_DOC_KEY | CHAR | 42 | |||||
ITEM_KEY | Item Key | WB2_ITEM_KEY | CHAR | 16 | |||||
VBELN | Invoice list | VBELN_RL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
POSNR | Invoice list item | POSNR_RL | NUMC | 6 | Assigned to domain | POSNR_RL | |||
VBRK | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
VBELN | Billing Document | VBELN_VF | CHAR | 10 | ALPHA | VBELN | VF | ||
FKART | Billing Type | FKART | CHAR | 4 | FKART | ||||
FKTYP | Billing category | FKTYP | CHAR | 1 | FKTYP | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | WAERS | FWS | |||
VKORG | Sales Organization | VKORG | CHAR | 4 | VKORG | VKO | C_VKORG | ||
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | VTWEG | VTW | C_VTWEG | ||
KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | KALSM | ||||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | 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 | KONDA | VKA | |||
KDGRP | Customer group | KDGRP | CHAR | 2 | KDGRP | VKD | |||
BZIRK | Sales district | BZIRK | CHAR | 6 | BZIRK | BZI | |||
PLTYP | Price list type | PLTYP | CHAR | 2 | PLTYP | VPL | |||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | 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 | ZLSCH | ||||
KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | KTGRD | ||||
LAND1 | Country of Destination | LLAND | CHAR | 3 | LAND1 | VLL | |||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
COUNC | County Code | COUNC | CHAR | 3 | COUNC | ||||
CITYC | City Code | CITYC | CHAR | 4 | CITYC | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
TAXK1 | Tax classification 1 for customer | TAXK1 | CHAR | 1 | TAXKD | ||||
TAXK2 | Tax classification 2 for customer | TAXK2 | CHAR | 1 | TAXKD | ||||
TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1 | TAXKD | ||||
TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | TAXKD | ||||
TAXK5 | Tax classification 5 for customer | TAXK5 | CHAR | 1 | TAXKD | ||||
TAXK6 | Tax classification 6 for customer | TAXK6 | CHAR | 1 | TAXKD | ||||
TAXK7 | Tax classification 7 for customer | TAXK7 | CHAR | 1 | TAXKD | ||||
TAXK8 | Tax classification 8 for customer | TAXK8 | CHAR | 1 | TAXKD | ||||
TAXK9 | Tax classification 9 for customer | TAXK9 | CHAR | 1 | 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 | ALPHA | STAFO | MCF | ||
KUNRG | Payer | KUNRG | CHAR | 10 | ALPHA | KUNNR | |||
KUNAG | Sold-to party | KUNAG | CHAR | 10 | ALPHA | KUNNR | VAG | ||
MABER | Dunning Area | MABER | CHAR | 2 | MABER | ||||
STWAE | Statistics currency | STWAE | CUKY | 5 | WAERS | ||||
EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | EXNUM | ||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
SFAKN | Cancelled billing document number | SFAKN | CHAR | 10 | ALPHA | VBELN | VF | ||
KNUMA | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | ALPHA | KNUMA | VMBO | ||
FKART_RL | Invoice list type | FKART_RL | CHAR | 4 | FKART | ||||
FKDAT_RL | Billing date for the invoice list | FKDAT_RL | DATS | 8 | DATUM | ||||
KURST | Exchange Rate Type | KURST | CHAR | 4 | KURST | KUT | |||
MSCHL | Dunning key | MSCHL | CHAR | 1 | MSCHL | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | MANSP | ||||
SPART | Division | SPART | CHAR | 2 | SPART | SPA | C_SPART | ||
KKBER | Credit control area | KKBER | CHAR | 4 | KKBER | KKB | |||
KNKLI | Customer's account number with credit limit reference | KNKLI | CHAR | 10 | ALPHA | KUNNR | |||
CMWAE | Currency key of credit control area | WAERS_CM | CUKY | 5 | 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 | HITYP | ||||
BSTNK_VF | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | ALPHA | RCOMP | PGS | ||
FKART_AB | Accrual billing type | FKART_AB | CHAR | 4 | FKART | ||||
KAPPL | Application | KAPPL | CHAR | 2 | KAPPL | KAP | |||
LANDTX | Tax departure country | LANDTX | CHAR | 3 | 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 | 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 | 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 | FPLNR | ||||
LCNUM | Financial doc. processing: Internal financial doc. number | LCNUM | CHAR | 10 | ALPHA | LCNUM | AKN | ||
J_1AFITP | Tax type | J_1AFITP_D | CHAR | 2 | 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 | 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 | ||||
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 | ALPHA | LOGSYS | |||
FKTYP_CRM | Billing Category in CRM | FKTYP_CRM | CHAR | 1 | FKTYP | ||||
STGRD | Reason for Reversal | STGRD | CHAR | 2 | 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 | 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 | SWENR | SWENR | WEH | ||
SMENR | Number of Sales Unit | HB_SMENR | CHAR | 8 | SMENR | SMENR | MEH | ||
PHASE | Sales Phase | HB_SPHSE | CHAR | 11 | HBS_PHASE | ||||
MTLAUR | Marker for Low Income Housing | HB_MTLAUR | CHAR | 1 | 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 | 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 | ALPHA | VBELN | |||
.INCLU--AP | 0 | ||||||||
.INCLU-_GT | 0 | ||||||||
FILTERED_OUT_GT | Filtered Out | WB2_FILTERED_OUT | CHAR | 1 | WB2_FILTERED_OUT | ||||
EXTERNAL_NO_GT | Trading Contract: External Document Number | TKONN_EX | CHAR | 30 | TKONN_EX | WKN_EX | |||
SCENARIO_GT | Business Scenario | WB2_BUSINESS_SCENARIO | CHAR | 2 | WB2_BUSINESS_SCENARIO | ||||
VBRL | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
VBELN | Invoice list | VBELN_RL | CHAR | 10 | ALPHA | VBELN | VF | ||
POSNR | Invoice list item | POSNR_RL | NUMC | 6 | POSNR_RL | ||||
VBELN_VF | Billing Document | VBELN_VF | CHAR | 10 | ALPHA | VBELN | VF | ||
NETWR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
MWSBP | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
KWERT_RL | Value of Remuneration List Condition of Indiv. Billing Doc. | KWERT_RL | CURR | 13(2) | WERTV7 | ||||
MWSBP_RL | Amount of Tax in Remuneration List Condition | MWSBP_RL | CURR | 13(2) | WERTV7 | ||||
KUNAG | Sold-to party | KUNAG | CHAR | 10 | ALPHA | KUNNR | VAG | ||
UVPRS | Incomplete with respect to pricing | UVPRS | CHAR | 1 | XFELD | ||||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
.INCLU-_GT | 0 | ||||||||
SCENARIO_GT | Business Scenario | WB2_BUSINESS_SCENARIO | CHAR | 2 | WB2_BUSINESS_SCENARIO | ||||
FILTERED_OUT_GT | Filtered Out | WB2_FILTERED_OUT | CHAR | 1 | WB2_FILTERED_OUT | ||||
NOT_REF_QUAN_GT | Open Quantity | WB2_NOT_REF_QUAN | QUAN | 15(3) | MENG15 | ||||
NOT_REF_QUAN_UNIT_GT | Open Quantity Unit | WB2_NOT_REF_QUAN_UNIT | UNIT | 3 | CUNIT | MEINS | |||
EXTERNAL_NO_GT | Trading Contract: External Document Number | TKONN_EX | CHAR | 30 | TKONN_EX | WKN_EX | |||
VBRK_WAERK_GT | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
KOMK_WAERK_GT | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
ASSOC_QUAN_B | Assoc. Mngt: Actually Associated Quantity of an Item | WB2_ASSOCIATED_QUAN | QUAN | 15(3) | MENGV15 | ||||
UNIT_OF_QUAN_B | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ASSOC_QUAN_S | Assoc. Mngt: Actually Associated Quantity of an Item | WB2_ASSOCIATED_QUAN | QUAN | 15(3) | MENGV15 | ||||
UNIT_OF_QUAN_S | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ASSOC_QUAN_P | Assoc. Mngt: Actually Associated Quantity of an Item | WB2_ASSOCIATED_QUAN | QUAN | 15(3) | MENGV15 | ||||
UNIT_OF_QUAN_P | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PORTFOLIO | Global Trade: (Internal) Portfolio Number | WB2_PORTFOLIO | CHAR | 10 | KNUMB |
Key field | Non-key field |
How do I retrieve data from SAP structure WB2_SI_LST_DATA using ABAP code?
As WB2_SI_LST_DATA 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 WB2_SI_LST_DATA as there is no data to select.How to access SAP table WB2_SI_LST_DATA
Within an ECC or HANA version of SAP you can also view further information about WB2_SI_LST_DATA 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