CRMS4_PSDP_H_SEARCH

Social Deduction Plan Header | view: CRMS4_PSDPHSRCH | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_PSDP_H, CRMC_PROC_TYPE, CRMC_PROC_TYPE_T, BUT000
Column Name Description
Column Name Description
Column Name Description
Column Name Description
posting_date Posting Date for a Business Transaction
valid_from null
valid_to null
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
private_flag Indicator: Task is Private Show values
STAT_LIFECYCLE Life Cycle Status Show values
stat_released Release Status Show values
stat_social_life_cycle_h Social Deduction Plan Header: Lifecycle Show values
STAT_APPROVAL Approval Status Show values
STAT_ACTIVATION Activation Status Show values
Column Name Description Domain name
object_id Transaction ID CRM_OBJECT_ID
guid GUID of a CRM Order Object SYSUUID
header_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_h Created At (Output in User Time Zone) COM_TSTMP
created_by User that Created the Transaction UNAME
changed_at_h Changed At (Output in User Time Zone) COM_TSTMP
changed_by_h 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
contstart_h Contract Start Date BCOS_TSTMP
contend_h Contract End Date BCOS_TSTMP
approvedate_h Approval Date BCOS_TSTMP
decision_h Decision Date BCOS_TSTMP
business_process Business Transaction J_VORGANG
chng_process Change Process CRMT_LEAS_CHNG_PROC
chng_process_sub Change of Lease: Sub-Change Process CRMT_LEAS_CHNG_PROC
person_resp Employee Responsible BU_PARTNER
sold_to_party Main Partner BU_PARTNER
approved_by Approved By BU_PARTNER
rejected_by Rejected By BU_PARTNER
person_resp_list null
sold_to_party_list null
approved_by_list null
rejected_by_list null
po_number_sold Sold-To Party's External Reference Number TEXT35
PO_NUMBER_SOLD_UC null
predecessor_h GUID of a CRM Order Object SYSUUID
root_guid GUID of a CRM Order Object SYSUUID
STAT_LIFECYCLE_DESC Short Text for Fixed Values DDTEXT
stat_lifecycle_sdp_desc Short Text for Fixed Values DDTEXT
STAT_APPROVAL_DESC Short Text for Fixed Values DDTEXT
STAT_ACTIVATION_DESC Short Text for Fixed Values DDTEXT
inbox_status Status of Agent Inbox Item CRM_AUI_STATUS
Master Data Relations Join Conditions
Sales Partners
  • Sales Partners
  • Client
  • CRMS4_PSDP_H_SEARCH.INBOX_ACCOUNT == BUT000.PARTNER
  • CRMS4_PSDP_H_SEARCH.MANDT == BUT000.CLIENT
Employee Responsible
  • Client
  • Employee Responsible
  • CRMS4_PSDP_H_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_PSDP_H_SEARCH.INBOX_ASSIGNED_TO == BUT000.PARTNER
Customer Contact Person
  • Client
  • Customer Contact Person
  • CRMS4_PSDP_H_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_PSDP_H_SEARCH.INBOX_CONTACT_PERSON == BUT000.PARTNER
Responsible Group
  • Client
  • Responsible Group
  • CRMS4_PSDP_H_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_PSDP_H_SEARCH.INBOX_GROUP_ASSIGNED == BUT000.PARTNER
Business Trans. Cat. CRMS4_PSDP_H_SEARCH.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY