CRMT_BW_SRV_PRO_PLAN SAP (BW Extraction Structure for CRM Service Planning) Structure details

Dictionary Type: Structure
Description: BW Extraction Structure for CRM Service Planning




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




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

CRMT_BW_SRV_PRO_PLAN 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 "BW Extraction Structure for CRM Service Planning" 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_BW_SRV_PRO_PLAN TYPE CRMT_BW_SRV_PRO_PLAN.

The CRMT_BW_SRV_PRO_PLAN table consists of various fields, each holding specific information or linking keys about BW Extraction Structure for CRM Service Planning data available in SAP. These include CONFIRM_RELEVANT (Relevant for Confirmation), SERVICE_TYPE (Service Type), VALUATION_TYPE (Valuation Type), SRV_ESCAL (Response Profile).. 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 (character-type or numeric)


SAP CRMT_BW_SRV_PRO_PLAN 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
DISPO_FLGRelevant for Resource Planning CRMT_SRV_DISPO_FLGCHAR1FLAG
CONFIRM_RELEVANTRelevant for Confirmation CRMT_CONFIRM_RELEVANTCHAR1CRM_BOOLEAN
SERVICE_TYPEService Type CRMT_SERVICE_TYPECHAR4Assigned to domainCRMT_SERVICE_TYPE
VALUATION_TYPEValuation Type CRMT_VALUATION_TYPECHAR6Assigned to domainCRMT_VALUATION_TYPE
SRV_ESCALResponse Profile CRMT_SRV_ESCALCHAR10Assigned to domainCRM_SRV_ESCAL
SRV_SERWIService Profile CRMT_SRV_SERWICHAR10Assigned to domainCRM_SRV_SERWI
DURATIONDuration CRMT_SRV_DURATIONQUAN13(3) MENG13
DURATION_UNITUnit for Duration of Work CRMT_SRV_DURATION_UOMUNIT3Assigned to domainCUNITMEINS
PERSONSNumber of Persons CRMT_SRV_PERSONSNUMC3NUMC3
GUID_OBJECTGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
GUID_OBJ_OBJFAMObject Family COMT_PRODUCT_OBJECT_FAMILYCHAR4Assigned to domainCOM_PRODUCT_OBJECT_FAMILYCOM_OBJFAM_PRTYP
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
OBJECT_IDTransaction ID CRMT_OBJECT_IDCHAR10ALPHACRM_OBJECT_IDCRM_OBJECT_IDCRM_ORDER_OBJECT_ID
PROCESS_TYPEBusiness Transaction Type CRMT_PROCESS_TYPECHAR4Assigned to domainCRM_PROCESS_TYPECRM_PROCESS_TYPECRM_PROCESS_TYPE
POSTING_DATEPosting Date for a Business Transaction CRMT_POSTING_DATEDATS8
DESCRIPTION_UCTransaction Description (Upper Case) CRMT_PROCESS_DESCRIPTION_UCCHAR40CRM_PROCESS_DESCRIPTION_UC
DESCR_LANGUAGELanguage Key of Description CRMT_PROCESS_DESCRIPTION_LANGULANG1Assigned to domainISOLASPRAS
LOGICAL_SYSTEMLogical System CRMT_LOGSYSCHAR10Assigned to domainALPHALOGSYS
OBJECT_TYPEBusiness Transaction Category CRMT_SUBOBJECT_CATEGORYCHAR10Assigned to domainCRM_OJ_NAME_PROCESSCRM_SUBOBJ_CATEGORYCRM_OBJECT_TYPE_PROCESS
RECORDMODEBW Delta Process: Record Mode RODMUPDMODCHAR1RODMUPDMOD
NUM_OF_HEADOrder Header Number CRMT_NUMBER_OF_HINT410INT4
OCCURRENCECounter: Document Cat. Appears at Least Once in Document CRMT_OCC_AT_LEAST_ONCECHAR1CRM_BOOLEAN
ITEM_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
ORDER_DATEPosting Date CRMT_OPPT_ORDER_DATEDATS8DATUM
NUMBER_INTItem Number in Document CRMT_ITEM_NONUMC10CRM_ITEM_NO
NUMBER_PARENTHigher-Level Item Number in Document CRMT_ITEM_NO_PARENTNUMC10CRM_ITEM_NO
ITEM_OBJECT_TYPECRM Item Object Type CRMT_SWO_OBJTYP_PROCESS_ITEMCHAR10Assigned to domainCRM_OJ_NAME_PROCESS_ITEM
ITM_TYPEItem Category CRMT_ITEM_TYPECHAR4Assigned to domainCRM_ITEM_TYPECRM_ITEM_TYPE
NUMBER_OF_IOrder Item Number CRMT_NUMBER_OF_IINT410INT4
BW_ASSIGNAssign BW and CO CRMT_BW_ASSIGNCHAR1CRMT_BW_ASSIGN
ITM_USAGEUsage of Higher-Level Item CRMT_ITEM_USAGECHAR2CRM_ITEM_USAGE
SOLD_TO_PARTYSold-To Party CRMT_SOLD_TO_PARTCHAR10Assigned to domainALPHABU_PARTNER
SHIP_TO_PARTYShip-To Party CRMT_SHIP_TO_PARTCHAR10Assigned to domainALPHABU_PARTNER
BILL_TO_PARTYBill-To Party CRMT_BILL_TO_PARTCHAR10Assigned to domainALPHABU_PARTNER
PAYERPayer CRMT_RP_PAYERCHAR10Assigned to domainALPHABU_PARTNER
SALES_EMPLOYEEEmployee CRMT_SALES_EMPLOYEECHAR10Assigned to domainALPHABU_PARTNER
PERSON_RESPEmployee Responsible CRMT_PERSON_RESPCHAR10Assigned to domainALPHABU_PARTNER
CONTACT_PERSONCustomer Contact Person CRMT_CONTACT_PERSONCHAR10Assigned to domainALPHABU_PARTNER
SALESPARTNERSales Partners CRMT_SALESPARTNERCHAR10Assigned to domainALPHABU_PARTNER
EXECUTING_CCExecuting Interaction Center CRMT_EXECUTING_CCCHAR10Assigned to domainALPHABU_PARTNER
SALES_ORG_RESPOrganizational Unit (Sales) CRMT_SALES_ORG_RESPCHAR14HROBJEC_14
SALES_ORGSales Organization: Description of Department CRMT_SALES_ORG_SHORTCHAR12TEXT12
SALES_OFFICESales Office Abbreviation CRMT_SALES_OFFICE_SHORTCHAR12TEXT12
SALES_GROUPSales Group Abbreviation CRMT_SALES_GROUP_SHORTCHAR12TEXT12
DIS_CHANNELDistribution Channel CRMT_DISTRIBUTION_CHANNELCHAR2Assigned to domainCRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNEL
DIVISIONDivision CRMT_DIVISIONCHAR2Assigned to domainCRM_DIVISIONCRM_DIVISION
SERVICE_ORG_RESPOrganizational Unit (Service) CRMT_SERVICE_ORG_RESPCHAR14HROBJEC_14
SERVICE_ORGService Organization Identifier CRMT_SERVICE_ORG_SHORTCHAR12TEXT12
PRODUCT_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
PRODUCT_GUIDGUID for Product CHAR32 CRMT_PRODUCT_GUID_32CHAR32SYSUUID_C
MATERIALDistribution CRM -> R/3: Material CRMT_R3_MATERIALCHAR18CRM_R3_MATERIAL
CATEGORY_IDCategory ID COMT_CATEGORY_IDCHAR20COM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIER
CATEGORY_GUIDCategory GUID COMT_CATEGORY_GUIDRAW16SYSUUID
SHORT_TEXT_UCProduct Description COMT_PRSHTEXTX_UPCHAR40PRSHTEXTG40
CATALOG_IDCatalog ID from which the line was selected CRMT_CATALOGCHAR20CRM_CATALOGID
CATALOG_ITEM_IDCatalog Item (Unique Key) CRMT_CATALOGITEMCHAR40CRM_CATALOGITEM
PARTNER_PRODProduct Number of Business Partner CRMT_ITEM_DESCR_PARTNERCHAR40PRSHTEXT40
PROCESS_QTY_NUMNumerator (factor) for conversion trans. quantity in BME CRMT_PROCESS_QTY_NUMINT410CRM_PROCESS_QTY_NUM
PROCESS_QTY_DENDenominator (factor) for conversion trans. quantity in BME CRMT_PROCESS_QTY_DENINT410CRM_PROCESS_QTY_DEN
EXPONENT1010 Exponent for Quantity Conversion CRMT_EXPONENT10INT25CRM_EXPONENT10
PROCESS_QTY_UNITUnit of Measure in Which the Product Is Sold CRMT_PROCESS_QTY_UNITUNIT3Assigned to domainCUNITMEINS
PROD_PR_GROUPProduct Group CRMT_PROD_PR_GROUPCHAR2Assigned to domainCRM_PROD_PR_GROUP
BASE_QTY_UNITBase Unit of Measure of Product COMT_PRODUCT_BASE_UOMUNIT3Assigned to domainCUNITMEINS
EXCHG_TYPEExchange Rate Type CRMT_EXCHG_TYPECHAR4Assigned to domainKURST
EXCHG_DATEExchange Rate Date CRMT_EXCHG_DATEDATS8CRM_EXCHG_DATE
EXCHG_RATEExchange Rate CRMT_EXCHG_RATEDEC9(5) EXCRTCRM_EXCHG_RATE
CURRENCYCurrency CRMT_CURRENCYCUKY5Assigned to domainWAERSFWS
PRICE_DATEPricing Date CRMT_PRICE_DATEDATS8CRM_PRICE_DATE
REF_CURRENCYReference Currency CRMT_REF_CURRENCYCUKY5Assigned to domainWAERS
PMNTTRMSTerms of Payment CRMT_PMNTTRMSCHAR4Assigned to domainCRM_PMNTTRMS
CUST_GROUPCustomer Group CRMT_CUST_GROUPCHAR2Assigned to domainCRM_CUST_GROUP
NET_VALUE_MANTotal Expected Net Value Products in Document Currency CRMT_NET_VALUE_MANCURR15(2) WERTV8
TARGET_VALUETarget Value for Value Contract CRMT_TARGET_VALUECURR19(2) WERTV10
NET_PRICENet Price CRMT_NET_PRICECURR15(2) WERTV8
NET_VALUENet Value CRMT_NET_VALUECURR15(2) WERTV8
TAX_AMOUNTTax amount in document currency CRMT_TAX_AMOUNTCURR15(2) WERTV8
FREIGHTShipment costs in document currency CRMT_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
GROSS_VALUEGross Order Value in PO Currency CRMT_GROSS_VALUECURR15(2) WERTV8
BILLING_DATEBilling Date CRMT_BW_BILL_DATEDATS8CRM_RPRTNG_DATE
BILLING_BLOCKBusiness Partner (CRM): Billing Block Reason CRMT_BUS_BILL_BLOCK_REASONCHAR2Assigned to domainCRM_BILLING_BLOCK
CALDAYCalendar Day SMOCALDAYDATS8DATUM
PREDEC_OBJKEYGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
PREDEC_OBJTYPEObject Type of a Preceding Document CRMT_PRED_OBJECT_TYPECHAR10Assigned to domainOJ_NAME
LOGSYS_PREDLogical System CRMT_LOGSYSCHAR10Assigned to domainALPHALOGSYS
ORDER_QTYCRM: Order Quantity CRMT_QTY_ORDERQUAN13(3) MENG13
CONFIRMED_QTYCRM: Confirmed Quantity CRMT_QTY_CONFIRMEDQUAN13(3) MENG13
BWSTTECSYS0BW Status CRMBWSTNUMC2J_STONR
BWSTTECSYS1BW Status CRMBWSTNUMC2J_STONR
BWSTTECSYS2BW Status CRMBWSTNUMC2J_STONR
REQUESTED_DATEOrder Date CRMT_REQUESTED_DATEDATS8CRM_RPRTNG_DATE
CONFIRMED_DATELatest Confirmation Date for Item Schedule Line CRMT_CONFIRMED_DATEDATS8CRM_RPRTNG_DATE
GROSS_VALUE_HTotal Gross Value of Document in Document Currency CRMT_GROSS_VALUE_CUMCURR15(2) WERTV8
NET_VALUE_HTotal Net Value of Document in Document Currency CRMT_NET_VALUE_CUMCURR15(2) WERTV8
NET_VALUE_MAN_HExpected Total Net Value of Products in Document Currency CRMT_NET_VALUE_MAN_CUMCURR15(2) WERTV8
SERVICE_TEAMService Team CRMT_SERVICE_TEAMCHAR10Assigned to domainALPHABU_PARTNER
SERVICE_EMPLOYEEExecuting Service Employee CRMT_SERVICE_EMPLOYEECHAR10Assigned to domainALPHABU_PARTNER
CHA_SRV_RREADYData Element for Service-Date Characteristic SLA Date CHA_SRV_RREADYCHAR1CRMT_BW_SRV_CHA_DATES
CHA_SRV_CUST_ENDData Element for Service-Date Char. :Date Requested by Cust. CHA_SRV_CUST_ENDCHAR1CRMT_BW_SRV_CHA_DATES
SCHED_QUANTITYCRM Schedule Line Quantity CRMT_SCHEDLIN_QUANQUAN13(3) MENG13
IOBJECT_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
IOBJECT_GUIDInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16SYSUUID
CONFPROD_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
CONFPROD_GUIDInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16SYSUUID
PROD_OBJ_FAMObject Family COMT_PRODUCT_OBJECT_FAMILYCHAR4Assigned to domainCOM_PRODUCT_OBJECT_FAMILYCOM_OBJFAM_PRTYP
SIMULATED_ATSimulated On (Forecast) CRMT_SRVPLAN_SIMULATED_ATDATS8DATUM
PLANNED_DATEPlanned Date of Service Order (Simulation) CRMT_SRVPLAN_PLANNED_DATEDATS8DATUM
DATE_FROMStart Date for Simulation CRMT_SRVPLAN_DATE_FROMDATS8DATUM
DATE_TOEnd Date for Simulation CRMT_SRVPLAN_DATE_TODATS8DATUM
HEADER_FLGIdentifies Whether Order Header or Order Item CRMT_SRVPLAN_HEADER_FLGCHAR1FLAG
CYCLE_COUNTSNumber of Release Orders CRMT_SRVPLAN_COUNTERNUMC10COUNTING
TIMESTAMP_FROMTime Stamp (In UTC) BCOS_TSTMPDEC15TSTPSBCOS_TSTMP
SRV_CONTR_VALIDGeneral Flag FLAGCHAR1FLAG
PRED_PSL_OBJKEYGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
PRED_PSL_OBJKIDTransaction ID CRMT_OBJECT_IDCHAR10ALPHACRM_OBJECT_IDCRM_OBJECT_IDCRM_ORDER_OBJECT_ID
PRED_TMPL_OBJKEYGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
PRED_TMPL_OBJKIDTransaction ID CRMT_OBJECT_IDCHAR10ALPHACRM_OBJECT_IDCRM_OBJECT_IDCRM_ORDER_OBJECT_ID

Key field Non-key field



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

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

How to access SAP table CRMT_BW_SRV_PRO_PLAN

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