PSSCD_SXP SAP (SXP Header Data) Table details
Dictionary Type: Table
Description: SXP Header Data
Description: SXP Header Data
Table field list including key, data, relationships and ABAP select examples
PSSCD_SXP is a standard SAP Table which is used to store SXP Header Data data and is available within R/3 SAP systems depending on the version and release level.
The PSSCD_SXP table consists of various fields, each holding specific information or linking keys about SXP Header Data data available in SAP. These include VERSIONID (Social Services Object Version), OBJECTID (Social Service Business Object Identifier), BEGDA (Social Services Begin Date), ENDDA (Social Services End Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP PSSCD_SXP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
VERSIONID | Social Services Object Version | PSSCSXPOBJECTVERSIONID | RAW | 16 | SYSUUID | ||||
OBJECTID | Social Service Business Object Identifier | PSSCOBJECTID | CHAR | 32 | SYSUUID_C32 | ||||
BEGDA | Social Services Begin Date | PSSCBEGDA | DATS | 8 | DATUM | ||||
ENDDA | Social Services End Date | PSSCENDDA | DATS | 8 | DATUM | ||||
REF_GUID | Social Services Reference to Previous SXP Version ID | PSSC_SXP_REF_PREV_VERSION | RAW | 16 | SYSUUID | ||||
EXTERNAL_ID | Transaction Number | CRMT_OBJECT_ID_DB | CHAR | 10 | ALPHA | CRM_OBJECT_ID | |||
PROCESS_TYPE | Business Transaction Type | PSSC_PROCESS_TYPE | CHAR | 4 | PSSC_PROCESS_TYPE | ||||
DESCRIPTION | Transaction Description | CRMT_PROCESS_DESCRIPTION | CHAR | 40 | CRM_PROCESS_DESCRIPTION | ||||
DESCR_LANGUAGE | Language Key of Description | CRMT_PROCESS_DESCRIPTION_LANGU | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
LOGICAL_SYSTEM | Logical System | CRMT_LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
CRM_RELEASE | SAP Release | SAPRELEASE | CHAR | 10 | CHAR10 | ||||
CREATED_AT | Created At (Output in User Time Zone) | COMT_CREATED_AT_USR | DEC | 15 | TSTLC | COM_TSTMP | |||
CREATED_BY | User that Created the Transaction | CRMT_CREATED_BY | CHAR | 12 | UNAME | USER_ADDR | |||
CHANGED_AT | Changed At (Output in User Time Zone) | COMT_CHANGED_AT_USR | DEC | 15 | TSTLC | COM_TSTMP | |||
CHANGED_BY | Transaction Last Changed By | CRMT_CHANGED_BY | CHAR | 12 | UNAME | ||||
HEAD_CHANGED_AT | Time of Last Change to the Transaction | CRMT_CHANGED_AT | DEC | 15 | TSTPS | BCOS_TSTMP | |||
OBJECT_TYPE | Business Trans. Cat. | PSSC_OBJECT_TYPE | CHAR | 10 | PSSC_OBJECT_TYPE | ||||
CRM_CHANGED_AT | Time of Last Change in CRM Online | CRMT_ONLINE_CHANGED_AT | DEC | 15 | TSTPS | BCOS_TSTMP | |||
ARCHIVING_FLAG | Indicator Whether the Business Transaction Can Be Archived | CRMT_ARCHIVING_FLAG | CHAR | 1 | CRM_BOOLEAN | ||||
SAVED_AT | Timestamp when SXP was Saved Last (in CRM) | PSSC_CRM_SXP_SAVED_AT | DEC | 21(7) | TSTPS | PSSC_TZNTSTMPL | |||
BUSINESS_PROCESS | Business Transaction | J_VORGANG | CHAR | 4 | Assigned to domain | J_VORGANG | |||
CHNG_PROCESS | Change Process | PSSC_CRM_CHNG_PROCESS | CHAR | 4 | |||||
ORDERADM_H_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
BTX_CLASS | Decision Category of SSP | PSSC_DECISION_CATEGORY | CHAR | 1 | PSSC_DECISION_CATEGORY | ||||
ACTIVATED | Status Active | PSSCACTIVE | CHAR | 1 | PSSCBOOLEAN | ||||
GED_EXECUTED | GED is executed | PSSCGED_EXECUTED | CHAR | 1 | PSSCBOOLEAN | ||||
GPD_EXECUTED | GED is executed | PSSCGPD_EXECUTED | CHAR | 1 | PSSCBOOLEAN | ||||
GLAS_SET | Decision Assessment Set | PSSCGLAS_SET | CHAR | 1 | PSSCBOOLEAN | ||||
UI_PROCESS | UI Process | PSSCUI_PROCESS | CHAR | 1 | PSSCBOOLEAN | ||||
CONFIRMATION | Technical Status | PSSC_STATUS_TECH | CHAR | 10 | PSSC_STATUS | ||||
EC_RERUN_REQ | Manual Triggering of Entitlement Calculation Required | PSSC_EC_RERUN | CHAR | 1 | PSSCBOOLEAN | ||||
BENEFIT_PROG | Benefit Program | PSSC_BENEFIT_PROG | CHAR | 4 | Assigned to domain | PSSC_BENEFIT_PROG | |||
MAIN_PARTNER | Benefit Beneficiary Number | PSSC_BENE_BENEFI_NO | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
MR_DATE_ID | Date ID | LAUFD_KK | DATS | 8 | DATUM | ||||
MR_IDENT | Additional Identification Characteristic | LAUFI_KK | CHAR | 6 | LAUFI_KK | ||||
MR_FAILED | Mass Run Failed | PSSC_FAILED | CHAR | 1 | PSSCBOOLEAN |
Key field | Non-key field |
How do I retrieve data from SAP table PSSCD_SXP using ABAP code
The following ABAP code Example will allow you to do a basic selection on PSSCD_SXP to SELECT all data from the tableDATA: WA_PSSCD_SXP TYPE PSSCD_SXP.
SELECT SINGLE *
FROM PSSCD_SXP
INTO CORRESPONDING FIELDS OF WA_PSSCD_SXP
WHERE...
How to access SAP table PSSCD_SXP
Within an ECC or HANA version of SAP you can also view further information about PSSCD_SXP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects