CRMR_PRICING

Data for Pricing | #transactional | Component: Business Transactions
Column Name Description
CLIENT Client
GUID GUID of a CRM Order Object
Column Name Description
💲 null (SCRAP_CURRENCY):
SCRAP_VALUE null
Column Name Description
Column Name Description
EXCHG_DATE Exchange Rate Date
PRICE_DATE Pricing Date
FUND_EXCHG_DATE null
Column Name Description
ENT_STRATEGY Entitlement Strategy Show values
PRICING_CONTROL Pricing Control Show values
Column Name Description Domain name
REF_GUID GUID of a CRM Order Object SYSUUID
VALID_FROM Time Dependency: Validity Start Date BCOS_TSTMP
VALID_TO Time Dependency: Validity End Date BCOS_TSTMP
TRANS_TIME Time Last Change was Made BCOS_TSTMP
TAXJURCODE Tax Jurisdiction Code (Structure for tax calculation) TXJCD
CUST_PRIC_PROC Customer Pricing Procedure KALKS
PMNTTRMS Terms of Payment ZTERM
EXCHG_RATE Exchange Rate CRM_EXCHG_RATE
TAX_DEST_REG Region (State, Province, County) REGIO
VAT_REG_NO Sales tax registration number
ETAX_HAND_TYPE Excise Tax Handling Type (Denotes Use of Material) CRM_ETAX_HAND_TYPE
ETAX_SOURCE Source of Excise Tax Rates CRM_ETAX_SOURCE
SCORE Result Value of an Internal Creditworthiness Check CRM_SCORE
GRADE Rating BP_GRADE
CUSTOMER_TYPE Business Partner Type BU_KIND
TAX_MAT_USAGE null
ISS_TAXLAW null
COFINS_TAXLAW null
PIS_TAXLAW null
PAYMENT_METHOD Payment Method ZLSCH
SCRAP_INSTR_LOW null
SCRAP_INSTR_HIGH null
LOY_MEMS_ID null
LOY_PSH_ID null
FUND_EXCHG_TYPE null
FUND_EXCHG_RATE null
FUND_EXCHG_R_TG null
PRICING_DUMMY Dummy function in length 1 DUMMY
TAX_EXEMPT_GUID null
TAX_EXEMPT_ID null
POINT_PMT_INDIC null
POINT_PMT_AMT null
POINT_PMT_PTYPE null
Master Data Relations Join Conditions
Validation of Accounting Indicator
  • CRMR_PRICING.CLIENT == TBMOT.MANDT
  • CRMR_PRICING.AC_INDICATOR == TBMOT.BEMOT
Currency
  • CRMR_PRICING.CLIENT == TCURC.MANDT
  • CRMR_PRICING.CURRENCY == TCURC.WAERS
Customer Group
  • Customer Group
  • Client
  • CRMR_PRICING.CUST_GROUP == T151.KDGRP
  • CRMR_PRICING.CLIENT == T151.MANDT
Exchange Rate Type
  • CRMR_PRICING.CLIENT == TCURV.MANDT
  • CRMR_PRICING.EXCHG_TYPE == TCURV.KURST
Customer Price Group
  • Customer Price Group
  • Client
  • CRMR_PRICING.PRICE_GRP == T188.KONDA
  • CRMR_PRICING.CLIENT == T188.MANDT
Price List Type
  • CRMR_PRICING.CLIENT == T189.MANDT
  • CRMR_PRICING.PRICE_LIST == T189.PLTYP
Reference Currency
  • CRMR_PRICING.CLIENT == TCURC.MANDT
  • CRMR_PRICING.REF_CURRENCY == TCURC.WAERS
Tax Destination Country/Region
  • Tax Destination Country/Region
  • Client
  • CRMR_PRICING.TAX_DEST_CTY == T005.LAND1
  • CRMR_PRICING.CLIENT == T005.MANDT