P_ReceivablesItem1

Receivables Item with credit segment | view: PFIRECITEM1 | Extraction: Not supported | Component: Information System
Tables used: BSEG, T001, TKA02, T014
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
TaxAmountInCoCodeCrcy Signed Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Company Code Currency
ValuationDiffAmtInCoCodeCrcy Valuation Difference Amount In Company Code Currency
CashDiscountAmtInCoCodeCrcy Cash Discount Amount in Company Code Currency
InvoiceAmtInCoCodeCrcy Invoice Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
TaxAmount Tax Amount in Transaction Currency
TaxBaseAmountInTransCrcy Tax Base Amount in Transaction Currency
WithholdingTaxBaseAmount Withholding Tax Base Amount
PlannedAmtInTransactionCrcy Planned Amount in Transaction Currency
CashDiscountBaseAmount Cash Discount Base Amount
CashDiscountAmount Cash Discount Amount
WithholdingTaxAmount Withholding Tax Amount
WithholdingTaxExemptionAmt Withholding Tax-Exemption Amount
InvoiceAmountInFrgnCurrency Invoice Amount in Foreign Currency
HedgedAmount Credit Management: Hedged Amount
💲 Update Currency for General Ledger Transaction Figures (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Additional Currency 1 (AdditionalCurrency1):
ValuationDiffAmtInAddlCrcy1 Valuation Difference Amount in Additional Currency 1
AmountInAdditionalCurrency1 Amount in Additional Currency 1
💲 Additional Currency 2 (AdditionalCurrency2):
AmountInAdditionalCurrency2 Amount in Additional Currency 2
ValuationDiffAmtInAddlCrcy2 Valuation Difference Amount in Additional Currency 2
💲 Currency for Automatic Payment (PaymentCurrency):
AmountInPaymentCurrency Amount in Payment Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
📏 Unit of entry (EntryUnit):
QuantityInEntryUnit Quantity in Entry Unit
📏 Order Price Unit (Purchasing) (PurchaseOrderPriceUnit):
PurchaseOrderQty Purchase Order Quantity
Column Name Description
ClearingDate Clearing Date
ClearingCreationDate Clearing Creation Date
ValueDate Value date
DueCalculationBaseDate Due Calculation Base Date
LastDunningDate Date of Last Dunning Notice
SettlementReferenceDate Reference Date for Settlement
TaxDeterminationDate Date for Determination of Tax Rates
PostingDate Posting Date
DocumentDate Journal Entry Date
NetDueDate Due Date for Net Payment
CashDiscount1DueDate Due Date for Cash Discount 1
CashDiscount2DueDate Cash Discount 2 Due Date
Column Name Description
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
TaxType Tax Type Show values
IsSalesRelated Indicator: Sales-Related Item Show values
LineItemDisplayIsEnabled Indicator: Can Line Items Be Displayed by Account? Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
AddressAndBankIsSetManually Indicator: Address and Bank Data Set Individually Show values
IsAutomaticallyCreated Is Automatically Created Show values
IsUsedInPaymentTransaction Is Used In Payment Transaction Show values
IsBalanceSheetAccount Is Balance Sheet Account Show values
FixedCashDiscount Fixed Payment Terms Show values
BillOfExchangeUsage Bill of Exchange Usage Type Show values
IsCompletelyDelivered Is completely delivered Show values
MaterialPriceControl Price control indicator Show values
TreasuryContractType Treasury Contract Type Show values
IsEUTriangularDeal Is EU Triangular Deal Show values
ClearingIsReversed Indicator: Clearing was Reversed Show values
HasPaymentOrder Indicator: Payment Order Exists for this Item Show values
CustomerIsInExecution Customer Is In Execution Show values
AccountingDocumentCategory Document Status Show values
OffsettingAccountType Offsetting Account Type Show values
Column Name Description Domain name
DisputeCaseObjectKey Object key SWO_TYPEID
ClearingAccountingDocument Clearing Document Number BELNR
SpecialGLTransactionType Special G/L Transaction Type UMSKS
TaxItemGroup Group Indicator for Tax Line Items NUM03
TransactionTypeDetermination Transaction Key CHAR3
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
CorporateGroupAccount Corporate Group Account SAKNR
CostCenter Cost Center KOSTL
WBSElementInternalID Project definition PS_PSPID
BillingDocument Billing Document VBELN
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
Employee Personnel Number PERNR
Branch Account Number of the Branch MAXKK
ProfitLossAccountType Profit Loss Account Type CHAR2
SpecialGLAccountAssignment Assignment Number for Special G/L Accounts ZUONR
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
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
InvoiceReferenceFiscalYear Fiscal Year GJAHR
InvoiceItemReference Line Item BUZEI
FollowOnDocumentType Follow-On Document Type REBZT
InvoiceList Collective Invoice List Number SAMNR
SettlementFiscalYearPeriod Settlement Period BUPER
DunningLevel Dunning Level MAHNS
AccountAssignmentNumber Sequential Number of Account Assignment NUM02
MaterialPriceUnitQty Price unit PACK3
VATRegistration VAT Registration Number STCEG
ProfitCenter Profit Center PRCTR
AssetContract Asset Contract RANL
CashFlowType Flow Type SBEWART
RealEstateObject Internal Key for Real Estate Object IMKEY
CommitmentItem Commitment Item FIPOS
CostObject Cost Object KSTRG
ProjectNetwork Network Number for Account Assignment AUFNR
WBSElement WBS Element PS_POSNR
ProfitabilitySegment Profitability Segment Number (CO-PA) RKEOBJNR
CostOriginGroup Origin Group as Subdivision of Cost Element HRKFT
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
FundsCenter Funds Management Center FISTL
Fund Fund BP_GEBER
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 ID of Reference 3 by Business Partner 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
ClearingItem Clearing Item AGZEI
CostCtrActivityType Activity Type LSTAR
BusinessProcess Business Process CO_PRZNR
GrantID Grant GM_GRANT_NBR
FunctionalArea Functional Area FKBER
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
Segment Segment for Segmental Reporting FB_SEGMENT
PartnerSegment Partner Segment for Segmental Reporting FB_SEGMENT
PartnerFunctionalArea Partner Functional Area FKBER
CostElement Cost Element KSTAR
ReferenceDocumentType Reference Document Type AWTYP
OriginalReferenceDocument Original Reference Document AWKEY
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
FiscalPeriod Fiscal Period POPER
OffsettingAccount Offsetting Account GKONT
PartnerFund Partner Fund BP_GEBER
PartnerGrant Partner Grant GM_GRANT_NBR
BudgetPeriod Budget Period FM_BUDGET_PERIOD
PartnerBudgetPeriod FM: Partner Budget Period FM_BUDGET_PERIOD
BPBankAccountInternalID Business Partner Bank Account Internal ID BVTYP
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_RECEIVABLESITEM1.MANDT == T003.MANDT
  • P_RECEIVABLESITEM1.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Accounts Receivable Pledging Indicator
  • Client
  • Company Code
  • Accounts Receivable Pledging Indicator
  • P_RECEIVABLESITEM1.MANDT == TCESSION.CLIENT
  • P_RECEIVABLESITEM1.COMPANYCODE == TCESSION.COMPANY
  • P_RECEIVABLESITEM1.ACCOUNTSRECEIVABLEISPLEDGED == TCESSION.CESSION_KZ
Transaction Type
  • Client
  • Transaction Type
  • P_RECEIVABLESITEM1.MANDT == TABW.MANDT
  • P_RECEIVABLESITEM1.ASSETTRANSACTIONTYPE == TABW.BWASL
Update Currency for General Ledger Transaction Figures
  • Client
  • Update Currency for General Ledger Transaction Figures
  • P_RECEIVABLESITEM1.MANDT == TCURC.MANDT
  • P_RECEIVABLESITEM1.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_RECEIVABLESITEM1.MANDT == T006.MANDT
  • P_RECEIVABLESITEM1.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • P_RECEIVABLESITEM1.MANDT == TGSB.MANDT
  • P_RECEIVABLESITEM1.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • P_RECEIVABLESITEM1.MANDT == T001.MANDT
  • P_RECEIVABLESITEM1.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • P_RECEIVABLESITEM1.CONTROLLINGAREA == TKA01.KOKRS
  • P_RECEIVABLESITEM1.MANDT == TKA01.MANDT
Credit Control Area
  • Credit Control Area
  • Client
  • P_RECEIVABLESITEM1.CREDITCONTROLAREA == T014.KKBER
  • P_RECEIVABLESITEM1.MANDT == T014.MANDT
Supplier
  • Client
  • Supplier
  • P_RECEIVABLESITEM1.MANDT == LFA1.MANDT
  • P_RECEIVABLESITEM1.CREDITOR == LFA1.LIFNR
Customer
  • Client
  • Customer
  • P_RECEIVABLESITEM1.MANDT == KNA1.MANDT
  • P_RECEIVABLESITEM1.DEBTOR == KNA1.KUNNR
Country/Region of Destination for Delivery of Goods
  • Client
  • Country/Region of Destination for Delivery of Goods
  • P_RECEIVABLESITEM1.MANDT == T005.MANDT
  • P_RECEIVABLESITEM1.DELIVOFGOODSDESTCOUNTRY == T005.LAND1
Supplying Country/Region for Delivery of Goods
  • Client
  • Supplying Country/Region for Delivery of Goods
  • P_RECEIVABLESITEM1.MANDT == T005.MANDT
  • P_RECEIVABLESITEM1.DELIVOFGOODSORIGINCOUNTRY == T005.LAND1
Dunning Area
  • Client
  • Dunning Area
  • Company Code
  • P_RECEIVABLESITEM1.MANDT == T047M.MANDT
  • P_RECEIVABLESITEM1.DUNNINGAREA == T047M.MABER
  • P_RECEIVABLESITEM1.COMPANYCODE == T047M.BUKRS
Dunning Block
  • Client
  • Dunning Block
  • P_RECEIVABLESITEM1.MANDT == T040S.MANDT
  • P_RECEIVABLESITEM1.DUNNINGBLOCKINGREASON == T040S.MANSP
Dunning Key
  • Client
  • Dunning Key
  • P_RECEIVABLESITEM1.MANDT == T040.MANDT
  • P_RECEIVABLESITEM1.DUNNINGKEY == T040.MSCHL
Unit of entry
  • Unit of entry
  • Client
  • P_RECEIVABLESITEM1.ENTRYUNIT == T006.MSEHI
  • P_RECEIVABLESITEM1.MANDT == T006.MANDT
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • P_RECEIVABLESITEM1.MANDT == T856.MANDT
  • P_RECEIVABLESITEM1.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • P_RECEIVABLESITEM1.MANDT == T009.MANDT
  • P_RECEIVABLESITEM1.FISCALYEARVARIANT == T009.PERIV
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_RECEIVABLESITEM1.MANDT == SKB1.MANDT
  • P_RECEIVABLESITEM1.COMPANYCODE == SKB1.BUKRS
  • P_RECEIVABLESITEM1.GLACCOUNT == SKB1.SAKNR
House Bank Key
  • Client
  • ?
  • House Bank Key
  • P_RECEIVABLESITEM1.MANDT == T012.MANDT
  • P_RECEIVABLESITEM1.[column in domain "BUKRS"] == T012.BUKRS
  • P_RECEIVABLESITEM1.HOUSEBANK == T012.HBKID
House Bank Account
  • Client
  • ?
  • House Bank Key
  • House Bank Account
  • P_RECEIVABLESITEM1.MANDT == T012K.MANDT
  • P_RECEIVABLESITEM1.[column in domain "BUKRS"] == T012K.BUKRS
  • P_RECEIVABLESITEM1.HOUSEBANK == T012K.HBKID
  • P_RECEIVABLESITEM1.HOUSEBANKACCOUNT == T012K.HKTID
Valuation Type
  • Client
  • Valuation Type
  • P_RECEIVABLESITEM1.MANDT == T149D.MANDT
  • P_RECEIVABLESITEM1.INVENTORYVALUATIONTYPE == T149D.BWTAR
Joint venture
  • Client
  • Company Code
  • Joint venture
  • P_RECEIVABLESITEM1.MANDT == T8JV.MANDT
  • P_RECEIVABLESITEM1.COMPANYCODE == T8JV.BUKRS
  • P_RECEIVABLESITEM1.JOINTVENTURE == T8JV.VNAME
Recovery Indicator
  • Client
  • Company Code
  • Recovery Indicator
  • P_RECEIVABLESITEM1.MANDT == T8JJ.MANDT
  • P_RECEIVABLESITEM1.COMPANYCODE == T8JJ.BUKRS
  • P_RECEIVABLESITEM1.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Equity group
  • Equity group
  • Client
  • Company Code
  • Joint venture
  • P_RECEIVABLESITEM1.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • P_RECEIVABLESITEM1.MANDT == T8JF.MANDT
  • P_RECEIVABLESITEM1.COMPANYCODE == T8JF.BUKRS
  • P_RECEIVABLESITEM1.JOINTVENTURE == T8JF.VNAME
Equity type
  • Client
  • Company Code
  • Equity type
  • P_RECEIVABLESITEM1.MANDT == T8JE.MANDT
  • P_RECEIVABLESITEM1.COMPANYCODE == T8JE.BUKRS
  • P_RECEIVABLESITEM1.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
Material Number
  • Client
  • Material Number
  • P_RECEIVABLESITEM1.MANDT == MARA.MANDT
  • P_RECEIVABLESITEM1.MATERIAL == MARA.MATNR
Order ID
  • Client
  • Order ID
  • P_RECEIVABLESITEM1.MANDT == AUFK.MANDT
  • P_RECEIVABLESITEM1.ORDERID == AUFK.AUFNR
Partner Business Area
  • Client
  • Partner Business Area
  • P_RECEIVABLESITEM1.MANDT == TGSB.MANDT
  • P_RECEIVABLESITEM1.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_RECEIVABLESITEM1.MANDT == T880.MANDT
  • P_RECEIVABLESITEM1.PARTNERCOMPANY == T880.RCOMP
Partner Profit Center
  • ?
  • Client
  • Partner Profit Center
  • ?
  • P_RECEIVABLESITEM1.[column in domain "DATBI"] == CEPC.DATBI
  • P_RECEIVABLESITEM1.MANDT == CEPC.MANDT
  • P_RECEIVABLESITEM1.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_RECEIVABLESITEM1.[column in domain "KOKRS"] == CEPC.KOKRS
Payment Block on Item
  • Client
  • Payment Block on Item
  • P_RECEIVABLESITEM1.MANDT == T008.MANDT
  • P_RECEIVABLESITEM1.PAYMENTBLOCKINGREASON == T008.ZAHLS
Currency for Automatic Payment
  • Client
  • Currency for Automatic Payment
  • P_RECEIVABLESITEM1.MANDT == TCURC.MANDT
  • P_RECEIVABLESITEM1.PAYMENTCURRENCY == TCURC.WAERS
Reason Code for Payments
  • Client
  • Company Code
  • Reason Code for Payments
  • P_RECEIVABLESITEM1.MANDT == T053R.MANDT
  • P_RECEIVABLESITEM1.COMPANYCODE == T053R.BUKRS
  • P_RECEIVABLESITEM1.PAYMENTDIFFERENCEREASON == T053R.RSTGR
Payment Method
  • Client
  • Payment Method
  • ?
  • P_RECEIVABLESITEM1.MANDT == T042Z.MANDT
  • P_RECEIVABLESITEM1.PAYMENTMETHOD == T042Z.ZLSCH
  • P_RECEIVABLESITEM1.[column in domain "LAND1"] == T042Z.LAND1
Payment Method Supplement
  • Client
  • Payment Method Supplement
  • P_RECEIVABLESITEM1.MANDT == T042F.MANDT
  • P_RECEIVABLESITEM1.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
Planning Level
  • Client
  • Planning Level
  • P_RECEIVABLESITEM1.MANDT == T036.MANDT
  • P_RECEIVABLESITEM1.PLANNINGLEVEL == T036.EBENE
Plant
  • Client
  • Plant
  • P_RECEIVABLESITEM1.MANDT == T001W.MANDT
  • P_RECEIVABLESITEM1.PLANT == T001W.WERKS
Posting Key
  • Client
  • Posting Key
  • P_RECEIVABLESITEM1.MANDT == TBSL.MANDT
  • P_RECEIVABLESITEM1.POSTINGKEY == TBSL.BSCHL
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_RECEIVABLESITEM1.PURCHASEORDERPRICEUNIT == T006.MSEHI
  • P_RECEIVABLESITEM1.MANDT == T006.MANDT
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • ?
  • P_RECEIVABLESITEM1.MANDT == T005S.MANDT
  • P_RECEIVABLESITEM1.REGION == T005S.BLAND
  • P_RECEIVABLESITEM1.[column in domain "LAND1"] == T005S.LAND1
Special G/L Indicator
  • Client
  • ?
  • Special G/L Indicator
  • P_RECEIVABLESITEM1.MANDT == T074U.MANDT
  • P_RECEIVABLESITEM1.[column in domain "KOART"] == T074U.KOART
  • P_RECEIVABLESITEM1.SPECIALGLCODE == T074U.UMSKZ
Supplying Country/Region
  • Client
  • Supplying Country/Region
  • P_RECEIVABLESITEM1.MANDT == T005.MANDT
  • P_RECEIVABLESITEM1.SUPPLYINGCOUNTRY == T005.LAND1
Target Special G/L Indicator
  • Client
  • Target Special G/L Indicator
  • Account Type
  • P_RECEIVABLESITEM1.MANDT == T074U.MANDT
  • P_RECEIVABLESITEM1.TARGETSPECIALGLCODE == T074U.UMSKZ
  • P_RECEIVABLESITEM1.FINANCIALACCOUNTTYPE == T074U.KOART
Sales/Purchases Tax Code
  • Client
  • ?
  • Sales/Purchases Tax Code
  • P_RECEIVABLESITEM1.MANDT == T007A.MANDT
  • P_RECEIVABLESITEM1.[column in domain "KALSM_D"] == T007A.KALSM
  • P_RECEIVABLESITEM1.TAXCODE == T007A.MWSKZ
Tax Code 1 for Distribution
  • Client
  • Tax Code 1 for Distribution
  • ?
  • P_RECEIVABLESITEM1.MANDT == T007A.MANDT
  • P_RECEIVABLESITEM1.TAXDISTRIBUTIONCODE1 == T007A.MWSKZ
  • P_RECEIVABLESITEM1.[column in domain "KALSM_D"] == T007A.KALSM
Tax Code 2 for Distribution
  • Client
  • Tax Code 2 for Distribution
  • ?
  • P_RECEIVABLESITEM1.MANDT == T007A.MANDT
  • P_RECEIVABLESITEM1.TAXDISTRIBUTIONCODE2 == T007A.MWSKZ
  • P_RECEIVABLESITEM1.[column in domain "KALSM_D"] == T007A.KALSM
Tax Code 3 for Distribution
  • Client
  • ?
  • Tax Code 3 for Distribution
  • P_RECEIVABLESITEM1.MANDT == T007A.MANDT
  • P_RECEIVABLESITEM1.[column in domain "KALSM_D"] == T007A.KALSM
  • P_RECEIVABLESITEM1.TAXDISTRIBUTIONCODE3 == T007A.MWSKZ
Tax Jurisdiction
  • Client
  • ?
  • Tax Jurisdiction
  • P_RECEIVABLESITEM1.MANDT == TTXJ.MANDT
  • P_RECEIVABLESITEM1.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • P_RECEIVABLESITEM1.TAXJURISDICTION == TTXJ.TXJCD
Tax Section
  • Client
  • Tax Section
  • Company Code
  • P_RECEIVABLESITEM1.MANDT == SECCODE.MANDT
  • P_RECEIVABLESITEM1.TAXSECTION == SECCODE.SECCODE
  • P_RECEIVABLESITEM1.COMPANYCODE == SECCODE.BUKRS
Transaction Currency
  • Client
  • Transaction Currency
  • P_RECEIVABLESITEM1.MANDT == TCURC.MANDT
  • P_RECEIVABLESITEM1.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation area
  • Valuation area
  • Client
  • P_RECEIVABLESITEM1.VALUATIONAREA == T001K.BWKEY
  • P_RECEIVABLESITEM1.MANDT == T001K.MANDT
Withholding Tax Code
  • Client
  • ?
  • Withholding Tax Code
  • P_RECEIVABLESITEM1.MANDT == T059Q.MANDT
  • P_RECEIVABLESITEM1.[column in domain "LAND1"] == T059Q.LAND1
  • P_RECEIVABLESITEM1.WITHHOLDINGTAXCODE == T059Q.QSSKZ