CRMS4_IU_C_CTP

Utilities Contract Period | view: CRMS4IUVCCTP | Extraction: Not supported | Component: S4CRM: Utilities Industry
Column Name Description
objtype_h FK Business Trans. Cat.
object_id FK Transaction ID
number_int Shortened Item Number in Document
Column Name Description
Column Name Description
Column Name Description
Column Name Description
itm_usage Usage of Higher-Level Item Show values
product_kind Product Technical Type Show values
revacc_relevant_type Revenue Accounting Type Show values
root_config Root Configuration Indicator Show values
exist_vckey Indicator Variant Key Available for Item Show values
stat_lifecycle Life Cycle Status Show values
stat_released Release Status Show values
stat_quotation Quotation Status Show values
stat_error Error Status Show values
stat_cancelled Cancellation Status Show values
stat_open Status "Open" Show values
stat_archivable Archivable Show values
stat_archived Archived Show values
Column Name Description Domain name
contstart Contract Start date DEC15
contend Contract End Date DEC15
item_guid GUID of a CRM Order Object SYSUUID
created_at_i Created At TZNTSTMPS
created_by_i User that Created the Transaction UNAME
changed_at_i Changed At TZNTSTMPS
changed_by_i Transaction Last Changed By UNAME
objtype_i CRM Item Object Type CRM_OJ_NAME_PROCESS_ITEM
header_guid GUID of a CRM Order Object SYSUUID
parent GUID of a CRM Order Object SYSUUID
alternative GUID of a CRM Order Object SYSUUID
product Internal Unique ID of Product SYSUUID
ordered_prod Product Name Entered CRM_ORDERED_PROD
partner_prod Product Number of Business Partner PRSHTEXT40
description_i Product Description CRM_PRSHTEXT40_DB
itm_language Short Text Language for an Item SYLANGU
number_ext External Item Number
itm_type Item Category CRM_ITEM_TYPE
order_date Posting Date BCOS_TSTMP
itm_type_usage Item Category Usage CRM_IT_TYPE_USAGE
revacc_refid Revenue Accounting Reference ID
revacc_reftype Revenue Accounting Reference Type
ProductName Material Description TEXT40
iucp_i_dummy_ps Single-Character Flag CHAR1
process_type Business Transaction Type CRM_PROCESS_TYPE
item_number Item Number of Contract Item CRMS4_IU_NUMBER_INT
pf_process Technical Name of Process CRMS4_IU_PFPROCESSNAME
ui_process Technical Name of UI Process CRMS4_IU_UIPROCESSNAME
int_obj_no Configuration (Internal Object Number) IB_INSTANCE
item_no_appt Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_partner Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_qualif Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_refobj Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_subject Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_survey Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_billplan Shortened Item Number in Document CRMS4_NUMBER_INT
iucp_i_dummy_tr Single-Character Flag CHAR1
Master Data Relations Join Conditions
Business Trans. Cat. CRMS4_IU_C_CTP.OBJTYPE_H == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Product Number
  • Client
  • Product Number
  • CRMS4_IU_C_CTP.MANDT == MARA.MANDT
  • CRMS4_IU_C_CTP.PRODUCT_ID == MARA.MATNR
Sold-To Party
  • Client
  • Sold-To Party
  • CRMS4_IU_C_CTP.MANDT == BUT000.CLIENT
  • CRMS4_IU_C_CTP.SOLD_TO_PARTY == BUT000.PARTNER