In this post, I will try and describe everything you need to know about the SAP crmd_pricing_i table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_PRICING_I what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_PRICING_I....Right lets get started!
Object Name: CRMD_PRICING_I
Dictionary Type: Transparent table
Description: Transaction Item Price
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| NET_VALUE_MAN | CRMT_NET_VALUE_MAN | CURR | 15(2) | Total Expected Net Value Products in Document Currency | WERTV8 | CRM | ||||||
| TARGET_VALUE | CRMT_TARGET_VALUE | CURR | 19(2) | Target Value for Value Contract | WERTV10 | CRM | ||||||
| CASHFLOW_TYPE | CRMT_CASHFLOW_TYPE | CHAR | 4(0) | Flow Category | CRMT_CASHFLOW_TYPE | CRM | ||||||
| TAX_GROUP_P | CRMT_TAX_GROUP | CHAR | 20(0) | Product Tax Group | CRM_TAX_GROUP | CRM | ||||||
| TAX_GROUP_P_CTY | CRMT_TAX_LAND | CHAR | 3(0) | * | Tax Country | LAND1 | CRM | |||||
| TAX_GROUP_P_REG | CRMT_TAX_REGION | CHAR | 3(0) | * | Tax Region | REGIO | CRM | |||||
| TAX_GROUP_P_TTP | CRMT_TAX_TYPE | CHAR | 4(0) | Tax Type | BUTX_TAX_TYPE | CRM | ||||||
| TAX_DEPART_CTY | CRMT_TAX_DEPART_CTY | CHAR | 3(0) | * | Tax Departure Country | LAND1 | CRM | |||||
| TAX_DEPART_REG | CRMT_TAX_DEPART_REG | CHAR | 3(0) | * | Departure Region for Tax | REGIO | CRM | |||||
| TAXJURCODE_FROM | CRMT_TAXJURCODE | CHAR | 15(0) | * | Tax Jurisdiction Code (Structure for tax calculation) | TXJCD | CRM_TAX_SH_TAXJURCODE | TAXJURCODE | CRM | |||
| TAX_TARIFF_CODE | CRMT_TAX_TARIFF_CODE | CHAR | 16(0) | Tax Tariff Code | CHAR16 | CRM | ||||||
| STATISTICAL | CRMT_STATISTICAL | CHAR | 1(0) | Statistical values | CRM_STATISTICAL | CRM | ||||||
| PRC_INDICATOR | CRMT_PRICING_INDICATOR | CHAR | 1(0) | Pricing indicator | CRM_PRICING_INDICATOR | CRM | ||||||
| NET_VALUE | CRMT_NET_VALUE | CURR | 15(2) | Net Value | WERTV8 | CRM | ||||||
| NET_PRICE | CRMT_NET_PRICE | CURR | 15(2) | Net Price | WERTV8 | CRM | ||||||
| TAX_AMOUNT | CRMT_TAX_AMOUNT | CURR | 15(2) | Tax amount in document currency | WERTV8 | CRM | ||||||
| FREIGHT | CRMT_FREIGHT | CURR | 15(2) | Shipment costs in document currency | WERTV8 | CRM | ||||||
| GROSS_VALUE | CRMT_GROSS_VALUE | CURR | 15(2) | Gross Order Value in PO Currency | WERTV8 | CRM | ||||||
| NET_WO_FREIGHT | PRCT_NET_VALUE_WITHOUT_FREIGHT | CURR | 15(2) | Item Net Value Exclusive Shipment | WERTV8 | CRM | ||||||
| SUBTOTAL1 | CRMT_SUBTOTAL1 | CURR | 15(2) | Subtotal 1 from pricing procedure for condition | WERTV8 | CRM | ||||||
| SUBTOTAL2 | CRMT_SUBTOTAL2 | CURR | 15(2) | Subtotal 2 from pricing procedure for condition | WERTV8 | CRM | ||||||
| SUBTOTAL3 | CRMT_SUBTOTAL3 | CURR | 15(2) | Subtotal 3 from pricing procedure for condition | WERTV8 | CRM | ||||||
| SUBTOTAL4 | CRMT_SUBTOTAL4 | CURR | 15(2) | Subtotal 4 from pricing procedure for condition | WERTV8 | CRM | ||||||
| SUBTOTAL5 | CRMT_SUBTOTAL5 | CURR | 15(2) | Subtotal 5 from pricing procedure for condition | WERTV8 | CRM | ||||||
| SUBTOTAL6 | CRMT_SUBTOTAL6 | CURR | 15(2) | Subtotal 6 from pricing procedure for condition | WERTV8 | CRM | ||||||
| CREDIT_INDICATOR | CRMT_CREDIT_INDICATOR | CHAR | 1(0) | Credit Debit Indicator | CRMT_CREDIT_INDICATOR | CRM | ||||||
| NETPR_PRIC_UNIT | PRCT_COND_PRICING_UNIT | DEC | 5(0) | Condition Pricing Unit | PRC_CONDITION_PRICING_UNIT | VF | CRM | |||||
| NETPR_UOM | PRCT_COND_UOM | UNIT | 3(0) | * | Condition Unit | MEINS | CRM |