CRMS4D_PSDP_H

Social Deduction Plan Header | #header | Component: S4CRM: Social Service Plan
Column Name Description
CLIENT FK Client
OBJTYPE_H 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
PO_DATE_SOLD Reference Document Date
PO_DATE_SHIP Ship-To Party's Reference Document Date
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
SDM_STATUS_DURA SDM status of duration migration 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
PROBABILITY Order Probability Show values
DATE_QTY_FIXED Fixed Date and Quantity Show values
STAT_LIFECYCLE Life Cycle Status Show values
STAT_RELEASED Release Status Show values
STAT_ACTIVATION_H Activation Status Show values
STAT_APPROVAL_H Approval Status Show values
STAT_SOCIAL_LIFE_CYCLE_H Social Deduction Plan Header: Lifecycle Show values
STAT_ARCHIVABLE Archivable Show values
STAT_ARCHIVED Archived Show values
STAT_OPEN Status "Open" Show values
Column Name Description Domain name
HEADER_GUID GUID of a CRM Order Object SYSUUID
PROCESS_TYPE Business Transaction Type CRM_PROCESS_TYPE
DESCRIPTION_H Transaction Description CRM_PROCESS_DESCRIPTION
DESCR_LANGUAGE Language Key of Description SPRAS
CREATED_AT_H Created At (Output in User Time Zone) COM_TSTMP
CREATED_BY_H 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
HEADER_GUID_CHAR 32 Character CRM Object GUID (Converted)
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
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
MAIN_PARTNER Main Partner BU_PARTNER
PERSON_RESP Employee Responsible BU_PARTNER
APPROVED_BY Approved By BU_PARTNER
REJECTED_BY Rejected By BU_PARTNER
PO_NUMBER_SOLD Sold-To Party's External Reference Number TEXT35
YOUR_REF_SOLD Sold-to Party Reference TEXT12
PO_NUMBER_SHIP Ship-To Party's External Reference Number TEXT35
YOUR_REF_SHIP Ship-To Party Reference TEXT12
SUBMISSION Collective Number for Quotations TEXT10
REQ_DLV_DATE_H Requested Delivery Date Header BCOS_TSTMP
REQ_TIMEZONE_H Time Zone Requested Delivery Date Header TZNZONE
RULE_REQ_DATE_H Rule Reqested Delivery Date Header TIMERULEID
PREDECESSOR_H GUID of a CRM Order Object SYSUUID
ROOT_GUID GUID of a CRM Order Object SYSUUID
INBOX_STATUS Status of Agent Inbox Item CRM_AUI_STATUS
PSDP_H_DUMMY_PS Single-Character Flag CHAR1
Master Data Relations Join Conditions
Client CRMS4D_PSDP_H.CLIENT == T000.MANDT
Customer Group 1
  • CRMS4D_PSDP_H.CLIENT == TVV1.MANDT
  • CRMS4D_PSDP_H.CUST_GROUP1 == TVV1.KVGR1
Customer Group 2
  • CRMS4D_PSDP_H.CLIENT == TVV2.MANDT
  • CRMS4D_PSDP_H.CUST_GROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • CRMS4D_PSDP_H.CUST_GROUP3 == TVV3.KVGR3
  • CRMS4D_PSDP_H.CLIENT == TVV3.MANDT
Customer Group 4
  • CRMS4D_PSDP_H.CLIENT == TVV4.MANDT
  • CRMS4D_PSDP_H.CUST_GROUP4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • CRMS4D_PSDP_H.CUST_GROUP5 == TVV5.KVGR5
  • CRMS4D_PSDP_H.CLIENT == TVV5.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • CRMS4D_PSDP_H.DIS_CHANNEL == TVTW.VTWEG
  • CRMS4D_PSDP_H.CLIENT == TVTW.MANDT
Division
  • CRMS4D_PSDP_H.CLIENT == TSPA.MANDT
  • CRMS4D_PSDP_H.DIVISION == TSPA.SPART
Sales Partners
  • Sales Partners
  • Client
  • CRMS4D_PSDP_H.INBOX_ACCOUNT == BUT000.PARTNER
  • CRMS4D_PSDP_H.CLIENT == BUT000.CLIENT
Employee Responsible
  • Employee Responsible
  • Client
  • CRMS4D_PSDP_H.INBOX_ASSIGNED_TO == BUT000.PARTNER
  • CRMS4D_PSDP_H.CLIENT == BUT000.CLIENT
Customer Contact Person
  • Customer Contact Person
  • Client
  • CRMS4D_PSDP_H.INBOX_CONTACT_PERSON == BUT000.PARTNER
  • CRMS4D_PSDP_H.CLIENT == BUT000.CLIENT
Responsible Group
  • Responsible Group
  • Client
  • CRMS4D_PSDP_H.INBOX_GROUP_ASSIGNED == BUT000.PARTNER
  • CRMS4D_PSDP_H.CLIENT == BUT000.CLIENT
Industry Sector
  • Industry Sector
  • Client
  • CRMS4D_PSDP_H.INDUSTRY == T016.BRSCH
  • CRMS4D_PSDP_H.CLIENT == T016.MANDT
Business Trans. Cat. CRMS4D_PSDP_H.OBJTYPE_H == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Region (State, Province, County)
  • ?
  • Region (State, Province, County)
  • CRMS4D_PSDP_H.CLIENT == T005S.MANDT
  • CRMS4D_PSDP_H.[column in domain "LAND1"] == T005S.LAND1
  • CRMS4D_PSDP_H.REGION == T005S.BLAND
Cancellation Reason Code
  • CRMS4D_PSDP_H.CLIENT == TVAG.MANDT
  • CRMS4D_PSDP_H.REJECTION == TVAG.ABGRU
Usage Indicator
  • Usage Indicator
  • Client
  • CRMS4D_PSDP_H.USAGE_TYPE == TVLV.ABRVW
  • CRMS4D_PSDP_H.CLIENT == TVLV.MANDT