CRMD_PS_NCDITEM - Net Calculation Document Item

Net Calculation Document Item information is stored in SAP table CRMD_PS_NCDITEM.
It is part of development package CRMS4_PS_DDIC in software component CRM-S4-IPS-SEP. This development package consists of objects that can be grouped under "Social Services DDIC Objects".

Fields for table CRMD_PS_NCDITEM

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
ITEMGROUPIDItem Group Identification (UUID)XCRMS4_PS_ITEM_GROUP_GUIDRAW16
ITEMIDSocial Services Business Object Item IDXCRMS4_PS_ITEM_GUIDRAW16
.INCLUDECRMS4S_PS_NCDITEM_CON0
POSNRExternal Position Number NCD ItemCRMS4_PS_NCDITEM_POS_NONUMC16
SXP_KINDBusiness Trans. Cat.CRMS4_PS_BUS_TYPE_HEADERCHAR20
AMOUNTAmountCRMS4_PS_AMOUNTCURR7
CURRENCYCurrency KeyCRM_PS_4S_CURRENCYCUKY10TCURC
TAX_CATEGORYTax CategoryCRMS4_PS_TAX_CATCHAR8
BENEFIT_IDBenefit IDCRMS4_PS_BENEFIT_IDRAW16
BENEFIT_ID_EXTBenefit ID (external representation)CRMS4_PS_BENEFIT_ID_EXTCHAR108
ITM_TYPEItem Category (CRM)CRMS4_PS_CRM_ITEM_TYPECHAR8*
PROCESS_CATEGORYGross Payment Item Process CategoryCRMS4_PS_PAYMENT_CATEGORYCHAR2
ENTITLEMENT_CATEntitlement Category (Entitled or Not Entitled)CRMS4_PS_ENTITLE_CATCHAR2
DEDUCTION_TYPEDeduction TypeCRMS4_PS_DEDUCT_TYPECHAR8CRMC_PS_DDT
.INCLUDECRMS4S_PS_DEDUCT_INFO0
DEDUCT_PERCENTDeduction PercentageCRMS4_PS_PERCENTAGEDEC4
DEDUCT_PARTIALPartial DeductionCRMS4_PS_PARTIAL_DEDCHAR2
DEDUCT_PRIORITYPriority for Items with the Same Deduction TypeCRMS4_PS_NET_DEDUCT_PRIORITYNUMC6
DEDUCT_TO_PARTYDeduct-To Party (GUID)CRMS4_PS_DEDUCT_TO_PARTY_GUIDRAW16
DEDUCT_TO_PAR_NODeduct-To Party (Business Partner Number)CRMS4_PS_DEDUCT_TO_PARTY_IDCHAR20*
DEDUCT_PROC_CATDeduction Plan Item Process CategoryCRMT_ITM_PROCCHAR8*
DEDUCT_TYPE_RANKDeduction Type RankingCRMS4_PS_DEDUCT_TYPE_RANKINGNUMC6
NET_PART_DEDUCTDeduction applied only partially for net calculation itemCRMS4_PS_NET_PARTIAL_DEDCHAR2
DUE_PER_BEG_ORIGStart Date of Payment PeriodCRMS4_PS_DUE_PERIOD_BEGDA_ORIGDATS16
DUE_PER_END_ORIGEnd Date of Payment PeriodCRMS4_PS_DUE_PERIOD_ENDDA_ORIGDATS16
ENTITLEM_AMTAmount per Entitlement PeriodCRMS4_PS_PMNT_ENT_AMOUNTCURR7
ENTITLEM_PERIODSNumber of Entitlement Periods for a Payment PeriodCRMS4_PS_NO_ENT_PERIODSNUMC8
ENTITLEM_BEGDAStart Date of Entitlement Period for Payment PeriodCRMS4_PS_ENTLMENT_BEGDADATS16
ENTITLEM_ENDDAEnd Date of Entitlement Period for Payment PeriodCRMS4_PS_ENTLMENT_ENDDADATS16
BASE_AMOUNTGross AmountCRMS4_PS_PMNT_BASE_AMOUNTCURR16
REMAINING_AMOUNTRemaining Amount for DeductionsCRMS4_PS_PMNT_FRQ_REM_AMOUNTCURR16
GPI_VERSIONIDReference to Net Calculated GPD Version IDCRMS4_PS_REF_GPI_DPI_VERSIONIDRAW16
GPI_ITEMIDReference to Net Calculated GPD ItemCRMS4_PS_REF_GPI_DPI_ITEMIDRAW16
.INCLUDECRMS4S_PS_ALT_PAY_INFO0
ALT_PAYEE_GUIDAlternative Payee GUIDCRMS4_PS_ALT_PAYEE_GUID_RAWRAW16
ALT_PAYEE_NOAlternative Payee NumberCRMS4_PS_ALTERNATIVE_PAYEE_IDCHAR20BUT000
ALT_PAY_METHODPayment Method for Outgoing PaymentsCRMS4_PS_PAYMENT_METHOD_OUTCHAR2TFK042Z
ALT_PAY_ADDR_IDAlternate Payment Address IDCRMS4_PS_ALT_PAYM_ADDRESS_IDCHAR20ADRC
ALT_PAY_ADDRGUIDAlternate Payment Address as GUIDCRMS4_PS_ALT_PAYM_ADD_GUID_RAWRAW16
ALT_PAY_BANK_IDAlternate Payment Bank IDCRMS4_PS_ALT_PAYM_BANK_IDCHAR8
.INCLUDECRMS4S_PS_SXP_DU_H_WRK0
SCOPE_PARTNER_IDBusiness Partner ID for Decision UnitCRMS4_PS_DU_PARTNER_IDCHAR20*
SCOPE_ADDITIONAL_KEYAdditional Attribute of Decision UnitCRMS4_PS_DU_ATTRIBUTECHAR64
SCOPE_DESCRIPTIONDecision Unit DescriptionCRMS4_PS_DU_TCHAR100
SCOPE_CREATION_MODEDecision Unit CategoryCRMS4_PS_DU_CREATION_MODECHAR2
.INCLUDECRMS4S_PS_REDUCTION0
RED_REF_GUIDInternal Unique ID of ProductCRMT_PRODUCT_GUID_DBRAW16
RED_REF_PRODUCTReference Benefit IDCRMS4_PS_RED_REF_PRODUCTCHAR108
IS_REDUCTIONItem is a Reduction ItemCRMS4_PS_IS_REDUCTIONCHAR2
SXP_TYPEBusiness Transaction TypeCRMT_PROCESS_TYPECHAR8
BENEFIT_PROGBenefit ProgramCRM_PS_BENEFIT_PROGCHAR8*
.INCLUDECRMS4S_PS_NCDITEM_INCL_EEW_PS0
DUMMY_NCDITEM_PSSingle-Character FlagCHAR1CHAR2
Privacy Policy