/PF1/C_BATCH_ITEMS

Payment Batch Items | view: /PF1/CV_BTCITM | Extraction: Not supported | Component: Payment Factory
Tables used: /PF1/DB_OBJ_REL, /PF1/DB_ORDER, /PF1/DB_ITEM
Column Name Description
PaymentItemGuid UI Object ID
Column Name Description
💲 Transaction Currency (TransactionCurrency):
TransactionAmount Amount in Transaction Currency
TransactionFee Charge Amount
💲 Transfer Currency Code (AAmountCurrency):
AAmount Monetary Amount in Transfer Currency
AAmountFee Charges in account currency
💲 Original Currency (OriginalCurrency):
OriginalAmount Original Amount
Column Name Description
Column Name Description
PaymentItemDate Payment Item Date
PredecessorItemDate Date Reference to Predecessor Items
SuccessorItemDate Date Reference to Successor Items
InputOrderDate Reference to Incoming Payment Order: PO Date
OutputOrderDate Reference to Outgoing Payment Order: PO Date
ref_coll_date Payment Batch Date
OriginalValueDate (OBSOLETE) Original Value Date
OriginalValueTime (OBSOLETE) Original Value Date Time
ValueDate (OBSOLETE) Value Date
ValueTime (OBSOLETE) Value Date Time
ActValueDate (OBSOLETE) Actual Value Date
PostingDate Posting Date
PostingTime Posting Time
PlannedClearingDate Planned Clearing Date for Payment Item
PlannedClearingTime Planned Clearing Time for Payment Item
ProcessingDate Date When Item was Sent to AM System for Posting
ProcessingTime Time When Item Was Sent to AM System for Posting
ActPostingDate Actual Posting Date (AM)
ReferenceRecallDate Payment Recall Date
DueDate Due Date Specified by Ordering Party
CreateDate Creation Date
CreateTime Creation Time
ChangeDate Change Date
ChangeTime Changed Time
ReleaseDate Release Date
ReleaseTime Release Time
Column Name Description
TechnicalStatusState Technical Status State (Red/Yellow/Green) Show values
PaymentItemKind Payment Item Category Show values
ValueDateStat Value Date Status Show values
TransactionCreditDebitId Transaction Debit/Credit Show values
FeeDebitCreditId Charge Debit/Credit Show values
FeeInfo Charge Bearer Show values
Priority Payment Priority Show values
EnforcePostingFlag Force Posting Show values
ReleaseActivity Activity for Release and Authorization Check Show values
ReleaseStatus Release Status Show values
FlagInternal Internal Posting Show values
SplitIndicator Ordering Party Item Split Show values
DirectDebitType Direct Debit Type Show values
CreatedDateUIIndicator UI Date Identifier Show values
Column Name Description Domain name
PaymentItemKey Payment Item Key /PF1/DOM_UI_KEY
PaymentItemNumber Payment Item Number From Number Range /PF1/DOM_PO_PO_ID
PaymentItemStatus Status of Generic Status Management /PF1/DOM_BPE_SC_STATE_ID
TechnicalStatus Processing Status of Payment Item /PF1/DOM_BPE_SC_STATE_ID
TechnicalStatusDesc Technical Status Description /PF1/DOM_BPE_SC_STATE_KIND_DES
TechnicalStatusColor Two digit number NUMC2
Draft Draft Flag
PreviousTechnicalStatus Previous Technical Status of Payment Item /PF1/DOM_BPE_SC_STATE_ID
UpdateCounter Lock Counter for Optimistic Stateless Updates /PF1/DOM_LOCK_COUNTER
AccountLocatorService Predefined Account Location /PF1/DOM_BPE_ALS
ExternalReference External Item Reference /PF1/DOM_PO_REF_EXT_ID
PredecessorItemNumber Sequence Number Reference to Predecessor Items /PF1/DOM_PO_PO_ID
SuccessorItemNumber Sequence Number Reference to Successor Items /PF1/DOM_PO_PO_ID
InputOrderNumber Reference to Incoming Payment Order /PF1/DOM_PO_PO_ID
OutputOrderNumber Reference to Outgoing Payment Order: Sequence Number /PF1/DOM_PO_PO_ID
ref_coll_no Payment Batch Number from Number Range (Secondary Key) /PF1/DOM_CP_CO_SECONDARY_KEY
ref_coll_seq_no Sequence Number of Payment Batch /PF1/DOM_CP_SEQUENCE_NO
PrenoteId Prenote Reference /PF1/DOM_PO_REF_PRENOTE_ID
Customer Customer /PF1/DOM_BPE_CUSTOMER
CustomerSegment Customer Segment /PF1/DOM_BPE_CUST_SGM
ExternalItemReferenceOut External Item Reference - outbound messages /PF1/DOM_PO_REF_EXT_ID
CustomerGroup Customer Group /PF1/DOM_BPE_CUST_SGM
BankKey Bank Key BANKK
BIC Bank Identifier Code (BIC) /PF1/DOM_BPE_BIC
IBAN IBAN After Account Substitution /PF1/DOM_BPE_IBAN
AccountNumber Account Number /PF1/DOM_BPE_ACCT
AccountHolder Substitute Account Holder Name /PF1/DOM_BPE_HOLDERNAME
ClSysIdCd Clearing System Member ID Code /PF1/DOM_PO_CLRSYSMMBIDCD
ReferenceBankKey Ordering Party Domestic Bank Key BANKK
ReferenceBIC Ordering Party Bank Internation Code(BIC) /PF1/DOM_BPE_BIC
ReferenceIBAN Ordering Party Account IBAN /PF1/DOM_BPE_IBAN
ReferenceAccountNumber Ordering Party Account Number /PF1/DOM_BPE_ACCT
ReferenceAccountHolder Reference Account Holder /PF1/DOM_BPE_HOLDERNAME
ReferenceClrSysIdCd Clearing System Member ID Code /PF1/DOM_PO_CLRSYSMMBIDCD
ReferenceValutaId Value Date Agreement ID /PF1/DOM_BPE_GENERAL_ID
ReferenceRulesetId Rule Set ID of Value Date Agreement /PF1/DOM_RP_RULESET_ID
ExchangeRate Exchange Rate /PF1/DOM_PO_ITEM_EXCHANGERATE
ChequeNumber Check Number /PF1/DOM_BPE_CHEQUE_NO
FlagEvStatus Execution Status of Each Check /PF1/DOM_PO_FLG_CHK_EV_STATUS
EVId Incoming Check Set ID for Payment Item E&V /PF1/DOM_BPE_PMNT_ITEM_EV_ID
ItemGroup ORP/RCP item group reference /PF1/DOM_PO_ORP_SPLIT_REF
FlagEvStatusOPO Execution Status of Each Check /PF1/DOM_PO_FLG_CHK_EV_STATUS
EVIdOPO Outgoing Check Set ID for Payment Item E&V /PF1/DOM_BPE_PMNT_ITEM_EV_ID
AccountHolderId Business Partner Number /PF1/BCA_BUPA_PARTNER
RiskScore Risk Score
ReferenceRecallNumber Payment Recall Number /PF1/DOM_RECALL_ID
MandateId Mandate Identification /PF1/DOM_PO_MANDATE_ID
UCI Creditor ID /PF1/DOM_UCI
EndToEndId Ordering Party Reference (Unique Number for ISO Payment) /PF1/DOM_PO_PI_REF_ORDPARTY
CostCenter Cost Center KOSTL
BusinessArea Business Area GSBER
TechPriority Payment Item Technical Priority /PF1/DOM_PO_TECHNICAL_PRIORITY
CreateUserId Creating User USNAM
ChangeUserId Last User Change USNAM
ReleaseUserId User Who Released Object USNAM
CreateUserName Create User Name /PF1/DOM_UI_USER_NAME
Master Data Relations Join Conditions
Account Currency After Substitution
  • Client
  • Account Currency After Substitution
  • /PF1/C_BATCH_ITEMS.MANDT == TCURC.MANDT
  • /PF1/C_BATCH_ITEMS.ACCOUNTCURRENCY == TCURC.WAERS
