/PF1/DB_ITEM - Payment Items in the Payment Engine

Payment Items in the Payment Engine information is stored in SAP table /PF1/DB_ITEM.
It is part of development package /PF1/PO_PERSISTENCY_LAYER in software component FIN-FSCM-PF. This development package consists of objects that can be grouped under "PO Processing Persistence Layer".

Fields for table /PF1/DB_ITEM

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
CLIENTClientXMANDTCLNT6
GUIDGlobally Unique IdentifierXGUIDRAW16
.INCLUDEBUSINESS_KEY/PF1/STR_PO_PI_KEY_BUSINESS0
CLEARING_AREAClearing Area/PF1/DTE_BPE_CLEARING_AREACHAR12/PF1/T_CLAREA
PI_DATEPayment Item Date/PF1/DTE_PO_PI_KEY_DATEDATS16
PI_NOPayment Item Number From Number Range/PF1/DTE_PO_PI_SECONDARY_KEYNUMC24
.INCLUDEBUSINESS_STRUCTURE/PF1/STR_PO_ITEM_NEW0
SEGMENTATION_KEYSegmentation Criteria for DB Tables/PF1/DTE_BPE_SEGMENTATION_KEYCHAR4
TIME_PARTPartition field of DB table/PF1/DTE_BPE_TIME_PARTCHAR4
.INCLUDETECHNICAL/PF1/STR_PO_PIADMINDATA0
PI_STATStatus of Generic Status Management/PF1/DTE_BPE_SC_STATE_IDCHAR6*
TECH_STATProcessing Status of Payment Item/PF1/DTE_PI_TECH_STATCHAR6*
PREV_TECH_STATPrevious Technical Status of Payment Item/PF1/DTE_PI_PREV_TECH_STATCHAR6*
PI_KINDPayment Item Category/PF1/DTE_PO_PI_KINDCHAR4
FLG_POSTEDItem Already Posted/PF1/DTE_PO_FLG_POSTEDCHAR2
FLG_RESERVEDItem Reserved in Account Management/PF1/DTE_PO_FLG_RESERVEDCHAR2
FLG_ERRORError Item/PF1/DTE_BPE_FLG_ERRORCHAR4
FLG_FH_ERRORPayment Item Error Flag/PF1/DTE_FH_FLG_PI_ERRORCHAR2
FLG_DISP_SUCCESSExecute Action/PF1/DTE_BPE_BOOLEANCHAR2
FLG_A_RETURNED(OBSOLETE) Flag Active Return/PF1/DTE_BPE_A_RETURNEDCHAR2
FLG_EH_ERRORPayment Item Error Flag due to EH Checks/PF1/DTE_EH_FLG_PI_ERRORCHAR2
DISP_STATExternal Status/PF1/DTE_BPE_DISPATCH_STATECHAR12*
FLG_LISTENER_REGEvent Listener Registered/PF1/DTE_OBJECT_LISTENER_REGCHAR2
UPDATE_COUNTERLock Counter for Optimistic Stateless Updates/PF1/DTE_LOCK_COUNTERDEC3
FLG_REMITTANCE(OBSOLETE) Remittance Indicator/PF1/DTE_PO_PI_REMITTANCECHAR2
FLG_TCHAIN(OBSOLETE) Remittance Indicator/PF1/DTE_PO_PI_REMITTANCECHAR2
TECH_PRIORITYPayment Item Technical Priority/PF1/DTE_PO_PI_TECH_PRIORITYNUMC6
.INCLUDEGRP_ROUTING/PF1/STR_PO_PIREFROUTECLEARING0
REF_ROUTERoute ID/PF1/DTE_BPE_ROUTE_IDCHAR22/PF1/DB_ROUTE
REF_CLEARINGClearing Agreement ID/PF1/DTE_BPE_CLEARING_IDCHAR22/PF1/DB_CA
REF_AM_AREAAccount Managing Area/PF1/DTE_BPE_AM_AREACHAR12/PF1/T_AM_AREA
PREDETERM_ROUTEPredetermined Route Retrieved from E&V/PF1/DTE_BPE_PREDET_RTCHAR2
RP_TO_DETERMINECalculate Route, Clearing Agreement and Value Date Agreement/PF1/DTE_RP_TO_DETERMINECHAR2
REF_ACCT_LOC_SRVPredefined Account Location/PF1/DTE_BPE_ALSCHAR12
.INCLUDE/PF1/STR_PO_PIPOREF0
REF_ITEM_EXTExternal Item Reference/PF1/DTE_PO_PI_REFITEM_SEC_KEYCHAR70
FLG_ADD_INFOFlag for Additional Information about a Payment Item/PF1/DTE_PO_PI_FLG_ADD_INFOCHAR2
REF_PI_AM_AREAExternal Item Reference in Account Management System/PF1/DTE_PO_REF_PI_AM_ARCHAR200
REF_PRED_PI_DATEDate Reference to Predecessor Items/PF1/DTE_PO_REV_PRED_PI_DATEDATS16
REF_PRED_PI_NOSequence Number Reference to Predecessor Items/PF1/DTE_PO_REV_PRED_PI_NONUMC24
REF_SUCC_PI_DATEDate Reference to Successor Items/PF1/DTE_PO_REV_SUCC_PI_DATEDATS16
REF_SUCC_PI_NOSequence Number Reference to Successor Items/PF1/DTE_PO_REV_SUCC_PI_NONUMC24
REF_INP_PO_DATEReference to Incoming Payment Order: PO Date/PF1/DTE_PO_REF_INPUT_PO_DATEDATS16
REF_INP_PO_NOReference to Incoming Payment Order/PF1/DTE_PO_REF_INPUT_PONUMC24
REF_OUTP_PO_DATEReference to Outgoing Payment Order: PO Date/PF1/DTE_PO_REF_OUTPUT_PO_DATEDATS16
REF_OUTP_PO_NOReference to Outgoing Payment Order: Sequence Number/PF1/DTE_PO_REF_OUTPUT_PONUMC24
REF_COLL_DATEPayment Batch Date/PF1/DTE_CP_COLLECTOR_DATEDATS16
REF_COLL_NOPayment Batch Number from Number Range (Secondary Key)/PF1/DTE_CP_CO_SECONDARY_KEYNUMC20
REF_COLL_SEQ_NOSequence Number of Payment Batch/PF1/DTE_CP_SEQUENCE_NONUMC10
COLL_ENT_DATEDate of Stored Item in Payment Batch/PF1/DTE_CP_STORE_DATEDATS16
COLL_ENT_TIMETime of Stored Item in Payment Batch/PF1/DTE_CP_STORE_TIMETIMS12
REF_PRENOTE_IDPrenote Reference/PF1/DTE_PO_REF_PRENOTE_IDCHAR92
REF_ITEM_EXT_OUTExternal Item Reference - outbound messages/PF1/DTE_PO_PI_REFITEM_SEC_OUTCHAR70
REF_ITEM_EXT_INExternal Item Reference - inbound messages/PF1/DTE_PO_PI_REFITEM_SEC_INCHAR70
.INCLUDESLA_KEY/PF1/STR_PO_ORDER_SLA0
REF_CUST_GRPCustomer Group/PF1/DTE_BPE_CUST_GRPCHAR22
REF_CUSTOMERCustomer/PF1/DTE_BPE_CUSTOMERCHAR22
REF_CUST_SGMCustomer Segment/PF1/DTE_BPE_CUST_SGMCHAR22
UETRUnique Transaction Reference (UETR)FPM_UETRCHAR72
REF_PREDEF_GRPPredefined grouping criteria/PF1/DTE_PO_PI_REF_PREDEF_GRPCHAR70
.INCLUDEACCOUNT/PF1/STR_PO_PI_ACCT_SUB0
COUNTRYBank Country/Region/PF1/DTE_PO_BNKCTY_AFTER_SUBSTCHAR6T005
BANKKEYBank Number/PF1/DTE_PO_BNKCDE_AFTER_SUBSTCHAR30
BICBank Identifier Code (BIC)/PF1/DTE_PO_BIC_AFTER_SUBSTCHAR22
IBANIBAN After Account Substitution/PF1/DTE_PO_IBAN_AFTER_SUBSTCHAR68
ACCT_NOAccount Number/PF1/DTE_PO_ACCT_AFTER_SUBSTCHAR68
ACCT_CURAccount Currency After Substitution/PF1/DTE_PO_AC_CUR_AFT_SUBSTCUKY10TCURC
HOLDERSubstitute Account Holder Name/PF1/DTE_PO_HOLDERNAME_SUBSTCHAR160
CLRSYSIDCDClearing System Member ID Code/PF1/DTE_PO_CLRSYSMMBIDCDCHAR10
.INCLUDEREF_ACCOUNT/PF1/STR_PO_PI_ORIG_ORPDATA0
REF_COUNTRYOrdering Party Bank Country/Region/PF1/DTE_PO_ORP_COUNTRYCHAR6T005
REF_BANKKEYOrdering Party Domestic Bank Key/PF1/DTE_PO_ORP_BANKKEYCHAR30
REF_BICOrdering Party Bank Internation Code(BIC)/PF1/DTE_PO_ORP_BICCHAR22
REF_IBANOrdering Party Account IBAN/PF1/DTE_PO_ORP_IBANCHAR68
REF_ACCT_NOOrdering Party Account Number/PF1/DTE_PO_ORP_ACCT_NOCHAR68
REF_ACCT_CUROrdering Party Account Currency/PF1/DTE_PO_ORP_AC_CUR_NOCUKY10TCURC
REF_HOLDERReference Account Holder/PF1/DTE_PO_ORP_HOLDERCHAR160
REF_CLRSYSIDCDClearing System Member ID Code/PF1/DTE_PO_CLRSYSMMBIDCDCHAR10
.INCLUDEGRP_VALUTA/PF1/STR_PO_VALUE_DATE0
ORIG_VAL_DATE(OBSOLETE) Original Value Date/PF1/DTE_PO_ORIG_VALUE_DATEDATS16
ORIG_VAL_TIME(OBSOLETE) Original Value Date Time/PF1/DTE_PO_ORIG_VALUE_TIMETIMS12
VAL_DATE(OBSOLETE) Value Date/PF1/DTE_PO_VALUE_DATEDATS16
VAL_TIME(OBSOLETE) Value Date Time/PF1/DTE_PO_VALUE_TIMETIMS12
REF_VALUTA_IDValue Date Agreement ID/PF1/DTE_BPE_VA_IDCHAR22
REF_RULESET_IDRule Set ID of Value Date Agreement/PF1/DTE_BPE_VA_RULESET_IDCHAR44*
VALUE_DATE_STATValue Date Status/PF1/DTE_PO_VALUE_DATE_STATNUMC4
FLG_HLD_VAL_DATEHold Value Date Indicator/PF1/DTE_BPE_HLD_VAL_DATCHAR2
ACT_VAL_DATE(OBSOLETE) Actual Value Date/PF1/DTE_PO_ACT_VALUE_DATEDATS16
.INCLUDE/PF1/STR_PO_PI_DATE_INFO0
PI_POST_DATEPosting Date/PF1/DTE_PO_POST_DATEDATS16
PI_POST_TIMEPosting Time/PF1/DTE_PO_PI_POSTINGTIMETIMS12
PL_CLR_DATEPlanned Clearing Date for Payment Item/PF1/DTE_PO_PI_PLCLEARINGDATEDATS16
PL_CLR_TIMEPlanned Clearing Time for Payment Item/PF1/DTE_PO_PI_PLCLEARINGTIMETIMS12
PI_PROCESS_DATEDate When Item was Sent to AM System for Posting/PF1/DTE_PO_PI_PROCESSDATEDATS16
PI_PROCESS_TIMETime When Item Was Sent to AM System for Posting/PF1/DTE_PO_PI_PROCESSTIMETIMS12
ACT_POST_DATEActual Posting Date (AM)/PF1/DTE_ACT_POSTDATEDATS16
.INCLUDEGRP_AMOUNT/PF1/STR_PO_PI_AMOUNT_INFO0
TR_CURRTransaction Currency/PF1/DTE_BPE_CURRCUKY10TCURC
TR_AMOUNTAmount in Transaction Currency/PF1/DTE_BPE_AMOUNTCURR12
TR_DEBCREDINDTransaction Debit/Credit/PF1/DTE_BPE_DCFLGCHAR2
TR_FEECharge Amount/PF1/DTE_PO_FEE_AMOUNTCURR12
FEE_DEBCREDCharge Debit/Credit/PF1/DTE_BPE_FEE_DC_FLGCHAR2
FEE_INFOCharge Bearer/PF1/DTE_BPE_CHARGE_DETAILCHAR12
ORIGINAL_CURROriginal Currency/PF1/DTE_PO_IT_ORIGINAL_CURRCUKY10TCURC
ORIGINAL_AMOUNTOriginal Amount/PF1/DTE_PO_IT_ORIGINAL_AMOUNTCURR12
NOM_AMOUNT_CHNGTransaction Amount Difference Changed/PF1/DTE_AMOUNT_CHNGCURR12
A_AMOUNTMonetary Amount in Transfer Currency/PF1/DTE_PO_ITEM_TRF_AMOUNTCURR12
A_AMOUNT_FEECharges in account currency/PF1/DTE_PO_ITEM_ACCOUNT_FEECURR12
A_AMOUNT_CURRTransfer Currency Code/PF1/DTE_PO_ITEM_TRF_AMT_CURRCUKY10*
EXCHNGRATEExchange Rate/PF1/DTE_PO_ITEM_EXCHANGERATEDEC9
.INCLUDE/PF1/STR_PO_PI_TRNS_INFO0
TRANS_TYPETransaction Type (Advanced Payment Management)/PF1/DTE_BPE_TRNSTYPECHAR12/PF1/T_TRANSTYPE
PROCESSCreation Process of Payment Object/PF1/DTE_PO_PI_PROCESSCHAR8/PF1/T_PROCESS
PRIORITYPayment Priority/PF1/DTE_PO_PO_PRIORITYCHAR4
FLG_ENFORCE_POSTForce Posting/PF1/DTE_PO_PI_ENFORCE_POSTINGCHAR2
CHEQUE_NOCheck Number/PF1/DTE_BPE_CHEQUE_NOCHAR50
RETURN_CODEReturn/Rejection Reason/PF1/DTE_BPE_REVERSAL_CODECHAR12/PF1/T_REVERSE
.INCLUDE/PF1/STR_PO_ITEM_REL_PROCESS0
RELEASE_ACTIVITYActivity for Release and Authorization Check/PF1/ACTIV_AUTHCHAR4
RELEASE_STATUSRelease Status/PF1/DTE_PO_RELEASE_STATUSCHAR4
.INCLUDEGRP_EV/PF1/STR_PO_ITEM_EV0
FLG_EV_STATUSExecution Status of Each Check/PF1/DTE_PO_FLG_CHK_EV_STATUSCHAR120
EV_IDIncoming Check Set ID for Payment Item E&V/PF1/DTE_BPE_PMNT_EV_ID_INNUMC12
FLG_INTERNALInternal Posting/PF1/DTE_BPE_EX_INT_FLGCHAR2
SPLIT_INDIOrdering Party Item Split/PF1/DTE_BPE_SPLIT_INDICHAR2
ITEM_GROUPORP/RCP item group reference/PF1/DTE_PO_ORP_SPLIT_REFCHAR56
FLG_ITEM_AUTHFlag to Indicate External Authorization Status/PF1/DTE_FLG_AUTH_PINUMC4
FLG_EV_STATUS_OPOExecution Status of Each Check/PF1/DTE_PO_FLG_CHK_EV_STATUSCHAR120
EV_ID_OPOOutgoing Check Set ID for Payment Item E&V/PF1/DTE_BPE_PMNT_EV_ID_OUTNUMC12
CONTINUE_EV_OPOEnrichment & Validation Continuation Status/PF1/DTE_PO_FLG_CONTINUE_EVCHAR2
ACCOUNT_HOLDER_IDBusiness Partner Number/PF1/BAPIBCA_DTE_BUPA_PARTNERCHAR20
RISK_SCORERisk Score/PF1/DTE_BPE_RISK_SCOREINT22
BAM_IDBank Account Technical IDFCLM_BAM_ACC_IDNUMC20
.INCLUDE/PF1/STR_PO_ITEM_REF_REC0
REF_RECALL_DATEPayment Recall Date/PF1/DTE_PO_PO_KEY_DATEDATS16
REF_RECALL_NOPayment Recall Number/PF1/DTE_RECALL_IDNUMC24
.INCLUDE/PF1/STR_PI_PERF_ENH0
PI_RANGEPayment Item Range/PF1/DTE_PI_RANGEINT44
PI_KIND_003Payment Item Category (Index 003)/PF1/DTE_PO_PI_KIND_003CHAR4
PI_RANGE_003Payment Item Range (Index 003)/PF1/DTE_PI_RANGE_003INT44
PI_KIND_004Payment Item Category (Index 004)/PF1/DTE_PO_PI_KIND_004CHAR4
PI_RANGE_004Payment Item Range (Index 004)/PF1/DTE_PI_RANGE_004INT44
PI_KIND_ACQPayment Item Category (Index Collectors/Queues)/PF1/DTE_PO_PI_KIND_ACQCHAR4
PI_RANGE_ACQPayment Item Range (Index ACQ)/PF1/DTE_PI_RANGE_ACQINT44
.INCLUDE/PF1/STR_PO_PI_SEPA0
DUE_DATEDue Date Specified by Ordering Party/PF1/DTE_PO_DUE_DATEDATS16
MANDATE_IDMandate Identification/PF1/DTE_PO_MANDATE_IDCHAR70
UCICreditor ID/PF1/DTE_UCICHAR70
END_TO_END_IDOrdering Party Reference (Unique Number for ISO Payment)/PF1/DTE_PO_PI_REF_ORDPARTYCHAR70
DIRECT_DEB_TYPEDirect Debit Type/PF1/DTE_SDD_TYPECHAR2
.INCLUDEGRP_PMTTPINF/PF1/STR_ISO_PMT_TP_INFO0
LCL_INSTRUMENTISO20022: Local Instrument Code or Proprietary Code/PF1/DTE_LOCAL_INSTRUMENTCHAR70
CATEGORY_PURPOSE_CODEISO20022: Category Purpose Code or Proprietary Code/PF1/DTE_CATEGORYPURPOSECDPRTYCHAR70
SERVICE_LEVELISO20022: Service Level Code or Proprietary Code/PF1/DTE_SERVICE_LEVEL_CD_PRTYCHAR70
.INCLUDE/PF1/STR_AR_ITEM_REF_ARC0
FLG_INP_PO_ARCReferencing incoming order is archived/PF1/DTE_AR_FLG_INP_PO_ARCCHAR2
FLG_OUTP_PO_ARCReferencing outgoing order is archived/PF1/DTE_AR_FLG_OUTP_PO_ARCCHAR2
FLG_OUT_INF_ARCReferencing advice order is archived/PF1/DTE_AR_FLG_OUT_INF_ARCCHAR2
FLG_RECALL_ARCReferencing recall is archived/PF1/DTE_AR_FLG_RECALL_ARCCHAR2
.INCLUDE/PF1/STR_PO_PI_FI_DATA0
COSTCENTERCost CenterKOSTLCHAR20*
BUS_AREABusiness AreaGSBERCHAR8*
.INCLUDEIHC_KEYIHC_STR_PN_SEMKEY0
UNITBank AreaIHC_DTE_UNITCHAR8
PN_NUMBERPayment Order NumberIHC_DTE_PN_NUMBERNUMC20
PN_YEARFiscal Year of IHC Payment OrderIHC_DTE_PN_JAHRNUMC8
.INCLUDEGRP_IDOC/PF1/STR_PO_IDOC_REFERENCES0
PAYMENT_METHODPayment Method for This PaymentRZAWECHAR2*
PAYMENT_METHOD_SUPPLEMENTPayment method supplementUZAWECHAR4*
.INCLUDEGRP_ADMIN/PF1/STR_BPE_DBADMIN0
CRUSRCreating User/PF1/DTE_BPE_CRUSRCHAR24
CRDATCreation Date/PF1/DTE_BPE_CRDATDATS16
CRTIMCreation Time/PF1/DTE_BPE_CRTIMTIMS12
CHUSRLast User Change/PF1/DTE_BPE_CHUSRCHAR24
CHDATChange Date/PF1/DTE_BPE_CHDATDATS16
CHTIMChanged Time/PF1/DTE_BPE_CHTIMTIMS12
RLUSRUser Who Released Object/PF1/DTE_BPE_RLUSRCHAR24
RLDATRelease Date/PF1/DTE_BPE_RLDATDATS16
RLTIMRelease Time/PF1/DTE_BPE_RLTIMTIMS12
Privacy Policy