SAP ABAP Table S262BIW2 (SD - Billing document)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
MCS (Package) R/3 application development: Logistics Information Warehouse
⤷
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | S262BIW2 |
|
| Short Description | SD - Billing document |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
SPTAG | DATUM | DATS | 8 | 0 | Period to analyze - current date | ||
| 3 | |
VBELN_VF | VBELN | CHAR | 10 | 0 | Billing document | VBUK | |
| 4 | |
POSNR_VF | POSNR | NUMC | 6 | 0 | Billing item | VBUP | |
| 5 | |
VRSIO | VRSIO | CHAR | 3 | 0 | Version number in the information structure | * | |
| 6 | |
SPMON | MCPERIOD | NUMC | 6 | 0 | Period to analyze - month | ||
| 7 | |
SPWOC | MCPERIOD | NUMC | 6 | 0 | Period to analyze - week | ||
| 8 | |
SPBUP | MCPERIOD | NUMC | 6 | 0 | Period to analyze - posting period | ||
| 9 | |
SSOUR | SSOUR | CHAR | 4 | 0 | Statistic(s) origin | ||
| 10 | |
PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
| 11 | |
VWDAT | VWDAT | NUMC | 10 | 0 | Pointer to administrative data | ||
| 12 | |
0 | 0 | SIS Characteristics: Billing Document - Header | |||||
| 13 | |
WAERK | WAERS | CUKY | 5 | 0 | SD document currency | TCURC | |
| 14 | |
STWAE | WAERS | CUKY | 5 | 0 | Statistics currency | * | |
| 15 | |
HWAER | WAERS | CUKY | 5 | 0 | Local Currency | * | |
| 16 | |
KURRF | KURRF | DEC | 9 | 5 | Exchange rate for FI postings | ||
| 17 | |
FKART | FKART | CHAR | 4 | 0 | Billing Type | * | |
| 18 | |
FKTYP | FKTYP | CHAR | 1 | 0 | Billing Category | ||
| 19 | |
VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
| 20 | |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
| 21 | |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
| 22 | |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
| 23 | |
KUNRG | KUNNR | CHAR | 10 | 0 | Payer | * | |
| 24 | |
KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | KNA1 | |
| 25 | |
KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | * | |
| 26 | |
BZIRK | BZIRK | CHAR | 6 | 0 | Sales district | * | |
| 27 | |
FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
| 28 | |
0 | 0 | SIS Characteristics: Billing Document - Item | |||||
| 29 | |
UMVKZ | UMBSZ | DEC | 5 | 0 | Numerator (factor) for conversion of sales quantity into SKU | ||
| 30 | |
UMVKN | UMBSN | DEC | 5 | 0 | Denominator (divisor) for conversion of sales qty. into SKU | ||
| 31 | |
KURSK | KURRF | DEC | 9 | 5 | Exchange Rate for Pricing and Statistics | ||
| 32 | |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
| 33 | |
VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
| 34 | |
VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | * | |
| 35 | |
GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
| 36 | |
ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
| 37 | |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
| 38 | |
STADAT | DATUM | DATS | 8 | 0 | Statistics date | ||
| 39 | |
PRSDT | DATUM | DATS | 8 | 0 | Date for pricing and exchange rate | ||
| 40 | |
FBUDA | DATUM | DATS | 8 | 0 | Date When Services Rendered | ||
| 41 | |
PSTYV | PSTYV | CHAR | 4 | 0 | Sales document item category | * | |
| 42 | |
POSAR | POSAR | CHAR | 1 | 0 | Item type | ||
| 43 | |
PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | * | |
| 44 | |
VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | * | |
| 45 | |
SPART | SPART | CHAR | 2 | 0 | Division | * | |
| 46 | |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
| 47 | |
KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
| 48 | |
BONUS | BONUS | CHAR | 2 | 0 | Volume rebate group | * | |
| 49 | |
PROVG | PROVG | CHAR | 2 | 0 | Commission group | * | |
| 50 | |
VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
| 51 | |
VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
| 52 | |
SPART_AK | SPART | CHAR | 2 | 0 | Division for order header | * | |
| 53 | |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
| 54 | |
MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
| 55 | |
CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
| 56 | |
LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
| 57 | |
KVGR1 | KVGR1 | CHAR | 3 | 0 | Customer group 1 | * | |
| 58 | |
KVGR2 | KVGR2 | CHAR | 3 | 0 | Customer group 2 | * | |
| 59 | |
KVGR3 | KVGR3 | CHAR | 3 | 0 | Customer group 3 | * | |
| 60 | |
KVGR4 | KVGR4 | CHAR | 3 | 0 | Customer group 4 | * | |
| 61 | |
KVGR5 | KVGR5 | CHAR | 3 | 0 | Customer group 5 | * | |
| 62 | |
MVGR1 | MVGR1 | CHAR | 3 | 0 | Material group 1 | * | |
| 63 | |
MVGR2 | MVGR2 | CHAR | 3 | 0 | Material group 2 | * | |
| 64 | |
MVGR3 | MVGR3 | CHAR | 3 | 0 | Material group 3 | * | |
| 65 | |
MVGR4 | MVGR4 | CHAR | 3 | 0 | Material group 4 | * | |
| 66 | |
MVGR5 | MVGR5 | CHAR | 3 | 0 | Material group 5 | * | |
| 67 | |
KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
| 68 | |
KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | * | |
| 69 | |
KUNRE | KUNNR | CHAR | 10 | 0 | Bill-to party | * | |
| 70 | |
SPDNR | LIFNR | CHAR | 10 | 0 | Carrier | * | |
| 71 | |
VRTNR | PERNR | NUMC | 8 | 0 | Sales employee | ||
| 72 | |
VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | * | |
| 73 | |
POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
| 74 | |
VGBEL | VBELN | CHAR | 10 | 0 | Document number of the reference document | * | |
| 75 | |
VGPOS | POSNR | NUMC | 6 | 0 | Item number of the reference item | * | |
| 76 | |
0 | 0 | SIS Characteristics: Billing Document Item Append | |||||
| 77 | |
STCUR_AP | KURRF | DEC | 9 | 5 | Exchange rate for statistics (Exch.rate at time of creation) | ||
| 78 | |
ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
| 79 | |
ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
| 80 | |
PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
| 81 | |
0 | 0 | SIS Key Figures: Billing Document - Item | |||||
| 82 | |
FKIMG | MENG13 | QUAN | 13 | 3 | Actual billed quantity | ||
| 83 | |
SMENG | MENG13 | QUAN | 13 | 3 | Scale quantity in base unit of measure | ||
| 84 | |
FKLMG | MENG13 | QUAN | 13 | 3 | Billing quantity in stockkeeping unit | ||
| 85 | |
LMENG | MENG13 | QUAN | 13 | 3 | Required quantity for mat.management in stockkeeping units | ||
| 86 | |
NTGEW_15 | MENG15 | QUAN | 15 | 3 | Net weight | ||
| 87 | |
BRGEW_15 | MENG15 | QUAN | 15 | 3 | Gross weight | ||
| 88 | |
VOLUM_15 | MENG15 | QUAN | 15 | 3 | Volume | ||
| 89 | |
NETWR_FP | WERTV8 | CURR | 15 | 2 | Net value of the billing item in document currency | ||
| 90 | |
SKFBP | WERTV7 | CURR | 13 | 2 | Amount eligible for cash discount in document currency | ||
| 91 | |
WAVWR | WERTV7 | CURR | 13 | 2 | Cost in document currency | ||
| 92 | |
KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
| 93 | |
KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
| 94 | |
KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
| 95 | |
KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
| 96 | |
KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
| 97 | |
KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
| 98 | |
BONBA | WERTV7 | CURR | 13 | 2 | Rebate basis 1 | ||
| 99 | |
MWSBP | WERTV7 | CURR | 13 | 2 | Tax amount in document currency | ||
| 100 | |
0 | 0 | SIS Key Figures: Billing Document - Item | |||||
| 101 | |
MC_ANZFK | MCZAEHLER | DEC | 9 | 0 | No.of billing docs | ||
| 102 | |
MC_ANZFKPO | MCZAEHLER | DEC | 9 | 0 | Number of billing items |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | S262BIW2 | KUNAG | |
|
|||
| 2 | S262BIW2 | MANDT | |
|
|||
| 3 | S262BIW2 | POSNR | |
|
|||
| 4 | S262BIW2 | VBELN | |
|
|||
| 5 | S262BIW2 | WAERK | |
|
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |