/PF1/C_DB_COLLECT_TP

Column Name Description
PaymentBatchGuid Globally Unique Identifier
Column Name Description
💲 Transaction Currency (TotalAmountCurrency):
TotalAmount Total Amount
TotalAmountCalculated Total Amount
Column Name Description
Column Name Description
PaymentBatchDate Payment Batch Date
CloseDate Date
CloseTime Time
CheckDate Date of Last Specified Clearing Time Check
CheckTime Time of Last Specified Clearing Time Check
OutgoingPaymentOrderDate Payment Order Date
CreateDate Creation Date
CreateTime Creation Time
ChangeUserDate Change Date
ChangeUserTime Changed Time
ReleaseUserDate Release Date
ReleaseUserTime Release Time
Column Name Description
Direction Payment Batch Direction Show values
PaymentBatchType Collection Type Show values
BatchStatus Payment Batch Status Show values
CloseReason Reason for Closing Payment Batch Show values
ReassignActionEnabled Reassign Enabled Show values
ProcessActionEnabled Process Button Enabled Show values
AssignAllActionEnabled 'Assign All' Enabled Show values
ItemReprocessingOption Reprocessing Option for Batched Payment Items Show values
Column Name Description Domain name
PaymentBatchKey Payment Batch Key /PF1/DOM_UI_KEY
PaymentBatchNumber Payment Batch Number from Number Range (Secondary Key) /PF1/DOM_CP_CO_SECONDARY_KEY
SequenceNumber Sequence Number of Payment Batch /PF1/DOM_CP_SEQUENCE_NO
DirectionDesc Short Text for Fixed Values DDTEXT
PaymentBatchTypeDesc Payment Batch Type Description DDTEXT
RouteId Route ID /PF1/DOM_BPE_GENERAL_ID
RouteDesc Route Description /PF1/DOM_BPE_ROUTE_NAME
ClearingAgreementId Clearing Agreement ID /PF1/DOM_BPE_GENERAL_ID
ClearingAgreementDesc Clearing Agreement Description /PF1/DOM_BPE_CLEARING_NAME
CompanyCode Company Code BUKRS
CompanyCodeDesc Name of Company Code or Company TEXT25
BatchStatusCriticality null
BatchStatusDesc Technical Status Description DDTEXT
NextClosingTime Next Closing Time
CloseUserId Batch Closed By /PF1/DOM_CP_CLOSE_USER
ClosedAt Closed At
CloseReasonDesc Close Reason DDTEXT
LastChecked Last Checked
AccountCompanyCode Company Code
AccountNumber Account Number /PF1/DOM_BPE_ACCT
AccountCountry Bank Country/Region LAND1
AccountBankKey Bank Key BANKK
AccountIban International Bank Account Number (IBAN) /PF1/DOM_BPE_IBAN
AccountHolder Account Holder Name /PF1/DOM_BPE_HOLDERNAME
AccountBic Bank Identifier Code (BIC) /PF1/DOM_BPE_BIC
ClearingAccountNumber Account Number for Account at Route
ClearingAccountCountry Bank Country/Region for Account at Route
ClearingAccountBankKey Bank Key for Account at Route
ClearingAccountIban IBAN for Account at Route
ClearingAccountHolder Account Holder for Account at Route
TotalNumberOfItems Number of Items
TotalNumberOfItemsCalculated Number of Items
NumberOfUnassignedItems Number of Items
OutgoingPaymentOrderNumber Payment Order Number From Number Range /PF1/DOM_PO_PO_ID
OutgoingPaymentOrderGuid Reference Output Order /PF1/DOM_UI_OBJECT_ID
OutgoingPaymentOrderKey Output Order Key /PF1/DOM_UI_KEY
OutgoingPaymentOrderTypeDesc Short Description of Payment Order Type /PF1/DOM_DESCRIPTION_SHORT
OutgoingPaymentOrderFormatDesc Description Format (Long) /PF1/DOM_DESCRIPTION_LONG
CreateUserId Creating User USNAM
ChangeUserId Last User Change USNAM
ReleaseUserId User Who Released Object USNAM
NewClearingAgreementId Clearing Agreement ID
NewRouteId Route ID
ClearingAgreementCompanyCode Company Code
Master Data Relations Join Conditions
Bank Account Technical ID
  • ?
  • Client
  • Bank Account Technical ID
  • /PF1/C_DB_COLLECT_TP.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
  • /PF1/C_DB_COLLECT_TP.MANDT == FCLM_BAM_AMD.MANDT
  • /PF1/C_DB_COLLECT_TP.BAMACCOUNTID == FCLM_BAM_AMD.ACC_ID
Check Table for Clearing Area /PF1/C_DB_COLLECT_TP.MANDT == /PF1/T_CLAREA.MANDT
Foreign Key: Format
  • Client
  • Format
Foreign Key: Payment Order Type
  • Client
  • Payment Order Type
Transaction Currency
  • Transaction Currency
  • Client
  • /PF1/C_DB_COLLECT_TP.TOTALAMOUNTCALCULATEDCURRENCY == TCURC.WAERS
  • /PF1/C_DB_COLLECT_TP.MANDT == TCURC.MANDT