CRMS4_PSSP_H_SEARCH

Social Service Plan Header | view: CRMS4_PSSPHSRCH | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_PSSP_H, 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
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_APPROVAL Approval Status Show values
social_lifecycle_status Social Service Plan Header: Lifecycle Show values
STAT_ACTIVATION Activation Status Show values
reduction_STATUS Social Service Plan Header: Reduction Decision Show values
rerun_required_STATUS Social Service Plan Header: Status 'Rerun Required' Show values
Column Name Description Domain name
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_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
dec_type_txt Short Text for Fixed Values DDTEXT
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
lateapproval_h Latest 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
sold_to_party Main Partner BU_PARTNER
sold_to_party_firstname Search Help Field 2 (Name 2/First Name) CHAR35
sold_to_party_lastname Search Help Field 1 (Name 1/Last Name) CHAR35
SOLD_TO_PARTY_LIST null
person_resp Employee Responsible BU_PARTNER
PERSON_RESP_firstname Search Help Field 2 (Name 2/First Name) CHAR35
PERSON_RESP_lastname Search Help Field 1 (Name 1/Last Name) CHAR35
PERSON_RESP_LIST null
approved_by Approved By BU_PARTNER
APPROVED_BY_firstname Search Help Field 2 (Name 2/First Name) CHAR35
APPROVED_BY_lastname Search Help Field 1 (Name 1/Last Name) CHAR35
APPROVED_BY_LIST null
rejected_by Rejected By BU_PARTNER
REJECTED_BY_firstname Search Help Field 2 (Name 2/First Name) CHAR35
REJECTED_BY_lastname Search Help Field 1 (Name 1/Last Name) CHAR35
REJECTED_BY_LIST 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_APPROVAL_DESC Short Text for Fixed Values DDTEXT
stat_social_lifecycle_desc Short Text for Fixed Values DDTEXT
STAT_ACTIVATION_DESC Short Text for Fixed Values DDTEXT
stat_reduction_DESC Short Text for Fixed Values DDTEXT
stat_rerun_required_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_PSSP_H_SEARCH.INBOX_ACCOUNT == BUT000.PARTNER
  • CRMS4_PSSP_H_SEARCH.MANDT == BUT000.CLIENT
Employee Responsible
  • Employee Responsible
  • Client
  • CRMS4_PSSP_H_SEARCH.INBOX_ASSIGNED_TO == BUT000.PARTNER
  • CRMS4_PSSP_H_SEARCH.MANDT == BUT000.CLIENT
Customer Contact Person
  • Customer Contact Person
  • Client
  • CRMS4_PSSP_H_SEARCH.INBOX_CONTACT_PERSON == BUT000.PARTNER
  • CRMS4_PSSP_H_SEARCH.MANDT == BUT000.CLIENT
Responsible Group
  • Responsible Group
  • Client
  • CRMS4_PSSP_H_SEARCH.INBOX_GROUP_ASSIGNED == BUT000.PARTNER
  • CRMS4_PSSP_H_SEARCH.MANDT == BUT000.CLIENT
Business Trans. Cat. CRMS4_PSSP_H_SEARCH.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY