CRMS4_IU_I_CTI

Utilities Contract Item | view: CRMS4IUVICTI | 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
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
UtilsSalesContrItemStatus Contract Item Status Show values
Column Name Description Domain name
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
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
logical_contract_item Logical Identifier for Associated Contract Items CRMS4_IU_LOGICAL_CONTRACT_ITEM
DivisionName Division Description TEXT20
previous_item Shortened Item Number in Document CRMS4_IU_NUMBER_INT
pf_process Technical Name of Process CRMS4_IU_PFPROCESSNAME
ui_process Technical Name of UI Process CRMS4_IU_UIPROCESSNAME
order_date Posting Date BCOS_TSTMP
contstart Contract Start date DEC15
contend Contract End Date DEC15
first_contstart Earliest Contract Start Date DEC15
last_contend Latest Contract End Date DEC15
first_order_date First Purchase Date DEC15
iuct_i_dummy_ps Single-Character Flag CHAR1
StatusLifecyleText null
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
iuct_i_dummy_tr Single-Character Flag CHAR1
Master Data Relations Join Conditions
Contract Account Number
  • Client
  • Contract Account Number
  • CRMS4_IU_I_CTI.MANDT == FKKVK.MANDT
  • CRMS4_IU_I_CTI.CONTRACT_ACCOUNT == FKKVK.VKONT
Installation CRMS4_IU_I_CTI.INSTALLATION == EANL.MANDT
Contract
  • Client
  • Contract
  • CRMS4_IU_I_CTI.MANDT == EVER.MANDT
  • CRMS4_IU_I_CTI.ISU_CONTRACT == EVER.VERTRAG
Business Trans. Cat. CRMS4_IU_I_CTI.OBJTYPE_H == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Premise
  • Client
  • Premise
  • CRMS4_IU_I_CTI.MANDT == EVBS.MANDT
  • CRMS4_IU_I_CTI.PREMISE == EVBS.VSTELLE
Product Number
  • Client
  • Product Number
  • CRMS4_IU_I_CTI.MANDT == MARA.MANDT
  • CRMS4_IU_I_CTI.PRODUCT_ID == MARA.MATNR
Sold-To Party
  • Client
  • Sold-To Party
  • CRMS4_IU_I_CTI.MANDT == BUT000.CLIENT
  • CRMS4_IU_I_CTI.SOLD_TO_PARTY == BUT000.PARTNER
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Division
  • Client
  • CRMS4_IU_I_CTI.DIVISION == TESPT.SPARTE
  • CRMS4_IU_I_CTI.MANDT == TESPT.MANDT