CRMS4_DMEA_H_SEARCH

Enforcement Action Header Search | view: CRMS4_DMEAHSRCH | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_DMEA_H, CRMS4C_STAT_LC_T, CRMC_PROC_TYPE, CRMC_PROC_TYPE_T, BUT000
Column Name Description
object_type 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
by_dun_laufd Date ID
Column Name Description
template_type Template Type of CRM Transaction Show values
archiving_flag Indicator Whether the Business Transaction Can Be Archived Show values
object_id_ok Indicator That Transaction ID Is Correct Show values
stat_lifecycle Life Cycle Status Show values
stat_open Status "Open" Show values
stat_archivable Archivable Show values
stat_archived Archived Show values
stat_error Error Status Show values
stat_cancelled Cancellation Status Show values
by_dunning Enforcement Action Created by Dunning Show values
service_org_ori Origin Indicator: Service Organization Show values
service_orgr_ori Origin Indicator: Service Scenario Organizational Unit Show values
sales_org_ori Origin Indicator: Sales Organization Show values
dis_channel_ori Origin Indicator: Distribution Channel Show values
sales_off_ori Origin Indicator: Sales Office Show values
sales_group_ori Origin Indicator: Sales Group Show values
sales_orgr_ori Origin Indicator: Sales Scenario Organizational Unit Show values
division_ori Origin Flag: Division Show values
service_team_rm_ori Origin Indicator: Service Team Show values
Column Name Description Domain name
guid GUID of a CRM Order Object SYSUUID
process_type Business Transaction Type CRM_PROCESS_TYPE
process_type_txt Description (20 Characters) TEXT20
description Transaction Description CRM_PROCESS_DESCRIPTION
DESCRIPTION_UC null
descr_language Language Key of Description SPRAS
created_at Created At (Output in User Time Zone) COM_TSTMP
created_by User that Created the Transaction UNAME
changed_at Changed At (Output in User Time Zone) COM_TSTMP
changed_by Transaction Last Changed By UNAME
head_changed_at Time of Last Change to the Transaction BCOS_TSTMP
btx_class CRM Business Transaction Classification CRM_TRANSACTION_CLASSIFICATION
auth_scope Authorization Scope CRM_AUTH_SCOPE
verify_date Time Period of Last Archiving Attempt BCOS_TSTMP
pricing_document Number of the Document Condition KNUMV
pricing_procedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
header_guid_char 32 Character CRM Object GUID (Converted)
person_resp Employee Responsible BU_PARTNER
PERSON_RESP_LIST null
sold_to_party Debtor BU_PARTNER
SOLD_TO_PARTY_LIST null
dmea_start_h Enforcement Action Start Date BCOS_TSTMP
dmea_end_h Enforcement Action End Date BCOS_TSTMP
stat_lifecycle_desc Short Text for Fixed Values DDTEXT
stat_open_desc Short Text for Fixed Values DDTEXT
stat_archivable_desc Short Text for Fixed Values DDTEXT
stat_archived_desc Short Text for Fixed Values DDTEXT
stat_error_desc Short Text for Fixed Values DDTEXT
stat_cancelled_desc Short Text for Fixed Values DDTEXT
by_dun_laufi Additional Identification Characteristic LAUFI_CA
sales_org Sales Organization ID HROBJEC_14
sales_office Sales Office HROBJEC_14
sales_group Sales Group HROBJEC_14
sales_org_resp Organizational Unit (Sales) HROBJEC_14
service_org Service Organization HROBJEC_14
service_org_resp Organizational Unit (Service) HROBJEC_14
sales_org_sd Sales Organization VKORG
sales_office_sd Sales office VKBUR
sales_group_sd Sales group VKGRP
service_team_rm Service Team (Responsibility Management) HROBJID
Master Data Relations Join Conditions
Distribution Channel
  • Distribution Channel
  • Client
  • CRMS4_DMEA_H_SEARCH.DIS_CHANNEL == TVTW.VTWEG
  • CRMS4_DMEA_H_SEARCH.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • CRMS4_DMEA_H_SEARCH.DIVISION == TSPA.SPART
  • CRMS4_DMEA_H_SEARCH.MANDT == TSPA.MANDT
Business Trans. Cat. CRMS4_DMEA_H_SEARCH.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY