CRMT_BW_UBB_CONTRACT_ITEM SAP (BW: DataSource for UBB) Structure details

Dictionary Type: Structure
Description: BW: DataSource for UBB




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




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

CRMT_BW_UBB_CONTRACT_ITEM 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: DataSource for UBB" 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_UBB_CONTRACT_ITEM TYPE CRMT_BW_UBB_CONTRACT_ITEM.

The CRMT_BW_UBB_CONTRACT_ITEM table consists of various fields, each holding specific information or linking keys about BW: DataSource for UBB data available in SAP. These include CLIENT (Client), GUID (GUID for a Transaction), OBJECT_ID (Transaction ID), PROCESS_TYPE (Business Transaction Type).. 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_BW_UBB_CONTRACT_ITEM 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 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_CATEGORYCHAR10CRMC_SUBOB_CATCRM_OJ_NAME_PROCESSCRM_SUBOBJ_CATEGORYCRM_OBJECT_TYPE_PROCESS
CREATED_ATTransaction Was Created at This Time CRMT_OPPT_CREATED_ATDATS8DATUM
CREATED_BYUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
CHANGED_ATTime of Last Change to the Transaction CRMT_OPPT_CHANGED_ATDATS8DATUM
CHANGED_BYTransaction Last Changed By CRMT_CHANGED_BYCHAR12UNAME
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
SCENARIOScenario Identity CRMT_SCENARIOCHAR10CRM_SCENARIO
TEMPLATE_TYPETemplate Type of CRM Transaction CRMT_TEMPLATE_TYPE_DBCHAR1CRM_TEMPLATE_TYPE
OCCURR_QUOTCounter: Document Cat. Appears at Least Once in Document CRMT_QUO_AT_LEAST_ONCECHAR1CRM_BOOLEAN
OCCURR_CONTCounter: Document Cat. Appears at Least Once in Document CRMT_CON_AT_LEAST_ONCECHAR1CRM_BOOLEAN
REF_UPDATEFlag: Ref. Update (Extract Structure Only Partially Filled) CRMT_FLG_REF_UPDATE_BWCHAR1XFELD
ITEM_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
ITEM_CREATED_ATTransaction Was Created at This Time CRMT_OPPT_CREATED_ATDATS8DATUM
ITEM_CREATED_BYUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
ITEM_CHANGED_ATTime of Last Change to the Transaction CRMT_OPPT_CHANGED_ATDATS8DATUM
ITEM_CHANGED_BYTransaction Last Changed By CRMT_CHANGED_BYCHAR12UNAME
ORDER_DATEPosting Date CRMT_OPPT_ORDER_DATEDATS8DATUM
NUMBER_INTItem Number in Document CRMT_ITEM_NONUMC10CRM_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
ITM_TYPE_USAGEItem Category Usage CRMT_IT_TYPE_USAGECHAR4Assigned to domainCRM_IT_TYPE_USAGE
ALTERNATIVEGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
PARENTGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
USAGEFCTGRPUsage Function Group CRMT_UBB_USAGEFCT_GRPCHAR3Assigned to domainCRM_UBB_USAGEFCT_GRP
SEQUENCEMessage Sequence for Reading Reminder CRMT_UBB_SEQUENCECHAR4Assigned to domainCRM_UBB_SEQUENCE
READING_DTM_PROCValidation Rule for Volume Documents CRMT_UBB_VOL_I_VALID_RULECHAR2Assigned to domainCRM_UBB_VOL_I_VALID_RULE
ESTIMAT_SEQUENCEEstimation Sequence CRMT_UBB_ESTIMATION_SEQUENCECHAR4CRM_UBB_ESTIMATION_SEQUENCE
CONTRACT_CLASSContract Class CRMT_CONTRACT_CLASSNUMC2CRMT_CONTRACT_CLASS
PRED_HEADER_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
PRED_ITEM_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
INVOICE_SPLITInvoice Split CRMT_UBB_INVOICE_SPLITCHAR1Assigned to domainCRMT_UBB_INVOICE_SPLIT
UBB_STG_I_GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
BP_SUBTYPEBilling Plan Subtype CRMT_BP_SUBTYPECHAR1Assigned to domainCRMT_BP_SUBTYPE
XLEADINGDominant Service Type CRMT_XLEADING_SERVICE_TYPECHAR1XFELD
UBB_HDPER_I_GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
HDPER_CREATED_ATTransaction was Created at this Time CRMT_CREATED_ATDEC15TSTPSBCOS_TSTMP
HDPER_CREATED_BYUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
HDPER_CHANGED_ATTime of Last Change to the Transaction CRMT_CHANGED_ATDEC15TSTPSBCOS_TSTMP
HDPER_CHANGED_BYTransaction Last Changed By CRMT_CHANGED_BYCHAR12UNAME
HOLI_PERIOD_FROMStart of Billing Holiday Period (Database Field) CRMT_UBB_HOLIPER_FROMDEC15TSTPSBCOS_TSTMP
HOLI_PERIOD_TOEnd of Billing Holiday Period (Database Field) CRMT_UBB_HOLIPER_TODEC15TSTPSBCOS_TSTMP
HOLI_PERIOD_TEXTDescription CRMT_UBB_HOLIPER_TEXTCHAR40TEXT40
BILLPLAN_D_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
BILLPLAN_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
BILLING_TIMEZONETime Zone of Billing Plan Set CRMT_BILLING_TIMEZONECHAR6Assigned to domainTZNZONE
START_DATEStart Date of Billing Plan CRMT_START_DATEDEC15TSTPSBCOS_TSTMP
END_DATEEnd Date of Billing Plan CRMT_END_DATEDEC15TSTPSBCOS_TSTMP
DATE_FROMDates From CRMT_DATE_FROMDEC15TSTPSBCOS_TSTMP
DATE_TODates To CRMT_DATE_TODEC15TSTPSBCOS_TSTMP
ADD_BP_USAGEBilling Plan Usage CRMT_BP_USAGECHAR1CRMT_BP_USAGE
CASHFLOW_TYPEFlow Category CRMT_CASHFLOW_TYPECHAR4CRMT_CASHFLOW_TYPE
RULE_PER_DATE_TRule for Determining the Period Date CRMT_RULE_PERIOD_DATE_TCHAR12TIMENAME
KIND_HORIZONDate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
KIND_START_DATEDate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
KIND_END_DATEDate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
KIND_DATE_FROMDate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
KIND_DATE_TODate type TIMENAEVENCHAR12Assigned to domainSC_APPTTYPTIMENAEV
CR_I_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
VALID_FROMValid from CRMT_UBB_VALID_FROMDEC15TSTLCCRM_TSTMP
VALID_TOValid To CRMT_UBB_VALID_TODEC15TSTLCCRM_TSTMP
QUANTITYCredit Quantity CRMT_UBB_CRED_QUANTITYQUAN15(3) CRM_MENGV15
CURRENT_QUANTITYCurrent Credit Quantity CRMT_UBB_CRED_CURR_QUANTITYQUAN15(3) CRM_MENGV15
UNITCredit Unit CRMT_UBB_CRED_UNITUNIT3Assigned to domainCUNITMEINSH_T006_USAGE
USAGEFCTCATUsage Function Category CRMT_UBB_USAGEFCT_CATCHAR4CRM_UBB_USAGEFCT_CAT
USAGEFCTUsage Function CRMT_UBB_USAGEFCTCHAR4Assigned to domainCRM_UBB_USAGEFCT
COMMENTSComment CRMT_UBB_COMMENT_60CHAR60CRM_UBB_COMMENT_60
SOURCECredit Source CRMT_UBB_CRED_SOURCECHAR1CRM_UBB_CRED_SOURCE
PRODUCTProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
IBASE_NOIBase: Number of the Installed Base/IBase IB_IBASENUMC18ALPHAIB_INSTANCEIIBIBIBM
CREDIT_STATUSCredit Status CRMT_UBB_CREDIT_STATUSCHAR1CRM_UBB_CREDIT_STATUS
CREDIT_ITEM_NOCredit Item Number CRMT_UBB_CREDIT_ITEM_NONUMC5NUMC5
CR_TYPEType of Credit CRMT_UBB_CR_TYPECHAR1Assigned to domainCRM_UBB_CR_TYPE
READING_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
READING_IDReading Number CRMT_MPK_OBJECT_ID_READINGCHAR20ALPHACRM_MPK_OBJECT_ID_READINGCRM_MPK_RD_IDCRMH_MPK_READING
VALUECredit Value CRMT_UBB_CRED_VALUECURR19(2) PRC_COND_VALUE
CURRENT_VALUECurrent Credit Value CRMT_UBB_CRED_VALUE_CURRENTCURR19(2) PRC_COND_VALUE
CURRENCYCredit Currency CRMT_UBB_CRED_CURRCUKY5Assigned to domainWAERS
SRC_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
REF_CREDIT_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
CR_I_C_GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
CHANGE_QUANTITYChange Credit Quantity CRMT_UBB_CRED_CHANGE_QUANTITYQUAN15(3) CRM_MENGV15
CHANGE_VALUEChanged Credit Value CRMT_UBB_CRED_CHANGED_VALUECURR19(2) PRC_COND_VALUE
CR_I_C_UNITCredit Unit CRMT_UBB_CRED_UNITUNIT3Assigned to domainCUNITMEINSH_T006_USAGE
CR_I_C_CURRENCYCredit Currency CRMT_UBB_CRED_CURRCUKY5Assigned to domainWAERS
REF_BRIGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
CONSUMP_STATUSUsage Status CRMT_UBB_CONSUMPTION_STATUSCHAR1CRMT_UBB_CONSUMPTION_STATUS
VOL_I_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
SETTL_FROMStart of Settlement for Period CRMT_SETTL_FROMDEC15TSTPSBCOS_TSTMP
SETTL_TOEnd of Settlement for Period CRMT_SETTL_TODEC15TSTPSBCOS_TSTMP
VOL_BILLING_TMZNTime Zone of Billing Plan Set CRMT_BILLING_TIMEZONECHAR6Assigned to domainTZNZONE
VOL_USAGEFCTUsage Function CRMT_UBB_USAGEFCTCHAR4Assigned to domainCRM_UBB_USAGEFCT
MEAS_POINT_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
MEAS_POINT_IDCounter Identifier CRMT_MPK_OBJECT_ID_MPOINTCHAR20ALPHACRM_MPK_OBJECT_ID_MPOINTCRM_MPK_MP_IDCRMH_MPK_MPOINT
VOL_READING_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
READING_DATEDate for Ending Value CRMT_UBB_VOL_I_END_TIMESTAMPDEC15TSTPSBCOS_TSTMP
READING_TMZNTime Zone of Ending Value CRMT_UBB_VOL_I_END_TIMEZONECHAR6Assigned to domainTZNZONE
READING_VALValue at End of Interval CRMT_UBB_VOL_I_END_VALUECHAR22CRM_MPK_FLTP_UI
READING_ORIGOrigin of Ending Value CRMT_UBB_VOL_I_END_ORIGINCHAR1CRM_UBB_READING_ORIGIN
PRI_READING_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
PRI_READING_IDNumber of Previous Reading CRMT_UBB_VOL_ID_READING_PRICHAR20ALPHACRM_MPK_OBJECT_ID_READING
PRI_READING_DATEDate for Initial Value CRMT_UBB_VOL_I_START_TIMESTAMPDEC15TSTPSBCOS_TSTMP
PRI_READING_TMZNTime Zone of Starting Value CRMT_UBB_VOL_I_START_TIMEZONECHAR6Assigned to domainTZNZONE
PRI_READING_VALValue at Start of Interval CRMT_UBB_VOL_I_START_VALUECHAR22CRM_MPK_FLTP_UI
PRI_READING_ORIGOrigin of Starting Value CRMT_UBB_VOL_I_START_ORIGINCHAR1CRM_UBB_READING_ORIGIN
VOL_UNITUnit of Measurement for Volumes CRMT_UBB_VOL_I_UNITUNIT3Assigned to domainCUNITMEINSH_T006_USAGE
VOL_QUANTITYCRM Quantity for Cumulated I CRMT_CUM_QUANQUAN15(3) CRM_MENGV15
STATUS_PROCESSStatus of Usage Volume Document CRMT_UBB_VOL_I_STATUS_PROCESSCHAR1CRMT_UBB_VOL_I_STATUS_PROCESS
STATUS_POOLPrebilling Status of Pool Contracts CRMT_UBB_VOL_I_STATUS_POOLCHAR1CRM_BOOLEAN
RELEASE_FUT_READLogical Variable CRMT_BOOLEANCHAR1CRM_BOOLEAN
DUMMY_INTERNALSingle-Character Indicator CHAR1CHAR1CHAR1

Key field Non-key field



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

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

How to access SAP table CRMT_BW_UBB_CONTRACT_ITEM

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