/PF1/C_PAYMENT_ITEM_ANALYZER

Payment Analyzer for Payment Items | view: /PF1/CV_PI_ANLYZ | Extraction: Not supported | Component: Payment Factory
Tables used: /PF1/DB_ORDER, /PF1/DB_ITEM, /PF1/T_TRNSTYPET, /PF1/DB_EH_FCHCK, /PF1/T_POTYPE, /PF1/T_POTYPET, BNKA, /PF1/DB_EXT_STAT, FCLM_BAM_ACLINK2, FCLM_BAM_AMD, FCLM_BAM_AMD_T, FCLM_BAM_ACLINK2, FCLM_BAM_AMD, T005, T005T, TIBAN, /PF1/T_TRANSTYPE, /PF1/T_ISO_CODE, /PF1/TS_STATET
Column Name Description
PaymentItemGuid UI Object ID
Column Name Description
💲 Transaction Currency (TransactionCurrency):
TransactionAmount Amount in Transaction Currency
💲 Display Currency (DisplayCurrency):
TransactionAmountInDispCur Amount in Display Currency
💲 Release Currency (ReleaseCurrency):
ReleaseAmount Amount Calculated for Release
Column Name Description
Column Name Description
PaymentItemDate Payment Item Date
DueDate Due Date Specified by Ordering Party
CreateDate Creation Date
ChangeDate Change Date
ReleaseDate Release Date
PaymentOrderDate Payment Order Date
ProcessingDate Order Processing Date in Advanced Payment Mgmt
POCreateDate Payment Order Create Date
Column Name Description
PaymentItemKind Payment Item Category Show values
IsInRepair Is in Repair Flag Show values
IsBlocked Is Blocked Flag Show values
OrderPriority Order Priority Show values
PaymentScenario Payment Scenario Description 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
TechnicalStatus Processing Status of Payment Item /PF1/DOM_BPE_SC_STATE_ID
ReleaseStatusLabel Release Status
ReleaseStatus null
ReleaseStatusDesc Short Text for Fixed Values DDTEXT
TransactionTypeDesc Transaction Type Description /PF1/DOM_DESCRIPTION_LONG
ExchangeRateType null
TechnicalStatusDesc Status Description /PF1/DOM_BPE_SC_STATE_KIND_DES
IsInRepairDesc Short Text for Fixed Values DDTEXT
PaymentItemAmount Number of Payment Items
IsBlockedDesc Short Text for Fixed Values DDTEXT
IncomingPaymentOrderNumber Reference to Incoming Payment Order /PF1/DOM_PO_PO_ID
HouseBankAccountId House Bank Account ID
CompanyCode House Bank Company Code
ExternalStatusItem External Status Identifier
ExternalStatusItemDesc ISO Code Name /PF1/DOM_FH_ISO_CODE_NAME
PaymentOrderGuid UI Object ID /PF1/DOM_UI_OBJECT_ID
PaymentOrderKey Payment Order Key /PF1/DOM_UI_KEY
PaymentOrderNumber Payment Order Number /PF1/DOM_PO_PO_ID
POTechnicalStatus Technical Status of Payment Order /PF1/DOM_BPE_SC_STATE_ID
ExternalStatus External Status Identifier
ExternalStatusDesc ISO Code Name /PF1/DOM_FH_ISO_CODE_NAME
PaymentOrderTypeDesc Short Description of Payment Order Type /PF1/DOM_DESCRIPTION_SHORT
InternalSenderIBAN IBAN (Internal Sender)
InternalSenderAccount Account Number (Internal Sender)
InternalSenderAccountHolder Sender Name
InternalSenderReference Reference (Internal Sender)
PaymentScenarioDesc Payment Scenario Description DDTEXT
ReceiverBankKey Bank Key
ReceiverBIC Bank Identifier Code (BIC)
ReceiverName Substitute Account Holder Name
ReceiverIBAN IBAN After Account Substitution
ReceiverAccountNumber Account Number
ExternalReferencePaymentOrder External Payment Order Number
CustomerSegment Customer Segment /PF1/DOM_BPE_CUST_SGM
POReleaseStatus Release Status
POReleaseStatusDesc Release Status Description
POChangeUserId Last User Change USNAM
DateIdentifier null
CreatedToday Truth Value: True/False
Master Data Relations Join Conditions
Bank Account ID
  • ?
  • Bank Account ID
  • Client
  • /PF1/C_PAYMENT_ITEM_ANALYZER.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
  • /PF1/C_PAYMENT_ITEM_ANALYZER.BANKACCOUNTMANAGEMENTID == FCLM_BAM_AMD.ACC_ID
  • /PF1/C_PAYMENT_ITEM_ANALYZER.MANDT == FCLM_BAM_AMD.MANDT
