CRMS4V_PS_SDP

SDP Header | view: CRMS4VPSSDP | Extraction: Not supported | Component: S4CRM: Social Service Plan
Tables used: CRMS4D_PSDP_H, BUT000, CRMC_PROC_TYPE, CRMC_PROC_TYPE_T
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
CREATED_ON null
CHANGED_ON null
valid_from null
valid_to null
approval_date null
decision_date 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
lifecycle_status Life Cycle Status Show values
activation_status Activation Status Show values
approval_status Approval Status Show values
social_lifecycle_status Social Deduction Plan Header: Lifecycle 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
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
valid_from_tstmp Contract Start Date BCOS_TSTMP
valid_to_tstmp Contract End Date BCOS_TSTMP
approval_date_tstmp Approval Date BCOS_TSTMP
decision_date_tstmp Decision Date BCOS_TSTMP
business_process Business Transaction J_VORGANG
change_process Change Process CRMT_LEAS_CHNG_PROC
sub_change_process 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
po_number_sold Sold-To Party's External Reference Number TEXT35
PO_NUMBER_UC null
predecessor_guid GUID of a CRM Order Object SYSUUID
root_guid GUID of a CRM Order Object SYSUUID
lifecycle_status_desc Short Text for Fixed Values DDTEXT
activation_status_desc Short Text for Fixed Values DDTEXT
approval_status_desc Short Text for Fixed Values DDTEXT
social_lifecycle_status_desc Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Business Trans. Cat. CRMS4V_PS_SDP.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY