CRMT_PRICING_DB_WRK SAP (Pricing Set: Database Buffer Work Area) Structure details

Dictionary Type: Structure
Description: Pricing Set: Database Buffer Work Area




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




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

CRMT_PRICING_DB_WRK is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Pricing Set: Database Buffer Work Area" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CRMT_PRICING_DB_WRK TYPE CRMT_PRICING_DB_WRK.

The CRMT_PRICING_DB_WRK table consists of various fields, each holding specific information or linking keys about Pricing Set: Database Buffer Work Area 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CRMT_PRICING_DB_WRK structure 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
NOREC_FLAGEntry does not Exist in Database CRMT_NORECCHAR1CRM_BOOLEAN

Key field Non-key field



How do I retrieve data from SAP structure CRMT_PRICING_DB_WRK using ABAP code?

As CRMT_PRICING_DB_WRK is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CRMT_PRICING_DB_WRK as there is no data to select.

How to access SAP table CRMT_PRICING_DB_WRK

Within an ECC or HANA version of SAP you can also view further information about CRMT_PRICING_DB_WRK 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!