Table/Structure Field list used by SAP ABAP Class CL_PIQ_PREPARE (PriceInquiry Comm. str. preparation)
SAP ABAP Class
CL_PIQ_PREPARE (PriceInquiry Comm. str. preparation) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | EMVKE - DWERK | Delivering Plant (Own or External) | ||
| 2 | EMVKE - MTPOS | Item category group from material master | ||
| 3 | KNMT - KUNNR | Customer number | ||
| 4 | KNMT - MATNR | Material Number | ||
| 5 | KNMT - VKORG | Sales Organization | ||
| 6 | KNMT - VTWEG | Distribution Channel | ||
| 7 | KNMT - WERKS | Plant (Own or External) | ||
| 8 | KNVH - DATAB | Start of validity period for assignment | ||
| 9 | KNVH - DATBI | End of validity period for the assignment | ||
| 10 | KNVH - HITYP | Customer Hierarchy Category | ||
| 11 | KNVH - HKUNNR | Customer number of the higher-level customer hierarchy | ||
| 12 | KNVH - HSPART | Higher-level division | ||
| 13 | KNVH - HVKORG | Higher-level sales organization | ||
| 14 | KNVH - HVTWEG | Higher-level distribution channel | ||
| 15 | KNVH - KUNNR | Customer | ||
| 16 | KNVH - PRFRE | Relevant for Pricing ID | ||
| 17 | KNVH - SPART | Division | ||
| 18 | KNVH - VKORG | Sales Organization | ||
| 19 | KNVH - VTWEG | Distribution Channel | ||
| 20 | KNVP - DEFPA | Default partner | ||
| 21 | KNVP - KUNN2 | Customer number of business partner | ||
| 22 | KNVP - KUNNR | Customer Number | ||
| 23 | KNVP - PARVW | Partner Role | ||
| 24 | KNVP - PARZA | Partner counter | ||
| 25 | KNVP - SPART | Division | ||
| 26 | KNVP - VKORG | Sales Organization | ||
| 27 | KNVP - VTWEG | Distribution Channel | ||
| 28 | KNVV - KALKS | Pricing procedure assigned to this customer | ||
| 29 | KNVV - KUNNR | Customer Number | ||
| 30 | KNVV - SPART | Division | ||
| 31 | KNVV - VKORG | Sales Organization | ||
| 32 | KNVV - VTWEG | Distribution Channel | ||
| 33 | KNVV - VWERK | Delivering Plant (Own or External) | ||
| 34 | KOMK - BELNR | Sales and Distribution Document Number | ||
| 35 | KOMK - BELNR | Sales and Distribution Document Number | ||
| 36 | KOMK - IX_KOMK | Index number for internal tables | ||
| 37 | KOMK - IX_KOMK | Index number for internal tables | ||
| 38 | KOMK - KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | ||
| 39 | KOMK - KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | ||
| 40 | KOMK - KAPPL | Application | ||
| 41 | KOMK - KNUMV | Number of the document condition | ||
| 42 | KOMK - KURRF_DAT | Translation date | ||
| 43 | KOMK - MANDT | Client | ||
| 44 | KOMK - PRSDT | Date for pricing and exchange rate | ||
| 45 | KOMK - STCEG | VAT Registration Number | ||
| 46 | KOMK - TRTYP | Transaction type | ||
| 47 | KOMK - VSBED | Shipping conditions | ||
| 48 | KOMK_KEY_UC - BELNR | Sales and Distribution Document Number | ||
| 49 | KOMK_KEY_UC - BELNR | Sales and Distribution Document Number | ||
| 50 | KOMK_KEY_UC - KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | ||
| 51 | KOMK_KEY_UC - KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | ||
| 52 | KOMK_KEY_UC - KAPPL | Application | ||
| 53 | KOMK_KEY_UC - KNUMV | Number of the document condition | ||
| 54 | KOMK_KEY_UC - KURRF_DAT | Translation date | ||
| 55 | KOMK_KEY_UC - MANDT | Client | ||
| 56 | KOMK_KEY_UC - PRSDT | Date for pricing and exchange rate | ||
| 57 | KOMK_KEY_UC - STCEG | VAT Registration Number | ||
| 58 | KOMK_KEY_UC - TRTYP | Transaction type | ||
| 59 | KOMK_KEY_UC - VSBED | Shipping conditions | ||
| 60 | KOMP - AUPOS | Sales Document Item | ||
| 61 | KOMP - BRGEW | Gross weight of item | ||
| 62 | KOMP - KPOSN | Condition Item Number | ||
| 63 | KOMP - KPOSN | Condition Item Number | ||
| 64 | KOMP - MATNR | Material Number | ||
| 65 | KOMP - MEINS | Base Unit of Measure | ||
| 66 | KOMP - MGAME | Quantity | ||
| 67 | KOMP - MGLME | Quantity | ||
| 68 | KOMP - NTGEW | Net weight of item | ||
| 69 | KOMP - PMATN | Pricing Reference Material | ||
| 70 | KOMP - PSTYV | Sales document item category | ||
| 71 | KOMP - SPART | Division | ||
| 72 | KOMP - UMVKN | Denominator (divisor) for conversion of sales qty. into SKU | ||
| 73 | KOMP - UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | ||
| 74 | KOMP - VOLUM | Volume of the item | ||
| 75 | KOMP - VRKME | Sales unit | ||
| 76 | KOMP_HEAD_FIELDS - IX_KOMK | Index number for internal tables | ||
| 77 | KOMP_HEAD_FIELDS - IX_KOMP | Index number for internal tables | ||
| 78 | MARC - MATNR | Material Number | ||
| 79 | MARC - WERKS | Plant | ||
| 80 | MVKE - DWERK | Delivering Plant (Own or External) | ||
| 81 | MVKE - MATNR | Material Number | ||
| 82 | MVKE - MTPOS | Item category group from material master | ||
| 83 | MVKE - VKORG | Sales Organization | ||
| 84 | MVKE - VTWEG | Distribution Channel | ||
| 85 | PIQC_BADIRELATTR - CALLER_ID | Price Inquiry Caller ID | ||
| 86 | PIQC_BADIRELATTR - QUFNA | Table field for document structure | ||
| 87 | PIQC_BADIRELATTR - QUSTR | Table name of the document structure | ||
| 88 | PIQS_DB_ALIAS_DATA - TABLE_NAME | Table Name | ||
| 89 | PIQS_PREP_FLD_DATA - DIRECT_VALUE | Source of constant | ||
| 90 | PIQS_PREP_FLD_DATA - DIRECT_VALUE | Source of constant | ||
| 91 | PIQS_PREP_FLD_DATA - SOURCE_ALIAS | Table Name | ||
| 92 | PIQS_PREP_FLD_DATA - SOURCE_ALIAS | Table Name | ||
| 93 | PIQS_PREP_FLD_DATA - SOURCE_ALIAS | Table Name | ||
| 94 | PIQS_PREP_FLD_DATA - SOURCE_ALIAS | Table Name | ||
| 95 | PIQS_PREP_FLD_DATA - SOURCE_ALIAS | Table Name | ||
| 96 | PIQS_PREP_FLD_DATA - SOURCE_ALIAS | Table Name | ||
| 97 | PIQS_PREP_FLD_DATA - SOURCE_ALIAS | Table Name | ||
| 98 | PIQS_PREP_FLD_DATA - SOURCE_FIELD | Field Name | ||
| 99 | PIQS_PREP_FLD_DATA - SOURCE_FIELD | Field Name | ||
| 100 | PIQS_PREP_FLD_DATA - SOURCE_FIELD | Field Name | ||
| 101 | PIQS_PREP_FLD_DATA - SOURCE_TYPE | Pricing Prepare: Source Type for KOMK/KOMP Fields | ||
| 102 | PIQS_PREP_FLD_DATA - SOURCE_TYPE | Pricing Prepare: Source Type for KOMK/KOMP Fields | ||
| 103 | PIQS_PREP_FLD_DATA - SOURCE_TYPE | Pricing Prepare: Source Type for KOMK/KOMP Fields | ||
| 104 | PIQS_PREP_KEY_DATA - DIRECT_VALUE | Source of constant | ||
| 105 | PIQS_PREP_KEY_DATA - DIRECT_VALUE | Source of constant | ||
| 106 | PIQS_PREP_KEY_DATA - SOURCE_FIELD | Field Name | ||
| 107 | PIQS_PREP_KEY_DATA - SOURCE_FIELD | Field Name | ||
| 108 | PIQS_PREP_KEY_DATA - SOURCE_FIELD | Field Name | ||
| 109 | PIQS_PREP_KEY_DATA - SOURCE_FIELD | Field Name | ||
| 110 | PIQS_PREP_KEY_DATA - SOURCE_TYPE | Pricing Preparation: Source Type for DB Key Fields | ||
| 111 | PIQS_PREP_KEY_DATA - SOURCE_TYPE | Pricing Preparation: Source Type for DB Key Fields | ||
| 112 | PIQS_PREP_KEY_DATA - SOURCE_TYPE | Pricing Preparation: Source Type for DB Key Fields | ||
| 113 | PIQS_PREP_KEY_DATA - SOURCE_TYPE | Pricing Preparation: Source Type for DB Key Fields | ||
| 114 | SI_T001W - CITYC | City Code | ||
| 115 | SI_T001W - COUNC | County Code | ||
| 116 | SI_T001W - LAND1 | Country Key | ||
| 117 | SI_T001W - REGIO | Region (State, Province, County) | ||
| 118 | SI_TVKO - BOAVO | Rebate processing active in the sales organization | ||
| 119 | SI_TVKO - BUKRS | Company code of the sales organization | ||
| 120 | SI_TVKO - WAERS | Statistics currency | ||
| 121 | SI_TVKO - XSTCEG | Determining the VAT registration number | ||
| 122 | SI_TVKO - XSTCEG | Determining the VAT registration number | ||
| 123 | SI_TVKO - XSTCEG | Determining the VAT registration number | ||
| 124 | SI_TVKO - XSTCEG | Determining the VAT registration number | ||
| 125 | SI_TVKO - XSTCEG | Determining the VAT registration number | ||
| 126 | SI_TVTA - SPAAU | Reference division for document types (by sales area) | ||
| 127 | SI_TVTA - SPAAU | Reference division for document types (by sales area) | ||
| 128 | SI_TVTA - SPAKO | Reference division for conditions | ||
| 129 | SI_TVTA - SPAKO | Reference division for conditions | ||
| 130 | SI_TVTA - SPAKU | Reference division for customers | ||
| 131 | SI_TVTA - SPAKU | Reference division for customers | ||
| 132 | SI_TVTA - VKOAU | Reference sales org.for sales doc.types (by sales area) | ||
| 133 | SI_TVTA - VKOAU | Reference sales org.for sales doc.types (by sales area) | ||
| 134 | SI_TVTA - VTWAU | Distribution channel for sales doc types | ||
| 135 | SI_TVTA - VTWAU | Distribution channel for sales doc types | ||
| 136 | SI_TVTA - VTWKO | Reference distribution channel for conditions | ||
| 137 | SI_TVTA - VTWKO | Reference distribution channel for conditions | ||
| 138 | SI_TVTA - VTWKU | Reference distrib.channel for cust.and material masters | ||
| 139 | SI_TVTA - VTWKU | Reference distrib.channel for cust.and material masters | ||
| 140 | SYST - INDEX | ABAP System Field: Loop Index | ||
| 141 | SYST - MANDT | ABAP System Field: Client ID of Current User | ||
| 142 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 143 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 144 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 145 | T001W - BWKEY | Valuation area | ||
| 146 | T001W - CITYC | City Code | ||
| 147 | T001W - COUNC | County Code | ||
| 148 | T001W - LAND1 | Country Key | ||
| 149 | T001W - LIFNR | Vendor number of plant | ||
| 150 | T001W - REGIO | Region (State, Province, County) | ||
| 151 | T001W - WERKS | Plant | ||
| 152 | T184 - AUART | Sales Document Type | ||
| 153 | T184 - MTPOS | Item category group from material master | ||
| 154 | T184 - PSTYV | Default item category for the document | ||
| 155 | T184 - UEPST | Item category of the higher-level item | ||
| 156 | T184 - VWPOS | Item usage | ||
| 157 | T683V - KALKS | Pricing procedure assigned to this customer | ||
| 158 | T683V - KALSM | Sales and Distribution: Pricing Procedure in Pricing | ||
| 159 | T683V - KALVG | Document schema for determining calculation schema | ||
| 160 | T683V - SPART | Division | ||
| 161 | T683V - VKORG | Sales Organization | ||
| 162 | T683V - VTWEG | Distribution Channel | ||
| 163 | TSTL - LFDNR | Sequence of Possible Taxes for each Country | ||
| 164 | TSTL - TALND | Country is Relevant for Taxes | ||
| 165 | TSTL - TATYP | Tax category (sales tax, federal sales tax,...) | ||
| 166 | TVAK - AUART | Sales Document Type | ||
| 167 | TVAK - KALVG | Document schema for determining calculation schema | ||
| 168 | TVAK - SPAPO | Division in Sales Order Item comes from the Material | ||
| 169 | TVAK - VBKLT | Sales document indicator (for display in TVAK only) | ||
| 170 | TVAK - VBTYP | SD document category | ||
| 171 | TVAK - VSBED | Shipping conditions | ||
| 172 | TVKO - BOAVO | Rebate processing active in the sales organization | ||
| 173 | TVKO - BUKRS | Company code of the sales organization | ||
| 174 | TVKO - VKORG | Sales Organization | ||
| 175 | TVKO - WAERS | Statistics currency | ||
| 176 | TVKO - XSTCEG | Determining the VAT registration number | ||
| 177 | TVKO - XSTCEG | Determining the VAT registration number | ||
| 178 | TVKO - XSTCEG | Determining the VAT registration number | ||
| 179 | TVKO - XSTCEG | Determining the VAT registration number | ||
| 180 | TVKO - XSTCEG | Determining the VAT registration number | ||
| 181 | TVKWZ - VKORG | Sales Organization | ||
| 182 | TVKWZ - VTWEG | Reference distrib.channel for cust.and material masters | ||
| 183 | TVKWZ - WERKS | Plant (Own or External) | ||
| 184 | TVTA - SPAAU | Reference division for document types (by sales area) | ||
| 185 | TVTA - SPAAU | Reference division for document types (by sales area) | ||
| 186 | TVTA - SPAKO | Reference division for conditions | ||
| 187 | TVTA - SPAKO | Reference division for conditions | ||
| 188 | TVTA - SPAKU | Reference division for customers | ||
| 189 | TVTA - SPAKU | Reference division for customers | ||
| 190 | TVTA - SPART | Division | ||
| 191 | TVTA - VKOAU | Reference sales org.for sales doc.types (by sales area) | ||
| 192 | TVTA - VKOAU | Reference sales org.for sales doc.types (by sales area) | ||
| 193 | TVTA - VKORG | Sales Organization | ||
| 194 | TVTA - VTWAU | Distribution channel for sales doc types | ||
| 195 | TVTA - VTWAU | Distribution channel for sales doc types | ||
| 196 | TVTA - VTWEG | Distribution Channel | ||
| 197 | TVTA - VTWKO | Reference distribution channel for conditions | ||
| 198 | TVTA - VTWKO | Reference distribution channel for conditions | ||
| 199 | TVTA - VTWKU | Reference distrib.channel for cust.and material masters | ||
| 200 | TVTA - VTWKU | Reference distrib.channel for cust.and material masters | ||
| 201 | VFKOM_SHP - VSBED | Shipping conditions | ||
| 202 | VFPRCC_UERATTR_C - QUFNA | Table field for document structure | ||
| 203 | VFPRCC_UERATTR_C - QUSTR | Table name of the document structure | ||
| 204 | VFPRCC_UERATTR_C - USEREXIT_TYPE | Pricing Userexit Type (VOFM etc.) | ||
| 205 | VFPRCC_UERATTR_S - QUFNA | Table field for document structure | ||
| 206 | VFPRCC_UERATTR_S - QUSTR | Table name of the document structure | ||
| 207 | VFPRCC_UERATTR_S - USEREXIT_TYPE | Pricing Userexit Type (VOFM etc.) |