CRMS4D_PSDP_H - Social Deduction Plan Header
Social Deduction Plan Header information is stored in SAP table CRMS4D_PSDP_H.
It is part of development package CRMS4_PS_1O_PERSISTENCY in software component CRM-S4-IPS-SSP. This development package consists of objects that can be grouped under "One Order Persistency Objects for Social Services".
It is part of development package CRMS4_PS_1O_PERSISTENCY in software component CRM-S4-IPS-SSP. This development package consists of objects that can be grouped under "One Order Persistency Objects for Social Services".
Fields for table CRMS4D_PSDP_H
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
.INCLUDE | X | CRMS4S_KEY_H | 0 | |||
CLIENT | Client | X | MANDT | CLNT | 6 | T000 |
OBJTYPE_H | Business Trans. Cat. | X | CRMT_SUBOBJECT_CATEGORY_DB | CHAR | 20 | CRMC_SUBOB_CAT |
OBJECT_ID | Transaction ID | X | CRMT_OBJECT_ID_DB | CHAR | 20 | |
.INCLUDE | CRMS4S_PSDP_H_ORDERADM_H | 0 | ||||
HEADER_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | ||
PROCESS_TYPE | Business Transaction Type | CRMT_PROCESS_TYPE_DB | CHAR | 8 | * | |
POSTING_DATE | Posting Date for a Business Transaction | CRMT_POSTING_DATE | DATS | 16 | ||
DESCRIPTION_H | Transaction Description | CRMT_PROCESS_DESCRIPTION | CHAR | 80 | ||
DESCR_LANGUAGE | Language Key of Description | CRMT_PROCESS_DESCRIPTION_LANGU | LANG | 2 | * | |
TEMPLATE_TYPE | Template Type of CRM Transaction | CRMT_TEMPLATE_TYPE_DB | CHAR | 2 | ||
CREATED_AT_H | Created At (Output in User Time Zone) | COMT_CREATED_AT_USR | DEC | 8 | ||
CREATED_BY_H | User that Created the Transaction | CRMT_CREATED_BY | CHAR | 24 | ||
CHANGED_AT_H | Changed At (Output in User Time Zone) | COMT_CHANGED_AT_USR | DEC | 8 | ||
CHANGED_BY_H | Transaction Last Changed By | CRMT_CHANGED_BY | CHAR | 24 | ||
HEAD_CHANGED_AT | Time of Last Change to the Transaction | CRMT_CHANGED_AT | DEC | 8 | ||
BTX_CLASS | CRM Business Transaction Classification | CRMT_TRANSACTION_CLASSIFICATN | CHAR | 2 | ||
AUTH_SCOPE | Authorization Scope | CRM_AUTH_SCOPE | NUMC | 12 | * | |
ARCHIVING_FLAG | Indicator Whether the Business Transaction Can Be Archived | CRMT_ARCHIVING_FLAG | CHAR | 2 | ||
OBJECT_ID_OK | Indicator That Transaction ID Is Correct | CRMT_OBJECT_ID_OK | CHAR | 2 | ||
VERIFY_DATE | Time Period of Last Archiving Attempt | CRMT_VERIFY_DATE | DEC | 8 | ||
PRICING_DOCUMENT | Number of the Document Condition | KNUMV | CHAR | 20 | ||
PRICING_PROCEDURE | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 12 | * | |
HEADER_GUID_CHAR | 32 Character CRM Object GUID (Converted) | CRMT_OBJECT_GUID32 | CHAR | 64 | ||
SDM_STATUS_DURA | SDM status of duration migration | CRMS4_SDM_STATUS_DURA | CHAR | 4 | ||
.INCLUDE | CRMS4S_PSDP_H_DATES | 0 | ||||
CONTSTART_H | Contract Start Date | CRMS4_PS_CONTSTART | DEC | 8 | ||
CONTEND_H | Contract End Date | CRMS4_PS_CONTEND | DEC | 8 | ||
APPROVEDATE_H | Approval Date | CRMS4_PS_APPROVEDATE | DEC | 8 | ||
DECISION_H | Decision Date | CRMS4_PS_DECISIONDATE | DEC | 8 | ||
.INCLUDE | CRMS4S_PSDP_H_CHNGPROC_H | 0 | ||||
BUSINESS_PROCESS | Business Transaction | J_VORGANG | CHAR | 8 | * | |
CHNG_PROCESS | Change Process | CRMT_LEAS_CHNG | CHAR | 8 | * | |
CHNG_PROCESS_SUB | Change of Lease: Sub-Change Process | CRMT_LEAS_CHNG_SUB1 | CHAR | 8 | * | |
.INCLUDE | CRMS4S_PSDP_C_ORGMAN | 0 | ||||
DIS_CHANNEL | Distribution Channel | CRMT_DISTRIBUTION_CHANNEL | CHAR | 4 | TVTW | |
DIVISION | Division | CRMT_DIVISION | CHAR | 4 | TSPA | |
SERVICE_ORG_ORI | Origin Indicator: Service Organization | CRMT_SERVICE_ORG_ORIGIN | CHAR | 2 | ||
SERVICE_ORGR_ORI | Origin Indicator: Service Scenario Organizational Unit | CRMT_SERVICE_ORG_RESP_ORIGIN | CHAR | 2 | ||
SALES_ORG_ORI | Origin Indicator: Sales Organization | CRMT_SALES_ORG_ORIGIN | CHAR | 2 | ||
DIS_CHANNEL_ORI | Origin Indicator: Distribution Channel | CRMT_DIS_CHANNEL_ORIGIN | CHAR | 2 | ||
SALES_OFF_ORI | Origin Indicator: Sales Office | CRMT_SALES_OFFICE_ORIGIN | CHAR | 2 | ||
SALES_GROUP_ORI | Origin Indicator: Sales Group | CRMT_SALES_GROUP_ORIGIN | CHAR | 2 | ||
SALES_ORGR_ORI | Origin Indicator: Sales Scenario Organizational Unit | CRMT_SALES_ORG_RESP_ORIGIN | CHAR | 2 | ||
DIVISION_ORI | Origin Flag: Division | CRMT_DIVISION_ORIGIN | CHAR | 2 | ||
SALES_ORG | Sales Organization ID | CRMT_SALES_ORG | CHAR | 28 | ||
SALES_OFFICE | Sales Office | CRMT_SALES_OFFICE | CHAR | 28 | ||
SALES_GROUP | Sales Group | CRMT_SALES_GROUP | CHAR | 28 | ||
SALES_ORG_RESP | Organizational Unit (Sales) | CRMT_SALES_ORG_RESP | CHAR | 28 | ||
SERVICE_ORG | Service Organization | CRMT_SERVICE_ORG | CHAR | 28 | ||
SERVICE_ORG_RESP | Organizational Unit (Service) | CRMT_SERVICE_ORG_RESP | CHAR | 28 | ||
.INCLUDE | CRMS4S_ORGMAN_SALES_SD | 0 | ||||
SALES_ORG_SD | Sales Organization | VKORG | CHAR | 8 | ||
SALES_OFFICE_SD | Sales office | VKBUR | CHAR | 8 | * | |
SALES_GROUP_SD | Sales group | VKGRP | CHAR | 6 | * | |
.INCLUDE | CRMS4S_PSDP_H_PARTNER | 0 | ||||
MAIN_PARTNER | Main Partner | CRMS4_PS_MAIN_PARTNER | CHAR | 20 | * | |
PERSON_RESP | Employee Responsible | CRMS4_PS_EMPLOYEE_RESP | CHAR | 20 | * | |
APPROVED_BY | Approved By | CRMS4_PS_APPROVED_BY | CHAR | 20 | * | |
REJECTED_BY | Rejected By | CRMS4_PS_REJECTED_BY | CHAR | 20 | * | |
.INCLUDE | CRMS4S_INBOX_PARTNER | 0 | ||||
INBOX_ASSIGNED_TO | Employee Responsible | CRMT_PERSON_RESP | CHAR | 20 | BUT000 | |
INBOX_GROUP_ASSIGNED | Responsible Group | CRMT_RESPONSIBLE_GROUP | CHAR | 20 | BUT000 | |
INBOX_ACCOUNT | Sales Partners | CRMT_SALESPARTNER | CHAR | 20 | BUT000 | |
INBOX_CONTACT_PERSON | Customer Contact Person | CRMT_CONTACT_PERSON | CHAR | 20 | BUT000 | |
.INCLUDE | CRMS4S_PSDP_H_SALES | 0 | ||||
.INCLUDE | CRMS4S_PSDP_C_SALES | 0 | ||||
REGION | Region (State, Province, County) | CRMT_REGION | CHAR | 6 | T005S | |
INDUSTRY | Industry Sector | CRMT_INDUSTRY | CHAR | 8 | T016 | |
CUST_GROUP1 | Customer Group 1 | CRMT_CUST_GROUP1 | CHAR | 6 | TVV1 | |
CUST_GROUP2 | Customer Group 2 | CRMT_CUST_GROUP2 | CHAR | 6 | TVV2 | |
CUST_GROUP3 | Customer Group 3 | CRMT_CUST_GROUP3 | CHAR | 6 | TVV3 | |
CUST_GROUP4 | Customer Group 4 | CRMT_CUST_GROUP4 | CHAR | 6 | TVV4 | |
CUST_GROUP5 | Customer Group 5 | CRMT_CUST_GROUP5 | CHAR | 6 | TVV5 | |
PO_NUMBER_SOLD | Sold-To Party's External Reference Number | CRMT_PO_NUMBER_SOLD | CHAR | 70 | ||
PO_DATE_SOLD | Reference Document Date | CRMT_PO_DATE_SOLD | DATS | 16 | ||
YOUR_REF_SOLD | Sold-to Party Reference | CRMT_YOUR_REFERENCE_SOLD | CHAR | 24 | ||
PO_NUMBER_SHIP | Ship-To Party's External Reference Number | CRMT_PO_NUMBER_SHIP | CHAR | 70 | ||
PO_DATE_SHIP | Ship-To Party's Reference Document Date | CRMT_PO_DATE_SHIP | DATS | 16 | ||
YOUR_REF_SHIP | Ship-To Party Reference | CRMT_YOUR_REFERENCE_SHIP | CHAR | 24 | ||
USAGE_TYPE | Usage Indicator | CRMT_USAGE | CHAR | 6 | TVLV | |
SUBMISSION | Collective Number for Quotations | CRMT_SUBMISSION | CHAR | 20 | ||
REJECTION | Cancellation Reason Code | CRMT_REJECTION_CODE | CHAR | 4 | TVAG | |
PROBABILITY | Order Probability | CRMT_ORDER_PROBABILITY | NUMC | 6 | ||
DATE_QTY_FIXED | Fixed Date and Quantity | CRMT_DATE_QTY_FIXED | CHAR | 2 | ||
REQ_DLV_DATE_H | Requested Delivery Date Header | CRMT_REQ_DLV_DATE | DEC | 8 | ||
REQ_TIMEZONE_H | Time Zone Requested Delivery Date Header | CRMT_REQ_DATE_TIMEZONE | CHAR | 12 | * | |
RULE_REQ_DATE_H | Rule Reqested Delivery Date Header | CRMT_RULE_REQ_DATE | RAW | 16 | * | |
.INCLUDE | CRMS4S_PSDP_H_DOC_FLOW | 0 | ||||
PREDECESSOR_H | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | ||
.INCLUDE | CRMS4S_PSDP_H_PS_SOCIAL_H | 0 | ||||
ROOT_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | ||
.INCLUDE | CRMS4S_PSDP_H_STATUS | 0 | ||||
STAT_LIFECYCLE | Life Cycle Status | CRMS4_STAT_LIFECYCLE | CHAR | 8 | ||
STAT_RELEASED | Release Status | CRMS4_STAT_RELEASED | CHAR | 2 | ||
STAT_ACTIVATION_H | Activation Status | CRMS4_PS_STAT_ACTIVATION | CHAR | 2 | ||
STAT_APPROVAL_H | Approval Status | CRMS4_PS_STAT_APPROVAL | CHAR | 4 | ||
STAT_SOCIAL_LIFE_CYCLE_H | Social Deduction Plan Header: Lifecycle | CRMS4_PS_PSDP_STAT_LIFECYCLE_H | CHAR | 4 | ||
STAT_ARCHIVABLE | Archivable | CRMS4_STAT_ARCHIVABLE | CHAR | 2 | ||
STAT_ARCHIVED | Archived | CRMS4_STAT_ARCHIVED | CHAR | 2 | ||
STAT_OPEN | Status "Open" | CRMS4_STAT_OPEN | CHAR | 2 | ||
INBOX_STATUS | Status of Agent Inbox Item | CRMT_AUI_STATUS | NUMC | 8 | ||
.INCLUDE | CRMS4S_PSDP_H_INCL_EEW_PS | 0 | ||||
PSDP_H_DUMMY_PS | Single-Character Flag | CHAR1 | CHAR | 2 |