CRMT_BSP_SLS_I_PRICING_IL SAP (Pricing: General Data) Structure details

Dictionary Type: Structure
Description: Pricing: General Data




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




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

CRMT_BSP_SLS_I_PRICING_IL 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: General Data" 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_BSP_SLS_I_PRICING_IL TYPE CRMT_BSP_SLS_I_PRICING_IL.

The CRMT_BSP_SLS_I_PRICING_IL table consists of various fields, each holding specific information or linking keys about Pricing: General Data data available in SAP. These include GUID (GUID of a CRM Order Object), HANDLE (Handle), CUST_GROUP1 (Customer Group 1), CUST_GROUP2 (Customer Group 2).. 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: Can Be Enhanced (Deep)


SAP CRMT_BSP_SLS_I_PRICING_IL 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
GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
HANDLEHandle CRMT_HANDLENUMC10
CUST_GROUP1Customer Group 1 CRMT_CUST_GROUP1CHAR3CRMC_CUSTGRP1CRM_CUST_GROUP1
CUST_GROUP2Customer Group 2 CRMT_CUST_GROUP2CHAR3CRMC_CUSTGRP2CRM_CUST_GROUP2
CUST_GROUP3Dishonour Reason CRMT_CUST_GROUP3CHAR3CRMC_CUSTGRP3CRM_CUST_GROUP3
CUST_GROUP4Customer Group 4 CRMT_CUST_GROUP4CHAR3CRMC_CUSTGRP4CRM_CUST_GROUP4
CUST_GROUP5Customer Group 5 CRMT_CUST_GROUP5CHAR3CRMC_CUSTGRP5CRM_CUST_GROUP5
PO_NUMBER_SOLDSold-To Party's External Reference Number CRMT_PO_NUMBER_SOLDCHAR35TEXT35
PO_DATE_SOLDReference Document Date CRMT_PO_DATE_SOLDDATS8DATUM
YOUR_REF_SOLDSold-to Party Reference CRMT_YOUR_REFERENCE_SOLDCHAR12TEXT12
INDUSTRYIndustry Sector CRMT_INDUSTRYCHAR4Assigned to domainCRM_INDUSTRY
REGIONRegion (State, Province, County) CRMT_REGIONCHAR3Assigned to domainREGIO
PO_NUMBER_SHIPShip-To Party's External Reference Number CRMT_PO_NUMBER_SHIPCHAR35TEXT35
PO_DATE_SHIPShip-To Party's Reference Document Date CRMT_PO_DATE_SHIPDATS8DATUM
YOUR_REF_SHIPShip-To Party Reference CRMT_YOUR_REFERENCE_SHIPCHAR12TEXT12
USAGE_TYPEUsage Indicator CRMT_USAGECHAR3Assigned to domainCRM_USAGE
SUBMISSIONCollective Number for Quotations CRMT_SUBMISSIONCHAR10TEXT10
REJECTIONCancellation Reason Code CRMT_REJECTION_CODECHAR2Assigned to domainCRM_REJECTION_CODE
PCAT_HDR_IDProduct Catalog Number COMT_PCAT_IDCHAR30COM_PCAT_OBJECTIDCOM_PRDCATCOM_PCAT_HDR_ID
PCAT_VRT_IDCatalog Variant Number COMT_PCAT_VRT_IDCHAR30COM_PCAT_OBJECTID
PCAT_CTY_IDCatalog Area Number COMT_PCAT_CTY_IDCHAR30COM_PCAT_OBJECTIDCOM_PCAT_CTY_ID
PARTNER_PRODProduct Number of Business Partner CRMT_ITEM_DESCR_PARTNERCHAR40PRSHTEXT40
PRODUCT_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
INT_INSPECTIONInternal Quality Inspection CRMT_INT_INSPECTIONCHAR4CRMC_ITEM_INSPCRM_ITEM_INSPECTION
HNDLCODEHandling Indicator CRM_PROD_HNDLCODECHAR4Assigned to domainCRM_PROD_HNDLCODE
HNDLCODE_TEXTDescription (20 Characters) CRMT_DESCRIPTION_20CHAR20TEXT20
INCOTERMS1Incoterms (Part 1) CRMT_INCOTERMS1CHAR3CRMC_INCOTERMCRM_INCOTERMS1
INCOTERMS2Incoterms (Part 2) CRMT_INCOTERMS2CHAR28CRM_INCOTERMS2
SHIP_CONDShipping Conditions CRMT_SHIP_CONDCHAR2CRMC_SHIP_CONDCRM_SHIP_COND
DELI_UNLIM_TOLIndicator: Unlimited Overdelivery Allowed CRMT_DELI_UNLIM_TOLCHAR1CRM_BOOLEAN
OVER_DLV_TOLOverdelivery Tolerance Limit CRMT_OVER_DLV_TOLDEC3(1) PRZ21
UNDER_DLV_TOLUnderdelivery Tolerance Limit CRMT_UNDER_DLV_TOLDEC3(1) PRZ21
DLV_PRIODelivery Priority CRMT_DLV_PRIONUMC2Assigned to domainCRM_DLV_PRIOCRM_DELIVERY_PRIORITY
ORDERCOMBINDIndicator: Order Combination CRMT_ORDERCOMBINDCHAR1CRM_BOOLEAN
PART_DLVDelivery Control CRMT_PART_DLVCHAR1CRM_PART_DLV
DLV_GROUPDelivery Group (Items are Delivered Together) CRMT_DLV_GROUPNUMC3CRMT_DLV_GROUP
PART_DLV_ITMDelivery Control (Item) CRMT_PART_DLV_ITMCHAR1CRM_PART_DLV_ITM
REQ_DATERequested Delivery Date: Input/Output Field CRMT_BSP_REQ_DLV_DATEDATS8DATS
REQ_TIMETime CRMT_BSP_TIMECHAR6CHAR6
REQ_TIMEVALUECharacter field of length 6 CHAR6CHAR6CHAR6
REQ_DATE_TZTFRequested Delivery Date: Input/Output Field CRMT_REQ_DLV_DATE_TZTFCHAR26TZTF_IO_FIELD
RULE_REQ_DATE_TRule Req Delivery Date CRMT_RULE_REQ_DATE_TCHAR12TIMENAME
TRANS_MOTMode of Transport CRMT_TRANS_MOTCHAR2CRMC_TRANS_MOTCRM_TRANS_MOT
GEOROUTERoute CRMT_GEOROUTECHAR10CRM_GEOROUTECRM_GEOROUTE
TRANS_MEANSMeans of Transport (from SCM System) CRMT_TRANS_MEANSCHAR10CRM_TRANS_MEANSCRM_TRANS_MEANS
INV_BEFORE_GIInvoice Before Goods Issue (IBGI) CRMT_BEFORE_LOADINGCHAR1CRM_BEFORE_LOADING
SALES_ORGSales Organization CRMT_SALES_ORGCHAR14HROBJEC_14CRM_ORGMAN_SALES_ORG
SALES_OFFICESales Office CRMT_SALES_OFFICECHAR14HROBJEC_14CRM_ORGMAN_SALES_OFFICE
SALES_GROUPSales Group CRMT_SALES_GROUPCHAR14HROBJEC_14CRM_ORGMAN_SALES_GROUP
SALES_ORG_RESPOrganizational Unit (Sales) CRMT_SALES_ORG_RESPCHAR14HROBJEC_14
DIS_CHANNELDistribution Channel CRMT_DISTRIBUTION_CHANNELCHAR2Assigned to domainCRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNEL
DIVISIONDivision CRMT_DIVISIONCHAR2Assigned to domainCRM_DIVISIONCRM_DIVISION
SERVICE_ORGService Organization CRMT_SERVICE_ORGCHAR14HROBJEC_14CRM_ORGMAN_SERVICE_ORG
SERVICE_ORG_RESPOrganizational Unit (Service) CRMT_SERVICE_ORG_RESPCHAR14HROBJEC_14
SALES_ORG_SHORTSales Organization: Description of Department CRMT_SALES_ORG_SHORTCHAR12TEXT12
SALES_OFFICE_SHORTSales Office Abbreviation CRMT_SALES_OFFICE_SHORTCHAR12TEXT12
SALES_GROUP_SHORTSales Group Abbreviation CRMT_SALES_GROUP_SHORTCHAR12TEXT12
SALES_ORG_RESP_SHORTAbbreviation: Responsible Organizational Unit (Sales) CRMT_SALES_ORG_RESP_SHORTCHAR12TEXT12
SERVICE_ORG_SHORTService Organization Identifier CRMT_SERVICE_ORG_SHORTCHAR12TEXT12
SERVICE_ORG_RESP_SHORTAbbreviation: Responsible Organizational Unit (Service) CRMT_SERVICE_ORG_RESP_SHORTCHAR12TEXT12
SALES_ORG_DSCRDescription (40 Characters) CRMT_DESCRIPTION_40CHAR40TEXT40
SALES_OFFICE_DSCRDescription (40 Characters) CRMT_DESCRIPTION_40CHAR40TEXT40
SALES_GROUP_DSCRDescription (40 Characters) CRMT_DESCRIPTION_40CHAR40TEXT40
SALES_ORG_RESP_DSCRDescription (40 Characters) CRMT_DESCRIPTION_40CHAR40TEXT40
DIS_CHANNEL_DSCRDescription (40 Characters) CRMT_DESCRIPTION_40CHAR40TEXT40
SERVICE_ORG_RESP_DSCRDescription (40 Characters) CRMT_DESCRIPTION_40CHAR40TEXT40
SERVICE_ORG_DSCRDescription (40 Characters) CRMT_DESCRIPTION_40CHAR40TEXT40
DIVISION_DSCRDescription (40 Characters) CRMT_DESCRIPTION_40CHAR40TEXT40
SALES_ORG_ORIOrigin Indicator: Sales Organization CRMT_SALES_ORG_ORIGINCHAR1CRM_ORIGIN
DIS_CHANNEL_ORIOrigin Indicator: Distribution Channel CRMT_DIS_CHANNEL_ORIGINCHAR1CRM_ORIGIN
SALES_OFF_ORIOrigin Indicator: Sales Office CRMT_SALES_OFFICE_ORIGINCHAR1CRM_ORIGIN
SALES_GROUP_ORIOrigin Indicator: Sales Group CRMT_SALES_GROUP_ORIGINCHAR1CRM_ORIGIN
SALES_ORGR_ORIOrigin Indicator: Sales Scenario Organizational Unit CRMT_SALES_ORG_RESP_ORIGINCHAR1CRM_ORIGIN
DIVISION_ORIOrigin Flag: Division CRMT_DIVISION_ORIGINCHAR1CRM_ORIGIN
SERVICE_ORG_ORIOrigin Indicator: Service Organization CRMT_SERVICE_ORG_ORIGINCHAR1CRM_ORIGIN
SERVICE_ORGR_ORIOrigin Indicator: Service Scenario Organizational Unit CRMT_SERVICE_ORG_RESP_ORIGINCHAR1CRM_ORIGIN
NET_WEIGHTNet Weight CRMT_NET_WEIGHTQUAN15(3) MENG15
GROSS_WEIGHTGross Weight CRMT_GROSS_WEIGHTQUAN15(3) MENG15
WEIGHT_UNITWeight Unit COMT_WEIGHT_UNITUNIT3Assigned to domainCUNITMEINS
VOLUMEVolume Occupied by the Product per Volume Unit CRMT_VOLUMEQUAN15(3) MENG15
VOLUME_UNITUnit for the Volume of a Product COMT_VOLUME_UNITUNIT3Assigned to domainCUNITMEINS
PROD_HIERARCHYProduct Category CRMT_PROD_HIERARCHYCHAR20COM_CATEGORY_IDCOM_CAT_SALES
BILL_DATEBilling Date for Billing Index and Printout CRMT_BSP_BILL_DATEDATS8DATS
BILL_DATE_TZTFBilling Date for Billing Index and Printout CRMT_BILL_DATE_TZTFCHAR26TZTF_IO_FIELD
INVCR_DATE_TZTFBilling Document Creation Date CRMT_INVCR_DATE_TZTFCHAR26TZTF_IO_FIELD
VALUE_DATE_TZTFFixed Value Date CRMT_VALUE_DATE_TZTFCHAR26TZTF_IO_FIELD
RULE_BILL_DATE_TRule for Determining the Next Billing Date CRMT_RULE_BILL_DATE_TCHAR12TIMENAME
RULE_INV_DATE_TRule for Determining Next Billing Document Creation Date CRMT_RULE_INVCR_DATE_TCHAR12TIMENAME
RULE_VAL_DATE_TRule for Origin of Next Fixed Value Date CRMT_RULE_VALUE_DATE_TCHAR12TIMENAME
BILLING_TIMEZONETime Zone of Billing Plan Set CRMT_BILLING_TIMEZONECHAR6Assigned to domainTZNZONE
BUAG_IDNumber of the Business Agreement CRMT_BUAG_IDCHAR12ALPHACRMT_BUAG_IDCRM_BUAG
BUAG_TEXTText for Business Agreement CRMT_BUAG_TEXTCHAR30CHAR30LOW
BILLED_QTYBilled Quantity CRMT_BILLED_QTYQUAN15(3) CRM_MENGV15
BILL_QTY_UNITUnit of Measure in Which the Product Is Sold CRMT_PROCESS_QTY_UNITUNIT3Assigned to domainCUNITMEINS
BILLED_VALUEBilled Value CRMT_BILLED_VALUECURR19(2) PRC_COND_VALUE
BILL_CURRENCYCurrency CRMT_CURRENCYCUKY5Assigned to domainWAERSFWS
BILLING_RELEVANTBilling Relevance CRMT_BILLING_RELEVANTCHAR1CRM_BILLING_RELEVANT
PMNTTRMSTerms of Payment CRMT_PMNTTRMSCHAR4CRMC_PMNTTRMSCRM_PMNTTRMS
PMNTTRMS_TDescription CRMT_DESCRIPTIONCHAR40TEXT40
CUST_GROUPCustomer Group CRMT_CUST_GROUPCHAR2Assigned to domainCRM_CUST_GROUP
EXCHG_RATEExchange Rate CRMT_EXCHG_RATEDEC9(5) EXCRTCRM_EXCHG_RATE
EXCHG_DATEExchange Rate Date CRMT_EXCHG_DATEDATS8CRM_EXCHG_DATE
EXCHG_TYPEExchange Rate Type CRMT_EXCHG_TYPECHAR4Assigned to domainKURST
TAX_DEST_CTYTax Destination Country CRMT_TAX_DEST_CTYCHAR3Assigned to domainLAND1
TAX_DEST_CTY_TDescription (20 Characters) CRMT_DESCRIPTION_20CHAR20TEXT20
TAX_DEST_REGRegion (State, Province, County) CRMT_REGIONCHAR3Assigned to domainREGIO
TAX_DEST_REG_TDescription (20 Characters) CRMT_DESCRIPTION_20CHAR20TEXT20
VAT_REG_NOSales tax registration number CRMT_VAT_REG_NOCHAR20
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
PRICE_DATEPricing Date CRMT_PRICE_DATEDATS8CRM_PRICE_DATE
PRICE_GRPCustomer Price Group CRMT_PRICE_GRPCHAR2Assigned to domainCRM_PRICE_GRPCRM_PRICE_GRP
PRICE_LISTPrice List Type CRMT_PRICE_LISTCHAR2Assigned to domainCRM_PRICE_LISTCRM_PRICE_LIST
PRICING_PROCEDUREPricing Procedure PRCT_PRIC_PROCCHAR6Assigned to domainPRC_PRIC_PROC
ETAX_HAND_TYPEExcise Tax Handling Type (Denotes Use of Material) CRMT_ETAX_HAND_TYPECHAR2CRMC_ETAX_HTYPCRM_ETAX_HAND_TYPE
ETAX_SOURCESource of Excise Tax Rates CRMT_ETAX_SOURCECHAR2CRMC_ETAX_SRCCRM_ETAX_SOURCE
PAYMENT_METHODPayment Method CRMT_BUAG_PAYMETHCHAR1Assigned to domainCRM_BUAG_PAYMETH
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
CFOP_TEXTCFOP Description ITL_CFOP_TEXTCHAR40TEXT40
ICMS_TAX_LAW_DESCRDescription ITL_TAXLAW_DESCRCHAR60TEXT60
IPI_TAX_LAW_DESCRDescription ITL_TAXLAW_DESCRCHAR60TEXT60
TAX_MAT_USAGE_DESCRDescription (40 Characters) CRMT_DESCRIPTION_40CHAR40TEXT40
TAXCAT_TEXTText TEXT1CHAR50TEXT50
VATZERO_TEXTText TEXT1CHAR50TEXT50
ACTCODE_TEXTText TEXT1CHAR50TEXT50
DISTTYPE_TEXTText TEXT1CHAR50TEXT50
TXRELCLAS_TEXTText TEXT1CHAR50TEXT50
TAX_DEPART_CTYTax Departure Country CRMT_TAX_DEPART_CTYCHAR3Assigned to domainLAND1
TAX_DEPART_REGDeparture Region for Tax CRMT_TAX_DEPART_REGCHAR3Assigned to domainREGIO
TAXJURCODE_FROMTax Jurisdiction Code (Structure for tax calculation) CRMT_TAXJURCODECHAR15Assigned to domainTXJCDCRM_TAX_SH_TAXJURCODE
TAX_GROUP_PProduct Tax Group CRMT_TAX_GROUPCHAR20CRM_TAX_GROUP
TAX_TARIFF_CODETax Tariff Code CRMT_TAX_TARIFF_CODECHAR16CHAR16
PRC_INDICATORPricing indicator CRMT_PRICING_INDICATORCHAR1CRM_PRICING_INDICATOR
NET_VALUENet Value CRMT_NET_VALUECURR15(2) WERTV8
NET_PRICENet Price CRMT_NET_PRICECURR15(2) WERTV8
TAX_AMOUNTTax amount in document currency CRMT_TAX_AMOUNTCURR15(2) WERTV8
FREIGHTShipment costs in document currency CRMT_FREIGHTCURR15(2) WERTV8
GROSS_VALUEGross Order Value in PO Currency CRMT_GROSS_VALUECURR15(2) WERTV8
NET_WO_FREIGHTItem Net Value Exclusive Shipment PRCT_NET_VALUE_WITHOUT_FREIGHTCURR15(2) WERTV8
SUBTOTAL1Subtotal 1 from pricing procedure for condition CRMT_SUBTOTAL1CURR15(2) WERTV8
SUBTOTAL2Subtotal 2 from pricing procedure for condition CRMT_SUBTOTAL2CURR15(2) WERTV8
SUBTOTAL3Subtotal 3 from pricing procedure for condition CRMT_SUBTOTAL3CURR15(2) WERTV8
SUBTOTAL4Subtotal 4 from pricing procedure for condition CRMT_SUBTOTAL4CURR15(2) WERTV8
SUBTOTAL5Subtotal 5 from pricing procedure for condition CRMT_SUBTOTAL5CURR15(2) WERTV8
SUBTOTAL6Subtotal 6 from pricing procedure for condition CRMT_SUBTOTAL6CURR15(2) WERTV8
CREDIT_INDICATORCredit Debit Indicator CRMT_CREDIT_INDICATORCHAR1CRMT_CREDIT_INDICATOR
NETPR_PRIC_UNITCondition Pricing Unit PRCT_COND_PRICING_UNITDEC5PRC_CONDITION_PRICING_UNIT
NETPR_UOMCondition Unit PRCT_COND_UOMUNIT3Assigned to domainCUNITMEINS
CURRENCYCurrency CRMT_CURRENCYCUKY5Assigned to domainWAERSFWS

Key field Non-key field



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

As CRMT_BSP_SLS_I_PRICING_IL 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_BSP_SLS_I_PRICING_IL as there is no data to select.

How to access SAP table CRMT_BSP_SLS_I_PRICING_IL

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