CRMS4_IU_C_CTHIP

Utilities Contract Header Item Period | view: CRMS4IUVCCTHIP | Extraction: Not supported | Component: S4CRM: Utilities Industry
Column Name Description
objtype_h FK Business Trans. Cat.
object_id Transaction ID
Column Name Description
Column Name Description
Column Name Description
posting_date Posting Date for a Business Transaction
contstart_min null
contend_max null
Column Name Description
archiving_flag Indicator Whether the Business Transaction Can Be Archived Show values
product_kind Product Technical 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
root_config Root Configuration Indicator Show values
exist_vckey Indicator Variant Key Available for Item Show values
Column Name Description Domain name
description_h Transaction Description CRM_PROCESS_DESCRIPTION
header_guid GUID of a CRM Order Object SYSUUID
logical_contract_item Logical Identifier for Associated Contract Items CRMS4_IU_LOGICAL_CONTRACT_ITEM
contstart Contract Start date DEC15
contend Contract End Date DEC15
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
order_date Posting Date BCOS_TSTMP
UtilsExternalPointOfDelivery Point of Delivery ID EXT_UI
int_obj_no Configuration (Internal Object Number) IB_INSTANCE
Master Data Relations Join Conditions
Contract Account Number
  • Contract Account Number
  • Client
  • CRMS4_IU_C_CTHIP.CONTRACT_ACCOUNT == FKKVK.VKONT
  • CRMS4_IU_C_CTHIP.MANDT == FKKVK.MANDT
Installation CRMS4_IU_C_CTHIP.INSTALLATION == EANL.MANDT
Contract
  • Contract
  • Client
  • CRMS4_IU_C_CTHIP.ISU_CONTRACT == EVER.VERTRAG
  • CRMS4_IU_C_CTHIP.MANDT == EVER.MANDT
Business Trans. Cat. CRMS4_IU_C_CTHIP.OBJTYPE_H == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Premise
  • Premise
  • Client
  • CRMS4_IU_C_CTHIP.PREMISE == EVBS.VSTELLE
  • CRMS4_IU_C_CTHIP.MANDT == EVBS.MANDT
Product Number
  • Product Number
  • Client
  • CRMS4_IU_C_CTHIP.PRODUCT_ID == MARA.MATNR
  • CRMS4_IU_C_CTHIP.MANDT == MARA.MANDT
Sold-To Party
  • Client
  • Sold-To Party
  • CRMS4_IU_C_CTHIP.MANDT == BUT000.CLIENT
  • CRMS4_IU_C_CTHIP.SOLD_TO_PARTY == BUT000.PARTNER
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • CRMS4_IU_C_CTHIP.MANDT == TESPT.MANDT
  • CRMS4_IU_C_CTHIP.DIVISION == TESPT.SPARTE