SAP Table INV_DIALOG_ALV_TAB_MAIN
Bill Dialog: Data of ALV with Main Data
INV_DIALOG_ALV_TAB_MAIN (Bill Dialog: Data of ALV with Main Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link INV_DIALOG_ALV_TAB_MAIN to other SAP tables.
INV_DIALOG_ALV_TAB_MAIN table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| LINE_TYPE_DESC | Description of Line Type | INV_LINE_TYPE_DESC | CHAR | 47 | 0 | |||
| LINE_TYPE | Line Type | INV_LINE_TYPE | TINV_C_LINETYPE | NUMC | 4 | 0 | ||
| PRODUCT_ID | Identification | INV_PRODUCT_ID | CHAR | 20 | 0 | |||
| DATE_FROM | Start of Period | INV_DATE_FROM | DATS | 8 | 0 | |||
| DATE_TO | End of Period | INV_DATE_TO | DATS | 8 | 0 | |||
| QUANTITY | Quantity | INV_QUANT | QUAN | 15 | 3 | |||
| UNIT | Unit of Measurement | INV_UNIT | T006 | UNIT | 3 | 0 | ||
| PRICE | Price | INV_PRICE | DEC | 17 | 8 | |||
| PRICE_UNIT | Measurement Unit for Price | INV_PRICE_UNIT | T006 | UNIT | 3 | 0 | ||
| BETRW_NET | Net Amount in Transaction Currency with +/- Sign | INV_BETRW_NET | CURR | 13 | 2 | |||
| CURRENCY | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||
| DROPDOWN | Natural Number | INT4 | INT4 | 10 | 0 | |||
| TAXBW | Tax Amount in Transaction Currency | INV_TAXBW | CURR | 13 | 2 | |||
| DATE_OF_PAYMENT | Due Date | INV_DATE_OF_PAYMENT | DATS | 8 | 0 | |||
| MWSKZ | Tax on sales/purchases code | MWSKZ | T007A | CHAR | 2 | 0 | ||
| STRPZ | Tax Percentage | INV_TAX_PERCENT_RATE | DEC | 6 | 0 | |||
| KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | 0 | |||
INV_DIALOG_ALV_TAB_MAIN foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| INV_DIALOG_ALV_TAB_MAIN | CURRENCY | SYST | MANDT | TCURC | Currency Codes | MANDT |
| INV_DIALOG_ALV_TAB_MAIN | CURRENCY | INV_DIALOG_ALV_TAB_MAIN | CURRENCY | TCURC | Currency Codes | WAERS |
| INV_DIALOG_ALV_TAB_MAIN | LINE_TYPE | SYST | MANDT | TINV_C_LINETYPE | Customizing: Definition of Permitted Bill Line Items | MANDT |
| INV_DIALOG_ALV_TAB_MAIN | LINE_TYPE | INV_DIALOG_ALV_TAB_MAIN | LINE_TYPE | TINV_C_LINETYPE | Customizing: Definition of Permitted Bill Line Items | LINE_TYPE |
| INV_DIALOG_ALV_TAB_MAIN | MWSKZ | INV_DIALOG_ALV_TAB_MAIN | MWSKZ | T007A | Tax Keys | MWSKZ |
| INV_DIALOG_ALV_TAB_MAIN | MWSKZ | SYST | MANDT | T007A | Tax Keys | MANDT |
| INV_DIALOG_ALV_TAB_MAIN | MWSKZ | INV_DIALOG_ALV_TAB_MAIN | KALSM | T007A | Tax Keys | KALSM |
| INV_DIALOG_ALV_TAB_MAIN | PRICE_UNIT | INV_DIALOG_ALV_TAB_MAIN | PRICE_UNIT | T006 | Units of Measurement | MSEHI |
| INV_DIALOG_ALV_TAB_MAIN | PRICE_UNIT | SYST | MANDT | T006 | Units of Measurement | MANDT |
| INV_DIALOG_ALV_TAB_MAIN | UNIT | SYST | MANDT | T006 | Units of Measurement | MANDT |
| INV_DIALOG_ALV_TAB_MAIN | UNIT | INV_DIALOG_ALV_TAB_MAIN | UNIT | T006 | Units of Measurement | MSEHI |
