R_AccountsPayablesItem

AP Operational Item | view: RFIAPITEM | Extraction: Not supported | Component: Information System
Tables used: VBKPF, VBSEGK, VBSEGD, BSAD_BCK, BSAK_BCK, BKPF, BSEG, T003, ADCP, ADRC, T001, TKA02, T005, FINSC_CURTYPET, T053R, TTYPT, T005U, T000, LFA1, LFB1, T007A, FITHA_PBUPL_K, FITHA_PBUPL_K_T, T016T, T001A, T880, T014
Column Name Description
CompanyCode Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Posting View Item
Column Name Description
💲 Additional Currency 1 (AdditionalCurrency1):
AmountInAdditionalCurrency1 Amount in Additional Currency 1
ValuatedAmtInAdditionalCrcy1 Valuated Amount in Additional Currency 1
💲 Additional Currency 2 (AdditionalCurrency2):
AmountInAdditionalCurrency2 Amount in Additional Currency 2
ValuatedAmtInAdditionalCrcy2 Valuated Amount in Additional Currency 2
💲 Update Currency for General Ledger Transaction Figures (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount for Updating in General Ledger
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
CashDiscountAmtInCoCodeCrcy Cash Discount Taken (Company Code Currency)
ValuatedAmtInCompanyCodeCrcy Valuated Amount in Company Code Currency
InterestToBePosted Imputed Interest (Days in Arrears * Amount)
💲 Currency for Automatic Payment (PaymentCurrency):
AmountInPaymentCurrency Amount in Payment Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
CashDiscountAmount Cash Discount Taken (Transaction Currency)
CashDiscountBaseAmount Amount Eligible for Cash Discount in Document Currency
HedgedAmount Credit Management: Hedged Amount
PlannedAmtInTransactionCrcy Planned Amount in Document or G/L Account Currency
WithholdingTaxAmount Withholding Tax
WithholdingTaxBaseAmount Withholding Tax Base Amount
WithholdingTaxExemptionAmt Withholding Tax-Exempt Amount (in Document Currency)
CashDiscountAmtInTransacCrcy Cash Discount Available Now (Transaction Currency)
Column Name Description
Column Name Description
ClearingDate Clearing Date
TaxReportingDate Tax Reporting Date
ValueDate Value date
DueCalculationBaseDate Baseline Date for Due Date Calculation
LastDunningDate Date of Last Dunning Notice
SettlementReferenceDate Reference Date for Settlement
PostingDate Posting Date
DocumentDate Journal Entry Date
NetDueDate Due Date for Net Payment
CashDiscount1DueDate Due Date for Cash Discount 1
AccountingDocumentCreationDate Accounting Document Entry Date
SupplierCreationDate Date on which the supplier was created
InterestCalculationDate Key Date of Last Interest Calculation
KeyDate Key Date
Column Name Description
FinancialAccountType Account Type Show values
MixedAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
IsUsedInPaymentTransaction Is Used In Payment Transaction Show values
FixedCashDiscount Fixed Payment Terms Show values
BillOfExchangeUsage Bill of Exchange Usage Type Show values
DunningLevel Dunning Level Show values
TreasuryContractType Treasury Contract Type Show values
ClearingIsReversed Indicator: Clearing was Reversed Show values
HasPaymentOrder Indicator: Payment Order Exists for this Item Show values
IsSalesRelated Indicator: Sales-Related Item Show values
AccountingDocumentCategory Document Status Show values
SupplierIsOneTimeAccount Indicator: Is the Account a One-Time Account Show values
AlternativePayeeIsAllowed Indicator: Alternative Payee in Document Allowed Show values
PostingIsBlockedForSupplier Indicator: Central Posting Block Show values
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months Show values
ItemIsToBePaidSeparately Indicator: Pay All Items Separately? Show values
PaymentIsToBeSentByEDI Indicator: Send Payment Advices by EDI Show values
IsDisputed Indicator: Disputed item Show values
IsCleared Truth Value: True/False Show values
OffsettingAccountType Offsetting Account Type Show values
DocumentIsArchived Indicator: Has the Document Been Archived Show values
CashDiscount1DueStatus Line Item Cash Discount 1 Is Due Show values
NetDueStatus Line Item Is Due Net Show values
CashDiscount1IsDue Indicator: Cash Discount Term 1 Is Due on Item Show values
IsClearedAtKeyDate Indicator: Has the Item Been Cleared? Show values
IsDueNet Indicator: Item is due net Show values
ClearingStatus Clearing Status of Item Show values
IsNegativePosting Indicator: Negative Posting Show values
Column Name Description Domain name
PaymentDifferenceReason Reason Code for Payments RSTGR
Supplier Supplier LIFNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
ClearingAccountingDocument Clearing Journal Entry BELNR
PostingKey Posting Key BSCHL
SpecialGLCode Special G/L Indicator UMSKZ
SpecialGLTransactionType Special G/L Transaction Type UMSKS
BusinessArea Business Area GSBER
TaxCode Sales/Purchases Tax Code MWSKZ
TaxCountry Tax Reporting Country/Region LAND1
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
PartnerCompany Company ID of Trading Partner RCOMP
CostCenter Cost Center KOSTL
OrderID Order ID AUFNR
BillingDocument Sales and Distribution Document Number VBELN
SalesDocument Sales Document VBELN
SalesDocumentItem Item Number (6 Digits) POSNR
ScheduleLine Schedule Line ETENR
MasterFixedAsset Fixed Asset ANLN1
FixedAsset Asset Subnumber ANLN2
GLAccount G/L Account SAKNR
BranchAccount Account Number of the Branch MAXKK
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Days Cash Discount Days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
PaymentMethod Payment Method ZLSCH
PaymentBlockingReason Payment Block on Item ZAHLS
FollowOnDocumentType Follow-On Document Type REBZT
InvoiceList Collective Invoice List Number SAMNR
DunningKey Dunning Key MSCHL
DunningBlockingReason Dunning Block MANSP
DunningArea Dunning Area MABER
Plant Plant WERKS
PurchasingDocument Purchasing Document EBELN
PurchasingDocumentItem Item Number of Purchasing Document EBELP
ProfitCenter Profit Center PRCTR
AssetContract Asset Contract RANL
CashFlowType Flow Type SBEWART
PaymentMethodSupplement Payment Method Supplement UZAWE
Reference1IDByBusinessPartner Business Partner Reference Key 1 CHAR12
Reference2IDByBusinessPartner Business Partner Reference Key 2 CHAR12
PaymentCardItem Payment Card Item NUM03
PaymentCardPaymentSettlement Payment Cards: Settlement Run CCBTC
Reference3IDByBusinessPartner Reference Key for Line Item CHAR20
DataExchangeInstruction1 Instruction Key 1 DTWSX
DataExchangeInstruction2 Instruction Key 2 DTWSX
DataExchangeInstruction3 Instruction Key 3 DTWSX
DataExchangeInstruction4 Instruction Key 4 DTWSX
PaymentReference Payment Reference CHAR30
BusinessPlace Business Place J_1BBRANCH
TaxSection Tax Section SECCO
FundsCenter Funds Management Center FISTL
FiscalPeriod Fiscal Period POPER
AccountingDocumentType Journal Entry Type BLART
DocumentReferenceID Reference Document Number XBLNR
AccountingDocCreatedByUser User that created the journal entry
DueItemType Due Item Category FARP_DUE_ITEM_CATEGORY
SupplierIndustryName Name of Industry (Supplier) TEXT20
SupplierSearchText Search Term CHAR10
SupplierVATRegistration VAT Registration Number STCEG
SupplierBasicAuthorizationGrp Authorization Group BRGRU
SupplierFinsAuthorizationGrp Authorization Group BRGRU
SupplierCorporateGroup Corporate Group Key KONZS
SupplierName Supplier Name TEXT80
SupplierCityName City TEXT40
SupplierPOBox PO Box CHAR10
SupplierPOBoxPostalCode PO Box Postal Code CHAR10
SupplierPostalCode City postal code CHAR10
SupplierRegionName Supplier Region Name TEXT20
SupplierCreatedByUser User that created the supplier USNAM
HouseBank House Bank Key HBKID
SupplierAccountNote Memo TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
CreditControlArea Credit Control Area KKBER
PayableAlternativePayee Account number of the alternative payee in invoice MAXKK
NetDueArrearsDays Days in Arrears by Net Due Date WRTV3
CashDiscount1ArrearsDays Days in Arrears for Cash Discount Terms 1 WRTV3
OffsettingAccount Offsetting Account GKONT
AcctgDocTypeAuthorizationGroup Authorization Group BRGRU
BPBankAccountInternalID Business Partner Bank Account Internal ID BVTYP
SenderLogicalSystem Sender Logical System LOGSYS
SenderCompanyCode Company Code in Sender System CHAR4
SenderAccountingDocument Sender Journal Entry BELNR
SenderFiscalYear Fiscal Year of an Accounting Document in the Sender System GJAHR
Debtor Customer KUNNR
AdditionalCurrency1Role Additional Currency 1 Role (Currency Type) FINS_CURTYPE
AdditionalCurrency2Role Additional Currency 2 Role (Currency Type) FINS_CURTYPE
AdditionalCurrency1RoleName Additional Currency 1 Role Name TEXT60
AdditionalCurrency2RoleName Additional Currency 2 Role Name TEXT60
BranchCode Branch Code BCODE
TH_BranchCodeDescription Branch Code Description FITH_DESC
ReferenceDocumentType Reference Document Type AWTYP
ReferenceDocumentTypeName Reference Document Type Name TEXT20
OriginalReferenceDocument Original Reference Document AWKEY
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
Master Data Relations Join Conditions
Accounting Clerk
  • Accounting Clerk
  • ?
  • Client
  • R_ACCOUNTSPAYABLESITEM.ACCOUNTINGCLERK == T001S.BUSAB
  • R_ACCOUNTSPAYABLESITEM.[column in domain "BUKRS"] == T001S.BUKRS
  • R_ACCOUNTSPAYABLESITEM.MANDT == T001S.MANDT
Account number of the alternative payee
  • Account number of the alternative payee
  • Client
  • R_ACCOUNTSPAYABLESITEM.ALTERNATIVEPAYEE == LFA1.LIFNR
  • R_ACCOUNTSPAYABLESITEM.MANDT == LFA1.MANDT
Tolerance Group for Business Partner/G/L Account
  • Tolerance Group for Business Partner/G/L Account
  • ?
  • Client
  • R_ACCOUNTSPAYABLESITEM.APARTOLERANCEGROUP == T043G.TOGRU
  • R_ACCOUNTSPAYABLESITEM.[column in domain "BUKRS"] == T043G.BUKRS
  • R_ACCOUNTSPAYABLESITEM.MANDT == T043G.MANDT
Interest Indicator
  • Client
  • Interest Indicator
  • R_ACCOUNTSPAYABLESITEM.MANDT == T056.MANDT
  • R_ACCOUNTSPAYABLESITEM.INTERESTCALCULATIONCODE == T056.VZSKZ
Reconciliation Account in General Ledger
  • Reconciliation Account in General Ledger
  • ?
  • Client
  • R_ACCOUNTSPAYABLESITEM.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • R_ACCOUNTSPAYABLESITEM.[column in domain "BUKRS"] == SKB1.BUKRS
  • R_ACCOUNTSPAYABLESITEM.MANDT == SKB1.MANDT
Supplier Account Group
  • Supplier Account Group
  • Client
  • R_ACCOUNTSPAYABLESITEM.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • R_ACCOUNTSPAYABLESITEM.MANDT == T077K.MANDT
Country key
  • Client
  • Country / Region Key
  • R_ACCOUNTSPAYABLESITEM.MANDT == T005.MANDT
  • R_ACCOUNTSPAYABLESITEM.SUPPLIERCOUNTRY == T005.LAND1
Head office account number
  • Head office account number
  • Client
  • R_ACCOUNTSPAYABLESITEM.SUPPLIERHEADOFFICE == LFA1.LIFNR
  • R_ACCOUNTSPAYABLESITEM.MANDT == LFA1.MANDT
Industry Key (Supplier)
  • Industry Key (Supplier)
  • Client
  • R_ACCOUNTSPAYABLESITEM.SUPPLIERINDUSTRY == T016.BRSCH
  • R_ACCOUNTSPAYABLESITEM.MANDT == T016.MANDT
Payment Block on Supplier
  • Client
  • Payment Block on Supplier
  • R_ACCOUNTSPAYABLESITEM.MANDT == T008.MANDT
  • R_ACCOUNTSPAYABLESITEM.SUPPLIERPAYMENTBLOCKINGREASON == T008.ZAHLS
Region code
  • Client
  • Country / Region Key
  • Supplier Region
  • R_ACCOUNTSPAYABLESITEM.MANDT == T005S.MANDT
  • R_ACCOUNTSPAYABLESITEM.SUPPLIERCOUNTRY == T005S.LAND1
  • R_ACCOUNTSPAYABLESITEM.SUPPLIERREGION == T005S.BLAND
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • Client
  • R_ACCOUNTSPAYABLESITEM.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • R_ACCOUNTSPAYABLESITEM.SUPPLIERTAXJURISDICTION == TTXJ.TXJCD
  • R_ACCOUNTSPAYABLESITEM.MANDT == TTXJ.MANDT
Tax Code
  • Client
  • ?
  • Target Tax Code (for Deferred Tax)
  • R_ACCOUNTSPAYABLESITEM.MANDT == T007A.MANDT
  • R_ACCOUNTSPAYABLESITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • R_ACCOUNTSPAYABLESITEM.TARGETTAXCODE == T007A.MWSKZ