FIN_SUBVAL_JOURNALENTRYITEM

Journal Entry Item Substitution Validation | view: FSUBVALJEI | Extraction: Not supported | Component: Validation, Substitution and Rules
Tables used: BSEG
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
AccountingDocumentItem Number of Line Item Within Accounting Document
Column Name Description
💲 Currency Key (TransactionCurrency):
CashDiscountAmount Cash Discount Amount in Document Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
📏 Unit of entry (GoodsMovementEntryUnit):
QuantityInEntryUnit Quantity in unit of entry
📏 Order Price Unit (Purchasing) (PurchasingDocumentPriceUnit):
PurchaseOrderQty Quantity in Purchase Order Price Unit
Column Name Description
ClearingDate Clearing Date
ClearingCreationDate Clearing Entry Date
ValueDate Value date
AssetValueDate Asset Value Date
DueCalculationBaseDate Baseline Date for Due Date Calculation
LastDunningDate Date of Last Dunning Notice
SettlementReferenceDate Reference date for settlement
NetDueDate Net Due Date
Column Name Description
FinancialAccountType Account type Show values
DebitCreditCode Debit/Credit Indicator Show values
FixedCashDiscount Fixed Payment Terms Show values
IsNegativePosting Indicator: Negative Posting Show values
OffsettingAccountType Offsetting Account Type Show values
Column Name Description Domain name
ClearingAccountingDocument Document Number of the Clearing Document BELNR
TransactionTypeDetermination Transaction Key CHAR3
AssignmentReference Assignment number ZUONR
DocumentItemText Item Text TEXT50
CostCenter Cost Center KOSTL
BillingDocument Billing Document VBELN
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
ServiceDocumentType Service Document Type CRM_PROCESS_TYPE
ServiceDocument Service Document ID CRM_OBJECT_ID
ServiceDocumentItem Service Document Item ID FCO_SRVDOC_ITEM_ID
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 of the Relevant Invoice (for Credit Memo) GJAHR
InvoiceItemReference Line Item in the Relevant Invoice BUZEI
FollowOnDocumentType Follow-On Document Type REBZT
DunningLevel Dunning Level MAHNS
AccountAssignmentNumber Sequential Number of Account Assignment NUM02
ProfitCenter Profit Center PRCTR
Reference1IDByBusinessPartner Business Partner Reference Key CHAR12
Reference2IDByBusinessPartner Business Partner Reference Key CHAR12
Reference3IDByBusinessPartner Reference key for line item CHAR20
CostCtrActivityType Activity Type LSTAR
FunctionalArea Functional Area FKBER
ClearingDocFiscalYear Fiscal Year of Clearing Document GJAHR
Segment Segment for Segmental Reporting FB_SEGMENT
PartnerSegment Partner Segment for Segmental Reporting FB_SEGMENT
PartnerFunctionalArea Partner Functional Area FKBER
OffsettingAccount Offsetting Account Number GKONT
AssetAcctTransClassfctn Transaction Type Category FAA_MOVCAT
AssetClass Asset Class ANLKL
BusinessTransactionType Business Transaction Category FINS_BTTYPE
SubLedgerAcctLineItemType Subledger-Specific Line Item Type SLALITTYPE
ValuationClass Valuation Class BKLAS
Master Data Relations Join Conditions
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == TABW.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.ASSETTRANSACTIONTYPE == TABW.BWASL
Update Currency for General Ledger Transaction Figures
  • Client
  • Update Currency for General Ledger Transaction Figures
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == TCURC.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T006.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == TGSB.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.BUSINESSAREA == TGSB.GSBER
Company Code
  • Company Code
  • Client
  • FIN_SUBVAL_JOURNALENTRYITEM.COMPANYCODE == T001.BUKRS
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T001.MANDT
Customer Number
  • Client
  • Customer Number
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == KNA1.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.CUSTOMER == KNA1.KUNNR
Dunning Area
  • Company Code
  • Client
  • Dunning Area
  • FIN_SUBVAL_JOURNALENTRYITEM.COMPANYCODE == T047M.BUKRS
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T047M.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.DUNNINGAREA == T047M.MABER
Dunning Block
  • Client
  • Dunning Block
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T040S.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.DUNNINGBLOCKINGREASON == T040S.MANSP
Dunning Key
  • Client
  • Dunning Key
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T040.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.DUNNINGKEY == T040.MSCHL
Transaction type
  • Client
  • Transaction type
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T856.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.FINANCIALTRANSACTIONTYPE == T856.TRTYP
General Ledger Account
  • Company Code
  • Client
  • General Ledger Account
  • FIN_SUBVAL_JOURNALENTRYITEM.COMPANYCODE == SKB1.BUKRS
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == SKB1.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.GLACCOUNT == SKB1.SAKNR
Unit of entry
  • Client
  • Unit of entry
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T006.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.GOODSMOVEMENTENTRYUNIT == T006.MSEHI
Short Key for a House Bank
  • Client
  • Short Key for a House Bank
  • ?
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T012.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.HOUSEBANK == T012.HBKID
  • FIN_SUBVAL_JOURNALENTRYITEM.[column in domain "BUKRS"] == T012.BUKRS
