CRMS4D_PREQ_I - Payment Request Item

Payment Request Item information is stored in SAP table CRMS4D_PREQ_I.
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_PREQ_I

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
.INCLUDEXCRMS4S_KEY_I0
.INCLUDEXCRMS4S_KEY_H0
CLIENTClientXMANDTCLNT6T000
OBJTYPE_HBusiness Trans. Cat.XCRMT_SUBOBJECT_CATEGORY_DBCHAR20CRMC_SUBOB_CAT
OBJECT_IDTransaction IDXCRMT_OBJECT_ID_DBCHAR20
NUMBER_INTShortened Item Number in DocumentXCRMS4_NUMBER_INTNUMC12
.INCLUDECRMS4S_PREQ_I_ORDERADM_I0
ITEM_GUIDGUID of a CRM Order ObjectCRMT_OBJECT_GUIDRAW16
CREATED_AT_ICreated At (Output in User Time Zone)COMT_CREATED_AT_USRDEC8
CREATED_BY_IUser that Created the TransactionCRMT_CREATED_BYCHAR24
CHANGED_AT_IChanged At (Output in User Time Zone)COMT_CHANGED_AT_USRDEC8
CHANGED_BY_ITransaction Last Changed ByCRMT_CHANGED_BYCHAR24
OBJTYPE_ICRM Item Object TypeCRMT_SWO_OBJTYP_PROCESS_ITM_DBCHAR20*
HEADER_GUIDGUID of a CRM Order ObjectCRMT_OBJECT_GUIDRAW16
PARENTGUID of a CRM Order ObjectCRMT_OBJECT_GUIDRAW16
ALTERNATIVEGUID of a CRM Order ObjectCRMT_OBJECT_GUIDRAW16
PRODUCTInternal Unique ID of ProductCRMT_PRODUCT_GUID_DBRAW16
ORDERED_PRODProduct Name EnteredCRMT_ORDERED_PROD_DBCHAR108
PARTNER_PRODProduct Number of Business PartnerCRMT_ITEM_DESCR_PARTNERCHAR80
DESCRIPTION_IProduct DescriptionCRMT_PRSHTEXTX_DBCHAR80
ITM_LANGUAGEShort Text Language for an ItemCRMT_ITEM_LANGULANG2
NUMBER_EXTExternal Item NumberCRMT_ITEM_NO_EXTNUMC20
ITM_TYPEItem CategoryCRMT_ITEM_TYPE_DBCHAR8*
ORDER_DATEPosting DateCRMT_ORDER_DATEDEC8
ITM_USAGEUsage of Higher-Level ItemCRMT_ITEM_USAGECHAR4
ITM_TYPE_USAGEItem Category UsageCRMT_IT_TYPE_USAGECHAR8*
PRODUCT_KINDProduct Technical TypeCRMT_PRODUCT_KINDCHAR2
REVACC_REFIDRevenue Accounting Reference IDCRMT_REVACC_REFIDCHAR60
REVACC_REFTYPERevenue Accounting Reference TypeCRMT_REVACC_REFTYPECHAR6
REVACC_RELEVANT_TYPERevenue Accounting TypeCRMT_REVACC_RELEVANT_TYPECHAR2
PRODUCT_IDProduct NumberPRODUCTNUMBERCHAR80
ITEM_GUID_CHAR32 Character CRM Object GUID (Converted)CRMT_OBJECT_GUID32CHAR64
.INCLUDECRMS4S_PREQ_I_H0
.INCLUDECRMS4S_PREQ_I_ORDERADM_H0
PROCESS_TYPEBusiness Transaction TypeCRMT_PROCESS_TYPE_DBCHAR8*
.INCLUDECRMS4S_PREQ_I_DATES_H0
CONTSTART_HContract Start DateCRMS4_PS_CONTSTARTDEC8
CONTEND_HContract End DateCRMS4_PS_CONTENDDEC8
.INCLUDECRMS4S_PREQ_I_STATUS_H0
STAT_ACTIVATION_HActivation StatusCRMS4_PS_STAT_ACTIVATIONCHAR2
STAT_LIFECYCLELife Cycle StatusCRMS4_STAT_LIFECYCLECHAR8
STAT_RELEASEDRelease StatusCRMS4_STAT_RELEASEDCHAR2
STAT_APPROVAL_HApproval StatusCRMS4_PS_STAT_APPROVALCHAR4
.INCLUDECRMS4S_PSOA_I_PARTNER_H0
PERSON_RESPEmployee ResponsibleCRMS4_PS_EMPLOYEE_RESPCHAR20*
APPLICANTApplicantCRMS4_PS_APPLICANTCHAR20*
APPROVED_BYApproved ByCRMS4_PS_APPROVED_BYCHAR20*
REJECTED_BYRejected ByCRMS4_PS_REJECTED_BYCHAR20*
.INCLUDECRMS4S_ITEM_SET_FIELDS0
ITEM_NO_APPTShortened Item Number in DocumentCRMS4_NUMBER_INTNUMC12
ITEM_NO_PARTNERShortened Item Number in DocumentCRMS4_NUMBER_INTNUMC12
ITEM_NO_QUALIFShortened Item Number in DocumentCRMS4_NUMBER_INTNUMC12
ITEM_NO_REFOBJShortened Item Number in DocumentCRMS4_NUMBER_INTNUMC12
ITEM_NO_SUBJECTShortened Item Number in DocumentCRMS4_NUMBER_INTNUMC12
ITEM_NO_SURVEYShortened Item Number in DocumentCRMS4_NUMBER_INTNUMC12
ITEM_NO_BILLPLANShortened Item Number in DocumentCRMS4_NUMBER_INTNUMC12
ITEM_NO_PAYPLANShortened Item Number in DocumentCRMS4_NUMBER_INTNUMC12
.INCLUDECRMS4S_PREQ_I_DATES0
CONTSTART_IContract Start DateCRMS4_PS_CONTSTARTDEC8
CONTEND_IContract End DateCRMS4_PS_CONTENDDEC8
.INCLUDECRMS4S_PREQ_C_ORGMAN0
DIS_CHANNELDistribution ChannelCRMT_DISTRIBUTION_CHANNELCHAR4TVTW
DIVISIONDivisionCRMT_DIVISIONCHAR4TSPA
SERVICE_ORG_ORIOrigin Indicator: Service OrganizationCRMT_SERVICE_ORG_ORIGINCHAR2
SERVICE_ORGR_ORIOrigin Indicator: Service Scenario Organizational UnitCRMT_SERVICE_ORG_RESP_ORIGINCHAR2
SALES_ORG_ORIOrigin Indicator: Sales OrganizationCRMT_SALES_ORG_ORIGINCHAR2
DIS_CHANNEL_ORIOrigin Indicator: Distribution ChannelCRMT_DIS_CHANNEL_ORIGINCHAR2
SALES_OFF_ORIOrigin Indicator: Sales OfficeCRMT_SALES_OFFICE_ORIGINCHAR2
SALES_GROUP_ORIOrigin Indicator: Sales GroupCRMT_SALES_GROUP_ORIGINCHAR2
SALES_ORGR_ORIOrigin Indicator: Sales Scenario Organizational UnitCRMT_SALES_ORG_RESP_ORIGINCHAR2
DIVISION_ORIOrigin Flag: DivisionCRMT_DIVISION_ORIGINCHAR2
SALES_ORGSales Organization IDCRMT_SALES_ORGCHAR28
SALES_OFFICESales OfficeCRMT_SALES_OFFICECHAR28
SALES_GROUPSales GroupCRMT_SALES_GROUPCHAR28
SALES_ORG_RESPOrganizational Unit (Sales)CRMT_SALES_ORG_RESPCHAR28
SERVICE_ORGService OrganizationCRMT_SERVICE_ORGCHAR28
SERVICE_ORG_RESPOrganizational Unit (Service)CRMT_SERVICE_ORG_RESPCHAR28
.INCLUDECRMS4S_ORGMAN_SALES_SD0
SALES_ORG_SDSales OrganizationVKORGCHAR8
SALES_OFFICE_SDSales officeVKBURCHAR8*
SALES_GROUP_SDSales groupVKGRPCHAR6*
.INCLUDECRMS4S_PREQ_I_PARTNER0
BENEFICIARYBeneficiaryCRMS4_PS_BENEFICIARYCHAR20*
PAYMENT_RECIPIENTPayment RecipientCRMS4_PS_PAYMENT_RECIPIENTCHAR20*
.INCLUDECRMS4S_PREQ_I_INCL_EEW_PS0
PREQ_I_DUMMY_PSSingle-Character FlagCHAR1CHAR2
.INCLUDECRMS4S_PREQ_I_PS_SOCIAL_I0
PARTNER_IDBusiness Partner IDCRM_PS_SCOPE_PARTNER_IDCHAR20*
ADDITIONAL_KEYDecision Unit Additional AttributeCRM_PS_SCOPE_ADDITIONAL_KEYCHAR64
Privacy Policy