SAP S/4Hana table CRMD_PRICING stores Business Transaction Pricing Parameter Setdata
So we all know that S/4Hana is the latest version and the future of SAP but what about the tables we are familiar with, are they still available and what do tables like CRMD_PRICING look like in an S4Hana SAP system. If you havent seen or logged into an S/4Hana system you might be surprise how similar it looks to the previous ERP/ECC version. Infact when using using the gui it is difficult to tell the difference, and for many of database tables the same is true.
Infact even for tables that have been replaced in hana, SAP have purposfully created versions of the old/original tables for backward compatability. This means your existing ABAP code will still work while you implement changes that take advantage of the new functionality and Hana in-memory tables.
S4 Hana CRMD_PRICING dictionary attributes
Object Name: CRMD_PRICING
Dictionary Type: Transparent table
Description: Business Transaction Pricing Parameter Set
Field list for CRMD_PRICING table on an S/4 SAP system
| 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 | |||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | |||||||
| EXCHG_TYPE | CRMT_EXCHG_TYPE | CHAR | 4(0) | TCURV | Exchange Rate Type | KURST | ||||||
| EXCHG_DATE | CRMT_EXCHG_DATE | DATS | 8(0) | Exchange Rate Date | CRM_EXCHG_DATE | |||||||
| TAXJURCODE | CRMT_TAXJURCODE | CHAR | 15(0) | Tax Jurisdiction Code (Structure for tax calculation) | TXJCD | CRM_TAX_SH_TAXJURCODE | TAXJURCODE | |||||
| CUST_PRIC_PROC | CRMT_CUST_PRIC_PROC | CHAR | 2(0) | * | Customer Pricing Procedure | KALKS | ||||||
| REF_CURRENCY | CRMT_REF_CURRENCY | CUKY | 5(0) | TCURC | Reference Currency | WAERS | ||||||
| ENT_STRATEGY | CRMT_ENT_STRATEGY | CHAR | 1(0) | Entitlement Strategy | CRM_ENT_STRATEGY | |||||||
| CURRENCY | CRMT_CURRENCY | CUKY | 5(0) | TCURC | Currency | WAERS | FWS | |||||
| PRICE_DATE | CRMT_PRICE_DATE | DATS | 8(0) | Pricing Date | CRM_PRICE_DATE | |||||||
| PMNTTRMS | CRMT_PMNTTRMS | CHAR | 4(0) | Terms of Payment | ZTERM | |||||||
| PRICE_GRP | CRMT_PRICE_GRP | CHAR | 2(0) | T188 | Customer Price Group | KONDA | CRM_PRICE_GRP | PRICE_GROUP | ||||
| PRICE_LIST | CRMT_PRICE_LIST | CHAR | 2(0) | T189 | Price List Type | PLTYP | CRM_PRICE_LIST | PRICE_LIST | ||||
| CUST_GROUP | CRMT_CUST_GROUP | CHAR | 2(0) | T151 | Customer Group | KDGRP | ||||||
| EXCHG_RATE | CRMT_EXCHG_RATE | DEC | 9(5) | Exchange Rate | CRM_EXCHG_RATE | |||||||
| TAX_DEST_CTY | CRMT_TAX_DEST_CTY | CHAR | 3(0) | T005 | Tax Destination Country | LAND1 | ||||||
| TAX_DEST_REG | CRMT_REGION | CHAR | 3(0) | * | Region (State, Province, County) | REGIO | ||||||
| VAT_REG_NO | CRMT_VAT_REG_NO | CHAR | 20(0) | Sales tax registration number | ||||||||
| ETAX_HAND_TYPE | CRMT_ETAX_HAND_TYPE | CHAR | 2(0) | * | Excise Tax Handling Type (Denotes Use of Material) | CRM_ETAX_HAND_TYPE | ||||||
| ETAX_SOURCE | CRMT_ETAX_SOURCE | CHAR | 2(0) | * | Source of Excise Tax Rates | CRM_ETAX_SOURCE | ||||||
| SCORE | CRMT_SCORE | CHAR | 10(0) | Result Value of an Internal Creditworthiness Check | CRM_SCORE | |||||||
| GRADE | BP_GRADE | CHAR | 10(0) | * | Rating | BP_GRADE | ||||||
| AC_INDICATOR | CRMT_AC_INDICATOR | CHAR | 2(0) | TBMOT | Accounting Indicator | BEMOT | CRM_AC_IND | AC_INDICATOR | ||||
| CUSTOMER_TYPE | CRMT_CUSTOMER_TYPE | CHAR | 4(0) | * | Business Partner Type | BU_KIND | ||||||
| CFOP_CODE | ITL_CFOP | CHAR | 10(0) | COMC_CFOP_CODE | CFOP Code and Extension | ITL_CFOP | ||||||
| ICMS_TAXLAW | ITL_TAXLAW1 | CHAR | 3(0) | COMC_TAX_LAW_1 | ICMS Tax Law ID | ITL_TAXLAW1 | ||||||
| IPI_TAXLAW | ITL_TAXLAW2 | CHAR | 3(0) | COMC_TAX_LAW_2 | IPI Tax Law ID | ITL_TAXLAW2 | ||||||
| TAX_MAT_USAGE | TAX_MAT_USAGE | CHAR | 1(0) | Material Usage | TAX_MAT_USAGE | |||||||
| LOC_TAXCAT | LOC_TAXCAT | CHAR | 2(0) | CRMC_TAXCAT | Tax Category | LOC_TAXCAT | ||||||
| LOC_ZEROVAT | LOC_ZEROVAT | CHAR | 1(0) | CRMC_ZEROVAT | Reason for Zero-Rated VAT | LOC_ZEROVAT | ||||||
| LOC_ACTCODE | LOC_ACTCODE | CHAR | 2(0) | CRMC_ACTCODE | Activity Code for Gross Income Tax | LOC_ACTCODE | ||||||
| LOC_DISTTYPE | LOC_DISTTYPE | CHAR | 2(0) | CRMC_DISTTYPE | Distribution Type for Employment Tax | LOC_DISTTYPE | ||||||
| LOC_TXRELCLAS | LOC_TXRELCLAS | CHAR | 10(0) | CRMC_TXRELCLAS | Tax Relevance Classification | LOC_TXRELCLAS | ||||||
| ISS_TAXLAW | LOC_TAX_LAW3 | CHAR | 3(0) | ISS Tax Law | LOC_TAX_LAW3 | |||||||
| COFINS_TAXLAW | LOC_TAX_LAW4 | CHAR | 3(0) | COFINS Tax Law | LOC_TAX_LAW4 | |||||||
| PIS_TAXLAW | LOC_TAX_LAW5 | CHAR | 3(0) | PIS Tax Law | LOC_TAX_LAW5 | |||||||
| PAYMENT_METHOD | CRMT_BUAG_PAYMETH | CHAR | 1(0) | * | Payment Method | CRM_BUAG_PAYMETH | ||||||
| SCRAP_VALUE | CRMT_SPL_SCRAP_VALUE | CURR | 10(2) | Threshold for Further Action for New Parts | ||||||||
| SCRAP_CURRENCY | CRMT_SPL_SCRAP_CUKY | CUKY | 5(0) | * | Currency Key for Reuse Threshold Value | WAERS | ||||||
| SCRAP_INSTR_LOW | CRMT_SPL_SCRAP_INSTR_LOW | CHAR | 1(0) | Procedure for Values under Threshold | CRM_SPL_SCRAP_INSTRUCTION | |||||||
| SCRAP_INSTR_HIGH | CRMT_SPL_SCRAP_INSTR_HIGH | CHAR | 1(0) | Procedure for Values over Threshold | CRM_SPL_SCRAP_INSTRUCTION | |||||||
| LOY_MEMS_ID | CRM_LOY_MEMS_ID | CHAR | 10(0) | Membership ID | CRM_LOY_MEMS_ID | |||||||
| LOY_PSH_ID | CRM_LOY_PSH_ID | CHAR | 10(0) | Partnership ID | CRM_LOY_PSH_ID | |||||||
| FUND_EXCHG_TYPE | CRMT_FUND_EXCHG_TYPE | CHAR | 4(0) | * | Fund Exchange Rate Type | KURST | ||||||
| FUND_EXCHG_DATE | CRMT_FUND_EXCHG_DATE | DATS | 8(0) | Fund Exchange Date | CRM_EXCHG_DATE | |||||||
| FUND_EXCHG_RATE | CRMT_FUND_EXCHG_RATE | DEC | 9(5) | Fund Exchange Rate | CRM_EXCHG_RATE | |||||||
| FUND_EXCHG_R_TG | CRMT_FUND_EXCHG_RATE | DEC | 9(5) | Fund Exchange Rate | CRM_EXCHG_RATE | |||||||
| PRICING_DUMMY | DUMMY | CHAR | 1(0) | Dummy function in length 1 | DUMMY | SAP | ||||||
| TAX_EXEMPT_GUID | CRM_TAX_EXEMPT_HEADER_GUID | RAW | 16(0) | Object Header GUID | SYSUUID | |||||||
| TAX_EXEMPT_ID | CRM_TAX_EXEMPT_ID | CHAR | 30(0) | Customer Tax Exemption Certificate ID | CRM_TAX_EXEMPT_ID | |||||||
| POINT_PMT_INDIC | CRMT_LOY_POINT_PAYMENT | CHAR | 1(0) | Point Payment Option | CRM_LOY_POINT_PAYMENT | |||||||
| POINT_PMT_AMT | CRMT_LOY_PMT_AMT | DEC | 10(2) | Point Payment Amount - Header | ||||||||
| POINT_PMT_PTYPE | CRMT_LOY_PMT_PTTYPE | CHAR | 10(0) | Payment Point Type | CRM_MKTPL_LOY_POINT_CODE | |||||||
| PRICING_CONTROL | CRMS4_PRICING_CONTROL | CHAR | 1(0) | Pricing Control | CRMS4_PRICING_CONTROL | |||||||
| VALID_FROM | CRMT_VALID_FROM | DEC | 15(0) | Time Dependency: Validity Start Date | BCOS_TSTMP | |||||||
| VALID_TO | CRMT_VALID_TO | DEC | 15(0) | Time Dependency: Validity End Date | BCOS_TSTMP | |||||||
| TRANS_TIME | CRMT_TRANS_TIME | DEC | 15(0) | Time Last Change was Made | BCOS_TSTMP |
View list of all S4 Hana tables
