FIN_SUBSTNVALDTNCODINGBLOCK

FIN Substitution Validation Coding Block | view: FSUBVALDCOBL | Extraction: Not supported | Component: Validation, Substitution and Rules
Tables used: FINSUBVALCOBL
Column Name Description
CompanyCode Company Code
BusinessTransactionType Business Transaction
Column Name Description
💲 Currency Key (TransactionCurrency):
AmountInCompanyCodeCurrency Amount in local currency
AmountInTransactionCurrency Amount in document currency
TaxAmountInCoCodeCrcy Tax Amount in Local Currency
TaxAmount Tax Amount in Document Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
DocumentDate Document Date in Document
PostingDate Posting Date in the Document
AssetValueDate Reference date
SettlementReferenceDate Reference date for settlement
Column Name Description
IsReversalDocument Identifier for reversal document Show values
FinancialAccountType Account type Show values
DebitCreditCode Debit/Credit Indicator Show values
IsAutomaticallyCreated Indicator: Line item automatically created Show values
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated Show values
GoodsMovementRefDocType Movement Indicator Show values
ConsumptionPosting Consumption posting Show values
SDDocumentCategory SD Document Category Show values
OrderCategory Order category Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
AccountingDocExternalReference Reference Document Number XBLNR1
ReferenceDocumentType Reference procedure AWTYP
ReferenceDocumentLogicalSystem Logical system of source document LOGSYS
OriginalReferenceDocument Reference Key AWKEY
ClearingAccountingDocument Document Number of the Clearing Document BELNR
PartnerBusinessArea Trading partner's business area GSBER
TransactionTypeDetermination Transaction Key CHAR3
PartnerCompany Company ID of Trading Partner RCOMP
MasterFixedAsset Main Asset Number BF_ANLN1
FixedAsset Asset Subnumber BF_ANLN2
AssetTransactionType Asset transaction type CHAR3
GLAccount General Ledger Account SAKNR
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
Material Material Number MATNR
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
Plant Plant WERKS
PurchasingDocument Purchasing Document Number EBELN
PurchasingDocumentItem Item Number of Purchasing Document EBELP
AccountAssignmentNumber Sequential Number of Account Assignment NUM02
InventoryValuationType Valuation Type BWTAR
Segment Segment for Segmental Reporting FB_SEGMENT
PartnerSegment Partner Segment for Segmental Reporting FB_SEGMENT
PartnerFunctionalArea Partner Functional Area FKBER
FinancialTransactionType Transaction type RMVCT
SalesOrderScheduleLine Delivery schedule for sales order NUM04
FiscalPeriod Fiscal period MONAT
StatisticalKeyFigure Statistical key figure STAGR
AccountAssignmentType Object Type J_OBART
AccountAssignment Account Assignment ACCAS
WBSElementInternalID Work Breakdown Structure Element (WBS Element) PS_POSNR
PartnerProfitCenter Partner Profit Center PRCTR
ServiceDocumentType Service Document Type CRM_PROCESS_TYPE
ServiceDocument Service Document ID CRM_OBJECT_ID
ServiceDocumentItem Service Document Item ID FCO_SRVDOC_ITEM_ID
BillableControl Billable Control BEMOT
FunctionalArea Functional Area FKBER
CostCenter Cost Center KOSTL
CostCtrActivityType Activity Type LSTAR
OrderID Order Number AUFNR
OrderItem Order item number CO_POSNR
PersonnelNumber Personnel Number PERNR
SalesOrder Sales Order Number VBELN
SalesOrderItem Item number in Sales Order NUM06
ProfitCenter Profit Center PRCTR
Operation Operation/Activity Number VORNR
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == T006.MANDT
  • FIN_SUBSTNVALDTNCODINGBLOCK.BASEUNIT == T006.MSEHI
Customer Number
  • Customer Number
  • Client
  • FIN_SUBSTNVALDTNCODINGBLOCK.CUSTOMER == KNA1.KUNNR
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == KNA1.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == TVTW.MANDT
  • FIN_SUBSTNVALDTNCODINGBLOCK.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • FIN_SUBSTNVALDTNCODINGBLOCK.DIVISION == TSPA.SPART
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == TSPA.MANDT
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == T156.MANDT
  • FIN_SUBSTNVALDTNCODINGBLOCK.GOODSMOVEMENTTYPE == T156.BWART
Equity group
  • Joint venture
  • Equity group
  • Client
  • Company Code
  • FIN_SUBSTNVALDTNCODINGBLOCK.JOINTVENTURE == T8JF.VNAME
  • FIN_SUBSTNVALDTNCODINGBLOCK.JNTOPGAGRMTEQUITYGRP == T8JF.EGRUP
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == T8JF.MANDT
  • FIN_SUBSTNVALDTNCODINGBLOCK.COMPANYCODE == T8JF.BUKRS
Joint venture
  • Joint venture
  • Client
  • Company Code
  • FIN_SUBSTNVALDTNCODINGBLOCK.JOINTVENTURE == T8JV.VNAME
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == T8JV.MANDT
  • FIN_SUBSTNVALDTNCODINGBLOCK.COMPANYCODE == T8JV.BUKRS
Joint Venture Cost Recovery Code
  • Client
  • Company Code
  • Joint Venture Cost Recovery Code
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == T8JJ.MANDT
  • FIN_SUBSTNVALDTNCODINGBLOCK.COMPANYCODE == T8JJ.BUKRS
  • FIN_SUBSTNVALDTNCODINGBLOCK.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Posting Key
  • Client
  • Posting Key
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == TBSL.MANDT
  • FIN_SUBSTNVALDTNCODINGBLOCK.POSTINGKEY == TBSL.BSCHL
Sales Organization
  • Client
  • Sales Organization
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == TVKO.MANDT
  • FIN_SUBSTNVALDTNCODINGBLOCK.SALESORGANIZATION == TVKO.VKORG
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == LFA1.MANDT
  • FIN_SUBSTNVALDTNCODINGBLOCK.SUPPLIER == LFA1.LIFNR
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • Client
  • FIN_SUBSTNVALDTNCODINGBLOCK.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • FIN_SUBSTNVALDTNCODINGBLOCK.TAXJURISDICTION == TTXJ.TXJCD
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == TTXJ.MANDT
Currency Key
  • Client
  • Currency Key
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == TCURC.MANDT
  • FIN_SUBSTNVALDTNCODINGBLOCK.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation Class
  • Valuation Class
  • Client
  • FIN_SUBSTNVALDTNCODINGBLOCK.VALUATIONCLASS == T025.BKLAS
  • FIN_SUBSTNVALDTNCODINGBLOCK.MANDT == T025.MANDT