CRMD_PRICING SAP (Business Transaction Pricing Parameter Set) Table details

Dictionary Type: Table
Description: Business Transaction Pricing Parameter Set




ABAP Code to SELECT data from CRMD_PRICING
Related tables to CRMD_PRICING
Access table CRMD_PRICING




Table field list including key, data, relationships and ABAP select examples

CRMD_PRICING is a standard SAP Table which is used to store Business Transaction Pricing Parameter Set data and is available within R/3 SAP systems depending on the version and release level.

The CRMD_PRICING table consists of various fields, each holding specific information or linking keys about Business Transaction Pricing Parameter Set data available in SAP. These include CLIENT (Client), GUID (GUID of a CRM Order Object), EXCHG_TYPE (Exchange Rate Type), EXCHG_DATE (Exchange Rate Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CRMD_PRICING table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
EXCHG_TYPEExchange Rate Type CRMT_EXCHG_TYPECHAR4TCURVKURST
EXCHG_DATEExchange Rate Date CRMT_EXCHG_DATEDATS8CRM_EXCHG_DATE
TAXJURCODETax Jurisdiction Code (Structure for tax calculation) CRMT_TAXJURCODECHAR15Assigned to domainTXJCDCRM_TAX_SH_TAXJURCODE
CUST_PRIC_PROCCustomer Pricing Procedure CRMT_CUST_PRIC_PROCCHAR1Assigned to domainCRM_CUST_PRIC_PROC
REF_CURRENCYReference Currency CRMT_REF_CURRENCYCUKY5TCURCWAERS
ENT_STRATEGYEntitlement Strategy CRMT_ENT_STRATEGYCHAR1CRM_ENT_STRATEGY
CURRENCYCurrency CRMT_CURRENCYCUKY5TCURCWAERSFWS
PRICE_DATEPricing Date CRMT_PRICE_DATEDATS8CRM_PRICE_DATE
PMNTTRMSTerms of Payment CRMT_PMNTTRMSCHAR4Assigned to domainCRM_PMNTTRMS
PRICE_GRPCustomer Price Group CRMT_PRICE_GRPCHAR2CRMC_PRICEGRPCRM_PRICE_GRPCRM_PRICE_GRP
PRICE_LISTPrice List Type CRMT_PRICE_LISTCHAR2CRMC_PRICELISTCRM_PRICE_LISTCRM_PRICE_LIST
CUST_GROUPCustomer Group CRMT_CUST_GROUPCHAR2CRMC_CUSTGRPCRM_CUST_GROUP
EXCHG_RATEExchange Rate CRMT_EXCHG_RATEDEC9(5) EXCRTCRM_EXCHG_RATE
TAX_DEST_CTYTax Destination Country CRMT_TAX_DEST_CTYCHAR3T005LAND1
TAX_DEST_REGRegion (State, Province, County) CRMT_REGIONCHAR3Assigned to domainREGIO
VAT_REG_NOSales tax registration number CRMT_VAT_REG_NOCHAR20
ETAX_HAND_TYPEExcise Tax Handling Type (Denotes Use of Material) CRMT_ETAX_HAND_TYPECHAR2Assigned to domainCRM_ETAX_HAND_TYPE
ETAX_SOURCESource of Excise Tax Rates CRMT_ETAX_SOURCECHAR2Assigned to domainCRM_ETAX_SOURCE
SCOREResult Value of an Internal Creditworthiness Check CRMT_SCORECHAR10CRM_SCORE
GRADERating BP_GRADECHAR10Assigned to domainBP_GRADE
AC_INDICATORAccounting Indicator CRMT_AC_INDICATORCHAR2CRMC_AC_INDCRMT_AC_INDICATOR
CUSTOMER_TYPEBusiness Partner Type CRMT_CUSTOMER_TYPECHAR4Assigned to domainBU_KIND
CFOP_CODECFOP Code and Extension ITL_CFOPCHAR10COMC_CFOP_CODECFOBRITL_CFOP
ICMS_TAXLAWICMS Tax Law ID ITL_TAXLAW1CHAR3COMC_TAX_LAW_1ALPHAITL_TAXLAW1
IPI_TAXLAWIPI Tax Law ID ITL_TAXLAW2CHAR3COMC_TAX_LAW_2ALPHAITL_TAXLAW2
TAX_MAT_USAGEMaterial Usage TAX_MAT_USAGECHAR1Assigned to domainTAX_MAT_USAGE
LOC_TAXCATTax Category LOC_TAXCATCHAR2CRMC_TAXCATLOC_TAXCAT
LOC_ZEROVATReason for Zero-Rated VAT LOC_ZEROVATCHAR1CRMC_ZEROVATLOC_ZEROVAT
LOC_ACTCODEActivity Code for Gross Income Tax LOC_ACTCODECHAR2CRMC_ACTCODELOC_ACTCODE
LOC_DISTTYPEDistribution Type for Employment Tax LOC_DISTTYPECHAR2CRMC_DISTTYPELOC_DISTTYPE
LOC_TXRELCLASTax Relevance Classification LOC_TXRELCLASCHAR10CRMC_TXRELCLASLOC_TXRELCLAS
PAYMENT_METHODPayment Method CRMT_BUAG_PAYMETHCHAR1Assigned to domainCRM_BUAG_PAYMETH
SCRAP_VALUEThreshold for Further Action for New Parts CRMT_SPL_SCRAP_VALUECURR10(2)
SCRAP_CURRENCYCurrency Key for Reuse Threshold Value CRMT_SPL_SCRAP_CUKYCUKY5Assigned to domainWAERS
SCRAP_INSTR_LOWProcedure for Values under Threshold CRMT_SPL_SCRAP_INSTR_LOWCHAR1CRM_SPL_SCRAP_INSTRUCTION
SCRAP_INSTR_HIGHProcedure for Values over Threshold CRMT_SPL_SCRAP_INSTR_HIGHCHAR1CRM_SPL_SCRAP_INSTRUCTION
VALID_FROMTime Dependency: Validity Start Date CRMT_VALID_FROMDEC15TSTPSBCOS_TSTMP
VALID_TOTime Dependency: Validity End Date CRMT_VALID_TODEC15TSTPSBCOS_TSTMP
TRANS_TIMETime Last Change was Made CRMT_TRANS_TIMEDEC15TSTPSBCOS_TSTMP

Key field Non-key field



How do I retrieve data from SAP table CRMD_PRICING using ABAP code

The following ABAP code Example will allow you to do a basic selection on CRMD_PRICING to SELECT all data from the table
DATA: WA_CRMD_PRICING TYPE CRMD_PRICING.

SELECT SINGLE *
FROM CRMD_PRICING
INTO CORRESPONDING FIELDS OF WA_CRMD_PRICING
WHERE...

How to access SAP table CRMD_PRICING

Within an ECC or HANA version of SAP you can also view further information about CRMD_PRICING and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!