CRMS4D_PSDP_H

Transparent Table Application Table
90 Fields 3 CDS Views

Social Deduction Plan Header

CRMS4D_PSDP_H is an SAP database table in S/4HANA. Social Deduction Plan Header. It contains 90 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CRMS4_PSDP_H_SEARCH view from Social Deduction Plan Header
CRMS4V_PS_SDP view from SSP Header
E_SocialDeductionPlan view from EXTENSION Social Deduction Plan Extension

Fields (90)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY objtype_h CRMT_SUBOBJECT_CATEGORY_DB Trans. Cat.
KEY object_id CRMT_OBJECT_ID_DB Transaction ID
header_guid CRMT_OBJECT_GUID Object GUID
process_type CRMT_PROCESS_TYPE_DB Transaction Type
posting_date CRMT_POSTING_DATE Posting Date
description_h CRMT_PROCESS_DESCRIPTION Description
descr_language CRMT_PROCESS_DESCRIPTION_LANGU Language
template_type CRMT_TEMPLATE_TYPE_DB Templ. Type
created_at_h COMT_CREATED_AT_USR Created At
created_by_h CRMT_CREATED_BY Created By
changed_at_h COMT_CHANGED_AT_USR Changed On
changed_by_h CRMT_CHANGED_BY Changed By
head_changed_at CRMT_CHANGED_AT Changed On
btx_class CRMT_TRANSACTION_CLASSIFICATN Trans.Classification
auth_scope CRM_AUTH_SCOPE Authorization Scope
archiving_flag CRMT_ARCHIVING_FLAG Can Be Archived
object_id_ok CRMT_OBJECT_ID_OK ID Valid
verify_date CRMT_VERIFY_DATE Verify Date
pricing_document KNUMV Doc. Condition
pricing_procedure KALSM_D Procedure
header_guid_char CRMT_OBJECT_GUID32 Object GUID
sdm_status_dura CRMS4_SDM_STATUS_DURA Duration Flag
contstart_h CRMS4_PS_CONTSTART Contract Start
contend_h CRMS4_PS_CONTEND Contract End
approvedate_h CRMS4_PS_APPROVEDATE Approval Date
decision_h CRMS4_PS_DECISIONDATE Decision Date
business_process J_VORGANG Bus.transaction
chng_process CRMT_LEAS_CHNG Change Process
chng_process_sub CRMT_LEAS_CHNG_SUB1 Sub-Chg. Proc.
dis_channel CRMT_DISTRIBUTION_CHANNEL Distribution Channel
division CRMT_DIVISION Division
service_org_ori CRMT_SERVICE_ORG_ORIGIN Origin srvc. org.
service_orgr_ori CRMT_SERVICE_ORG_RESP_ORIGIN Origin Sales Org.
sales_org_ori CRMT_SALES_ORG_ORIGIN Origin sales org.
dis_channel_ori CRMT_DIS_CHANNEL_ORIGIN Origin: Distr. chnl
sales_off_ori CRMT_SALES_OFFICE_ORIGIN Origin: Sales office
sales_group_ori CRMT_SALES_GROUP_ORIGIN Origin: Sales group
sales_orgr_ori CRMT_SALES_ORG_RESP_ORIGIN Origin SOrg
division_ori CRMT_DIVISION_ORIGIN Origin: Division
sales_org CRMT_SALES_ORG Sales Org. ID
sales_office CRMT_SALES_OFFICE Sales Office
sales_group CRMT_SALES_GROUP Sales Group
sales_org_resp CRMT_SALES_ORG_RESP Org. Unit (Sales)
service_org CRMT_SERVICE_ORG Service Organization
service_org_resp CRMT_SERVICE_ORG_RESP OU (Service)
sales_org_sd VKORG Sales Org.
sales_office_sd VKBUR Sales Office
sales_group_sd VKGRP Sales Group
main_partner CRMS4_PS_MAIN_PARTNER Main Partner
person_resp CRMS4_PS_EMPLOYEE_RESP Employee Responsible
approved_by CRMS4_PS_APPROVED_BY Approved By
rejected_by CRMS4_PS_REJECTED_BY Rejected By
inbox_assigned_to CRMT_PERSON_RESP Employee Resp.
inbox_group_assigned CRMT_RESPONSIBLE_GROUP Responsible Group
inbox_account CRMT_SALESPARTNER Sales Partners
inbox_contact_person CRMT_CONTACT_PERSON Contact Pers.
region CRMT_REGION Region
industry CRMT_INDUSTRY Industry Sector
cust_group1 CRMT_CUST_GROUP1 Customer Grp 1
cust_group2 CRMT_CUST_GROUP2 Customer Grp 2
cust_group3 CRMT_CUST_GROUP3 Customer Grp 3
cust_group4 CRMT_CUST_GROUP4 Customer Grp 4
cust_group5 CRMT_CUST_GROUP5 Customer Grp 5
po_number_sold CRMT_PO_NUMBER_SOLD Ext. Reference
po_date_sold CRMT_PO_DATE_SOLD Reference Date
your_ref_sold CRMT_YOUR_REFERENCE_SOLD Your Reference
po_number_ship CRMT_PO_NUMBER_SHIP Ext. Reference
po_date_ship CRMT_PO_DATE_SHIP Reference Doc SH
your_ref_ship CRMT_YOUR_REFERENCE_SHIP Your Reference
usage_type CRMT_USAGE Usage
submission CRMT_SUBMISSION Collective No.
rejection CRMT_REJECTION_CODE Cancel Rsn Code
probability CRMT_ORDER_PROBABILITY Probability %
date_qty_fixed CRMT_DATE_QTY_FIXED Fixed Date/Qty
req_dlv_date_h CRMT_REQ_DLV_DATE Rqstd Deliv. Date
req_timezone_h CRMT_REQ_DATE_TIMEZONE Time Zone
rule_req_date_h CRMT_RULE_REQ_DATE Rule ReqDelDate
predecessor_h CRMT_OBJECT_GUID Object GUID
root_guid CRMT_OBJECT_GUID Object GUID
stat_lifecycle CRMS4_STAT_LIFECYCLE Life Cycle Status
stat_released CRMS4_STAT_RELEASED Release Status
stat_activation_h CRMS4_PS_STAT_ACTIVATION Activation Status
stat_approval_h CRMS4_PS_STAT_APPROVAL Approval Status
stat_social_life_cycle_h CRMS4_PS_PSDP_STAT_LIFECYCLE_H Lifecycle
stat_archivable CRMS4_STAT_ARCHIVABLE Archivable
stat_archived CRMS4_STAT_ARCHIVED Archived
stat_open CRMS4_STAT_OPEN Open
inbox_status CRMT_AUI_STATUS Status
psdp_h_dummy_ps CHAR1 Single-Character Flag

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Social Deduction Plan Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_PSDP_H (
    CLIENT,                    -- Client [MANDT]
    OBJTYPE_H,                 -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
    OBJECT_ID,                 -- Transaction ID [CRMT_OBJECT_ID_DB]
    HEADER_GUID,               -- Object GUID [CRMT_OBJECT_GUID]
    PROCESS_TYPE,              -- Transaction Type [CRMT_PROCESS_TYPE_DB]
    POSTING_DATE,              -- Posting Date [CRMT_POSTING_DATE]
    DESCRIPTION_H,             -- Description [CRMT_PROCESS_DESCRIPTION]
    DESCR_LANGUAGE,            -- Language [CRMT_PROCESS_DESCRIPTION_LANGU]
    TEMPLATE_TYPE,             -- Templ. Type [CRMT_TEMPLATE_TYPE_DB]
    CREATED_AT_H,              -- Created At [COMT_CREATED_AT_USR]
    CREATED_BY_H,              -- Created By [CRMT_CREATED_BY]
    CHANGED_AT_H,              -- Changed On [COMT_CHANGED_AT_USR]
    CHANGED_BY_H,              -- Changed By [CRMT_CHANGED_BY]
    HEAD_CHANGED_AT,           -- Changed On [CRMT_CHANGED_AT]
    BTX_CLASS,                 -- Trans.Classification [CRMT_TRANSACTION_CLASSIFICATN]
    AUTH_SCOPE,                -- Authorization Scope [CRM_AUTH_SCOPE]
    ARCHIVING_FLAG,            -- Can Be Archived [CRMT_ARCHIVING_FLAG]
    OBJECT_ID_OK,              -- ID Valid [CRMT_OBJECT_ID_OK]
    VERIFY_DATE,               -- Verify Date [CRMT_VERIFY_DATE]
    PRICING_DOCUMENT,          -- Doc. Condition [KNUMV]
    PRICING_PROCEDURE,         -- Procedure [KALSM_D]
    HEADER_GUID_CHAR,          -- Object GUID [CRMT_OBJECT_GUID32]
    SDM_STATUS_DURA,           -- Duration Flag [CRMS4_SDM_STATUS_DURA]
    CONTSTART_H,               -- Contract Start [CRMS4_PS_CONTSTART]
    CONTEND_H,                 -- Contract End [CRMS4_PS_CONTEND]
    APPROVEDATE_H,             -- Approval Date [CRMS4_PS_APPROVEDATE]
    DECISION_H,                -- Decision Date [CRMS4_PS_DECISIONDATE]
    BUSINESS_PROCESS,          -- Bus.transaction [J_VORGANG]
    CHNG_PROCESS,              -- Change Process [CRMT_LEAS_CHNG]
    CHNG_PROCESS_SUB,          -- Sub-Chg. Proc. [CRMT_LEAS_CHNG_SUB1]
    DIS_CHANNEL,               -- Distribution Channel [CRMT_DISTRIBUTION_CHANNEL]
    DIVISION,                  -- Division [CRMT_DIVISION]
    SERVICE_ORG_ORI,           -- Origin srvc. org. [CRMT_SERVICE_ORG_ORIGIN]
    SERVICE_ORGR_ORI,          -- Origin Sales Org. [CRMT_SERVICE_ORG_RESP_ORIGIN]
    SALES_ORG_ORI,             -- Origin sales org. [CRMT_SALES_ORG_ORIGIN]
    DIS_CHANNEL_ORI,           -- Origin: Distr. chnl [CRMT_DIS_CHANNEL_ORIGIN]
    SALES_OFF_ORI,             -- Origin: Sales office [CRMT_SALES_OFFICE_ORIGIN]
    SALES_GROUP_ORI,           -- Origin: Sales group [CRMT_SALES_GROUP_ORIGIN]
    SALES_ORGR_ORI,            -- Origin SOrg [CRMT_SALES_ORG_RESP_ORIGIN]
    DIVISION_ORI,              -- Origin: Division [CRMT_DIVISION_ORIGIN]
    SALES_ORG,                 -- Sales Org. ID [CRMT_SALES_ORG]
    SALES_OFFICE,              -- Sales Office [CRMT_SALES_OFFICE]
    SALES_GROUP,               -- Sales Group [CRMT_SALES_GROUP]
    SALES_ORG_RESP,            -- Org. Unit (Sales) [CRMT_SALES_ORG_RESP]
    SERVICE_ORG,               -- Service Organization [CRMT_SERVICE_ORG]
    SERVICE_ORG_RESP,          -- OU (Service) [CRMT_SERVICE_ORG_RESP]
    SALES_ORG_SD,              -- Sales Org. [VKORG]
    SALES_OFFICE_SD,           -- Sales Office [VKBUR]
    SALES_GROUP_SD,            -- Sales Group [VKGRP]
    MAIN_PARTNER,              -- Main Partner [CRMS4_PS_MAIN_PARTNER]
    PERSON_RESP,               -- Employee Responsible [CRMS4_PS_EMPLOYEE_RESP]
    APPROVED_BY,               -- Approved By [CRMS4_PS_APPROVED_BY]
    REJECTED_BY,               -- Rejected By [CRMS4_PS_REJECTED_BY]
    INBOX_ASSIGNED_TO,         -- Employee Resp. [CRMT_PERSON_RESP]
    INBOX_GROUP_ASSIGNED,      -- Responsible Group [CRMT_RESPONSIBLE_GROUP]
    INBOX_ACCOUNT,             -- Sales Partners [CRMT_SALESPARTNER]
    INBOX_CONTACT_PERSON,      -- Contact Pers. [CRMT_CONTACT_PERSON]
    REGION,                    -- Region [CRMT_REGION]
    INDUSTRY,                  -- Industry Sector [CRMT_INDUSTRY]
    CUST_GROUP1,               -- Customer Grp 1 [CRMT_CUST_GROUP1]
    CUST_GROUP2,               -- Customer Grp 2 [CRMT_CUST_GROUP2]
    CUST_GROUP3,               -- Customer Grp 3 [CRMT_CUST_GROUP3]
    CUST_GROUP4,               -- Customer Grp 4 [CRMT_CUST_GROUP4]
    CUST_GROUP5,               -- Customer Grp 5 [CRMT_CUST_GROUP5]
    PO_NUMBER_SOLD,            -- Ext. Reference [CRMT_PO_NUMBER_SOLD]
    PO_DATE_SOLD,              -- Reference Date [CRMT_PO_DATE_SOLD]
    YOUR_REF_SOLD,             -- Your Reference [CRMT_YOUR_REFERENCE_SOLD]
    PO_NUMBER_SHIP,            -- Ext. Reference [CRMT_PO_NUMBER_SHIP]
    PO_DATE_SHIP,              -- Reference Doc SH [CRMT_PO_DATE_SHIP]
    YOUR_REF_SHIP,             -- Your Reference [CRMT_YOUR_REFERENCE_SHIP]
    USAGE_TYPE,                -- Usage [CRMT_USAGE]
    SUBMISSION,                -- Collective No. [CRMT_SUBMISSION]
    REJECTION,                 -- Cancel Rsn Code [CRMT_REJECTION_CODE]
    PROBABILITY,               -- Probability % [CRMT_ORDER_PROBABILITY]
    DATE_QTY_FIXED,            -- Fixed Date/Qty [CRMT_DATE_QTY_FIXED]
    REQ_DLV_DATE_H,            -- Rqstd Deliv. Date [CRMT_REQ_DLV_DATE]
    REQ_TIMEZONE_H,            -- Time Zone [CRMT_REQ_DATE_TIMEZONE]
    RULE_REQ_DATE_H,           -- Rule ReqDelDate [CRMT_RULE_REQ_DATE]
    PREDECESSOR_H,             -- Object GUID [CRMT_OBJECT_GUID]
    ROOT_GUID,                 -- Object GUID [CRMT_OBJECT_GUID]
    STAT_LIFECYCLE,            -- Life Cycle Status [CRMS4_STAT_LIFECYCLE]
    STAT_RELEASED,             -- Release Status [CRMS4_STAT_RELEASED]
    STAT_ACTIVATION_H,         -- Activation Status [CRMS4_PS_STAT_ACTIVATION]
    STAT_APPROVAL_H,           -- Approval Status [CRMS4_PS_STAT_APPROVAL]
    STAT_SOCIAL_LIFE_CYCLE_H,  -- Lifecycle [CRMS4_PS_PSDP_STAT_LIFECYCLE_H]
    STAT_ARCHIVABLE,           -- Archivable [CRMS4_STAT_ARCHIVABLE]
    STAT_ARCHIVED,             -- Archived [CRMS4_STAT_ARCHIVED]
    STAT_OPEN,                 -- Open [CRMS4_STAT_OPEN]
    INBOX_STATUS,              -- Status [CRMT_AUI_STATUS]
    PSDP_H_DUMMY_PS,           -- Single-Character Flag [CHAR1]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID)
);

Learn More