ID for Account Details
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • ?
  • FIN_SUBVAL_JOURNALENTRYITEM.HOUSEBANKACCOUNT == T012K.HKTID
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T012K.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.HOUSEBANK == T012K.HBKID
  • FIN_SUBVAL_JOURNALENTRYITEM.[column in domain "BUKRS"] == T012K.BUKRS
Billing Indicator
  • Billing Indicator
  • Client
  • FIN_SUBVAL_JOURNALENTRYITEM.JOINTVENTUREBILLINGTYPE == T8JA.BILIND
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T8JA.MANDT
Recovery Indicator
  • Company Code
  • Client
  • Recovery Indicator
  • FIN_SUBVAL_JOURNALENTRYITEM.COMPANYCODE == T8JJ.BUKRS
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T8JJ.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Material Number
  • Client
  • Material Number
  • Product Number
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == MARA.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.MATERIAL == MARA.MATNR
  • FIN_SUBVAL_JOURNALENTRYITEM.PRODUCT == MARA.MATNR
Order Number
  • Order Number
  • Client
  • FIN_SUBVAL_JOURNALENTRYITEM.ORDERID == AUFK.AUFNR
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == AUFK.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T880.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.PARTNERCOMPANY == T880.RCOMP
Partner Profit Center
  • Client
  • ?
  • ?
  • Partner Profit Center
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == CEPC.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.[column in domain "DATBI"] == CEPC.DATBI
  • FIN_SUBVAL_JOURNALENTRYITEM.[column in domain "KOKRS"] == CEPC.KOKRS
  • FIN_SUBVAL_JOURNALENTRYITEM.PARTNERPROFITCENTER == CEPC.PRCTR
Payment Block Key
  • Client
  • Payment Block Key
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T008.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
Currency for Automatic Payment
  • Client
  • Currency for Automatic Payment
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == TCURC.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.PAYMENTCURRENCY == TCURC.WAERS
Payment Method
  • Client
  • ?
  • Payment Method
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T042Z.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.[column in domain "LAND1"] == T042Z.LAND1
  • FIN_SUBVAL_JOURNALENTRYITEM.PAYMENTMETHOD == T042Z.ZLSCH
Plant
  • Client
  • Plant
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T001W.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.PLANT == T001W.WERKS
Posting Key
  • Client
  • Posting Key
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == TBSL.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.POSTINGKEY == TBSL.BSCHL
Product Number
  • Client
  • Material Number
  • Product Number
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == MARA.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.MATERIAL == MARA.MATNR
  • FIN_SUBVAL_JOURNALENTRYITEM.PRODUCT == MARA.MATNR
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T006.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.PURCHASINGDOCUMENTPRICEUNIT == T006.MSEHI
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == LFA1.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.SUPPLIER == LFA1.LIFNR
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • FIN_SUBVAL_JOURNALENTRYITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T007A.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.TAXCODE == T007A.MWSKZ
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • FIN_SUBVAL_JOURNALENTRYITEM.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == TTXJ.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.TAXJURISDICTION == TTXJ.TXJCD
Currency Key
  • Client
  • Currency Key
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == TCURC.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Withholding Tax Code
  • Client
  • ?
  • Withholding Tax Code
  • FIN_SUBVAL_JOURNALENTRYITEM.MANDT == T059Q.MANDT
  • FIN_SUBVAL_JOURNALENTRYITEM.[column in domain "LAND1"] == T059Q.LAND1
  • FIN_SUBVAL_JOURNALENTRYITEM.WITHHOLDINGTAXCODE == T059Q.QSSKZ