Channel
  • Client
  • ?
  • Channel
  • /PF1/C_PAYMENT_ITEM_ANALYZER.MANDT == /PF1/T_CHANNEL.MANDT
  • /PF1/C_PAYMENT_ITEM_ANALYZER.[column in domain "/PF1/DTE_BPE_CLEARING_AREA"] == /PF1/T_CHANNEL.CLEARING_AREA
  • /PF1/C_PAYMENT_ITEM_ANALYZER.CHANNEL == /PF1/T_CHANNEL.CHANNEL
Foreign Key for Clearing Area /PF1/C_PAYMENT_ITEM_ANALYZER.MANDT == /PF1/T_CLAREA.MANDT
House Bank Key
  • ?
  • House Bank Key
  • Client
  • /PF1/C_PAYMENT_ITEM_ANALYZER.[column in domain "BANKS"] == BNKA.BANKS
  • /PF1/C_PAYMENT_ITEM_ANALYZER.HOUSEBANKKEY == BNKA.BANKL
  • /PF1/C_PAYMENT_ITEM_ANALYZER.MANDT == BNKA.MANDT
Foreign Key: Format
  • Client
  • Format
  • /PF1/C_PAYMENT_ITEM_ANALYZER.MANDT == /PF1/T_FORMAT.MANDT
  • /PF1/C_PAYMENT_ITEM_ANALYZER.INOUTFORMAT == /PF1/T_FORMAT.IN_OUT_FORMAT
Bank Country/Region (Internal Sender)
  • Client
  • Bank Country/Region (Internal Sender)
  • /PF1/C_PAYMENT_ITEM_ANALYZER.MANDT == T005.MANDT
  • /PF1/C_PAYMENT_ITEM_ANALYZER.INTERNALSENDERCOUNTRY == T005.LAND1
Foreign Key: Medium
  • Client
  • Medium
Foreign Key: Payment Order Type
  • Client
  • Payment Order Type
  • /PF1/C_PAYMENT_ITEM_ANALYZER.MANDT == /PF1/T_POTYPE.MANDT
  • /PF1/C_PAYMENT_ITEM_ANALYZER.PAYMENTORDERTYPE == /PF1/T_POTYPE.CLEARING_AREA
Account Currency After Substitution
  • Account Currency After Substitution
  • Client
  • /PF1/C_PAYMENT_ITEM_ANALYZER.RECEIVERACCOUNTCURRENCY == TCURC.WAERS
  • /PF1/C_PAYMENT_ITEM_ANALYZER.MANDT == TCURC.MANDT
Bank Country/Region
  • Client
  • Bank Country/Region
  • /PF1/C_PAYMENT_ITEM_ANALYZER.MANDT == T005.MANDT
  • /PF1/C_PAYMENT_ITEM_ANALYZER.RECEIVERCOUNTRY == T005.LAND1
Transaction Currency
  • Client
  • Transaction Currency
  • /PF1/C_PAYMENT_ITEM_ANALYZER.MANDT == TCURC.MANDT
  • /PF1/C_PAYMENT_ITEM_ANALYZER.TRANSACTIONCURRENCY == TCURC.WAERS
Foreign Key: Transaction Type
  • Client
  • ?
  • Transaction Type (Advanced Payment Management)
  • /PF1/C_PAYMENT_ITEM_ANALYZER.MANDT == /PF1/T_TRANSTYPE.MANDT
  • /PF1/C_PAYMENT_ITEM_ANALYZER.[column in domain "/PF1/DTE_BPE_CLEARING_AREA"] == /PF1/T_TRANSTYPE.CLEARING_AREA
  • /PF1/C_PAYMENT_ITEM_ANALYZER.TRANSACTIONTYPE == /PF1/T_TRANSTYPE.TRANS_TYPE