PSSCD_SXPITEM SAP (SXP Item Data) Table details

Dictionary Type: Table
Description: SXP Item Data




ABAP Code to SELECT data from PSSCD_SXPITEM
Related tables to PSSCD_SXPITEM
Access table PSSCD_SXPITEM




Table field list including key, data, relationships and ABAP select examples

PSSCD_SXPITEM is a standard SAP Table which is used to store SXP Item Data data and is available within R/3 SAP systems depending on the version and release level.

The PSSCD_SXPITEM table consists of various fields, each holding specific information or linking keys about SXP Item Data data available in SAP. These include VERSIONID (Social Services Object Version), ITEMID (Social Services Business Object Item ID), 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_SXPITEM 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
VERSIONIDSocial Services Object Version PSSCSXPOBJECTVERSIONIDRAW16PSSCD_SXPSYSUUID
ITEMIDSocial Services Business Object Item ID PSSCSXPITEMIDRAW16SYSUUID
BEGDASocial Services Begin Date PSSCBEGDADATS8DATUM
ENDDASocial Services End Date PSSCENDDADATS8DATUM
AMOUNTAmount PSSC_AMOUNTCURR13(2) WRTV7
CURRENCYItem Currency PSSC_CURRENCYCUKY5TCURCWAERS
REF_GUIDSocial Services Reference to Previous SXP Item ID PSSC_SXPITEM_REF_PREV_VERSRAW16SYSUUID
ALT_PAYEE_GUIDAlternative Payee GUID PSSC_ALTERNATIVE_PAYEE_GUIDRAW16SYSUUID
ALT_PAYEE_NOAlternative Payee Number PSSC_ALTERNATIVE_PAYEE_NOCHAR10BUT000ALPHABU_PARTNER
ALT_PAY_METHODPayment Method for Outgoing Payments PSSC_PAYM_METHOD_OUTCHAR1TFK042ZPYMET_KK
ALT_PAY_ADDR_IDAlternate Payment Address ID PSSC_ALT_PAYM_ADDRESS_IDCHAR10ADRCALPHAAD_ADDRNUM
ALT_PAY_ADDRGUIDAlternate Payment Address as GUID PSSC_ALT_PAYM_ADDRESS_GUIDRAW16SYSUUID
ALT_PAY_BANK_IDAlternate Payment Bank ID PSSC_ALT_PAYM_BANK_IDCHAR4CHAR4
DEDUCT_PERCENTDeduction Percentage PSSC_PERCENTAGEDEC7(4) PSSC_PERCENTAGE
DEDUCT_PARTIALPartial Deduction PSSC_PARTIAL_DEDUCTIONCHAR1PSSC_PARTIAL_DEDUCTION
DEDUCT_PRIORITYPriority for items with same deduction type PSSC_PRIORITYNUMC3PSSC_PRIORITY
DEDUCT_TO_PARTYDeduct-To Party (GUID) PSSC_DEDUCT_TO_PARTYRAW16SYSUUID
DEDUCT_TO_PAR_NODeduct-To Party (Business Partner Number) PSSC_DEDUCT_TO_PARTY_NOCHAR10Assigned to domainALPHABU_PARTNER
DEDUCT_PAYM_FAMPayment Family PSSC_PAYMENT_FAMILYCHAR4PSSCC_PMNT_FAMPSSC_PAYMENT_FAMILY
DEDUCT_DDR_TYPEDue Date Rule PSSC_DDR_TYPECHAR4BSPER_DDR_TYPEBSPERIOD_DDR_TYPEPSSCSH_DDR_FRQ
CREATED_ATCreated At (Output in User Time Zone) COMT_CREATED_AT_USRDEC15TSTLCCOM_TSTMP
CREATED_BYUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
CHANGED_ATChanged At (Output in User Time Zone) COMT_CHANGED_AT_USRDEC15TSTLCCOM_TSTMP
CHANGED_BYTransaction Last Changed By CRMT_CHANGED_BYCHAR12UNAME
OBJECT_TYPECRM Item Object Type PSSC_OBJECT_TYPE_ITMCHAR10PSSC_OBJECT_TYPE_ITM
HEADERGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
PRODUCTInternal Unique ID of Product CRMT_PRODUCT_GUID_DBRAW16SYSUUID
DESCRIPTIONProduct Short Text CRMT_PRSHTEXTX_DBCHAR40CRM_PRSHTEXT40_DB
ITM_LANGUAGEShort Text Language for an Item CRMT_ITEM_LANGULANG1ISOLASYLANGU
NUMBER_INTItem Number in Document CRMT_ITEM_NONUMC10CRM_ITEM_NO
NUMBER_EXTExternal Item Number CRMT_ITEM_NO_EXTNUMC10
ITM_TYPEItem Category (CRM) PSSC_CRM_ITEM_TYPECHAR4PSSCC_ITM_TYPEPSSC_CRM_ITEM_TYPE
LOG_SYSTEM_EXTLogical System CRMT_LOGSYSCHAR10Assigned to domainALPHALOGSYS
ORDERED_PRODProduct Name Entered CRMT_ORDERED_PROD_DBCHAR54CRM_ORDERED_PROD
ORDERADM_I_DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
BENE_BENEFICIARYBenefit Beneficiary (GUID) PSSC_BENEFIT_BENEFICIARYRAW16SYSUUID
BENE_BENEFI_NOBenefit Beneficiary Number PSSC_BENE_BENEFI_NOCHAR10BUT000ALPHABU_PARTNER
PAYM_RECIPIENTPayment Recipient (GUID) PSSC_PAYMENT_RECIPIENTRAW16SYSUUID
PAYM_RECIPI_NOPayment Recipient Number PSSC_PAYMENT_RECIPIENT_NOCHAR10BUT000ALPHABU_PARTNER
MORE_PMT_RCPNTSBoolean for Social Services PSSCBOOLEANCHAR1PSSCBOOLEAN
ACTIVATEDStatus Active PSSCACTIVECHAR1PSSCBOOLEAN
ADJUSTEDAdjusted PSSCADJUSTEDCHAR1PSSCBOOLEAN
AUTOMATICAutomatic PSSCAUTOMATICCHAR1PSSCBOOLEAN
REJECTEDRejected PSSCREJECTEDCHAR1PSSCBOOLEAN
SCOPE_PARTNER_IDBusiness Partner ID for Decision Unit PSSC_SCOPE_PARTNER_IDCHAR10Assigned to domainALPHABU_PARTNER
SCOPE_ADDITIONAL_KEYAdditional Attribute of Decision Unit PSSC_SCOPE_ATTRIBUTECHAR32PSSC_SCOPE_ATTRIBUTE
SCOPE_DESCRIPTIONDecision Unit Description PSSC_SCOPE_DESCRIPTIONCHAR50PSSC_SCOPE_DESCRIPTION
SCOPE_CREATION_MODEDecision Unit Category PSSC_SCOPE_CREATION_MODECHAR1PSSC_SCOPE_CREATION_MODE

Key field Non-key field



How do I retrieve data from SAP table PSSCD_SXPITEM using ABAP code

The following ABAP code Example will allow you to do a basic selection on PSSCD_SXPITEM to SELECT all data from the table
DATA: WA_PSSCD_SXPITEM TYPE PSSCD_SXPITEM.

SELECT SINGLE *
FROM PSSCD_SXPITEM
INTO CORRESPONDING FIELDS OF WA_PSSCD_SXPITEM
WHERE...

How to access SAP table PSSCD_SXPITEM

Within an ECC or HANA version of SAP you can also view further information about PSSCD_SXPITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!