Foreign Key for Account-Managing Unit
  • Client
  • Clearing Area
  • Account Managing Area
Clearing Agreement ID
  • ?
  • Clearing Agreement ID
  • Client
  • Route ID
  • /PF1/C_BATCH_ITEMS.[column in domain "/PF1/DTE_BPE_CLEARING_ID"] == /PF1/DB_CA.CLEARING_ID
  • /PF1/C_BATCH_ITEMS.CLEARINGAGREEMENT == /PF1/DB_CA.ROUTE_ID
  • /PF1/C_BATCH_ITEMS.MANDT == /PF1/DB_CA.CLIENT
  • /PF1/C_BATCH_ITEMS.ROUTE == /PF1/DB_CA.CLEARING_AREA
Foreign Key for Clearing Area /PF1/C_BATCH_ITEMS.MANDT == /PF1/T_CLAREA.MANDT
Bank Country/Region
  • Bank Country/Region
  • Client
  • /PF1/C_BATCH_ITEMS.COUNTRY == T005.LAND1
  • /PF1/C_BATCH_ITEMS.MANDT == T005.MANDT
Foreing Key for Original Currency
  • Client
  • Original Currency
  • /PF1/C_BATCH_ITEMS.MANDT == TCURC.MANDT
  • /PF1/C_BATCH_ITEMS.ORIGINALCURRENCY == TCURC.WAERS
Creation Process of Payment Object /PF1/C_BATCH_ITEMS.PROCESS == /PF1/T_PROCESS.PROCESS
Ordering Party Account Currency
  • Client
  • Ordering Party Account Currency
  • /PF1/C_BATCH_ITEMS.MANDT == TCURC.MANDT
  • /PF1/C_BATCH_ITEMS.REFERENCEACCOUNTCURRENCY == TCURC.WAERS
Ordering Party Bank Country/Region
  • Client
  • Ordering Party Bank Country/Region
  • /PF1/C_BATCH_ITEMS.MANDT == T005.MANDT
  • /PF1/C_BATCH_ITEMS.REFERENCECOUNTRY == T005.LAND1
Return/Rejection Reason
  • Client
  • Return/Rejection Reason
Route ID
  • ?
  • Client
  • Route ID
Transaction Currency
  • Client
  • Transaction Currency
  • /PF1/C_BATCH_ITEMS.MANDT == TCURC.MANDT
  • /PF1/C_BATCH_ITEMS.TRANSACTIONCURRENCY == TCURC.WAERS
Foreign Key: Transaction Type
  • ?
  • Transaction Type (Advanced Payment Management)
  • Client