C_GLIncgOrdOrdEntrVislFltr

Visual Filters for Order Entry | view: CGLIOORDRENTRVF | Extraction: Not supported | Component: Fiori FXU General Ledger Accounting FI-FIO-GL
Tables used: SCAL_TT_DATE, VBAK, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, T151T, T023T, CEPC, CEPCT, PROJ, HRRP_FSV_DIR, PRPS, PRPS, SKAT, T004, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_HRRP2SEMTA, HRRP_NODE, FAAC_KFC_SPEC, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger Source Ledger
CompanyCode Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
GLAccountHierarchy Financial Statement Version
SemanticTag Semantic Tag of a Hierarchy Node
ValidityStartDate Valid-From Date
ValidityEndDate Valid To Date
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
RevenueAmountInCompanyCodeCrcy Recognized Revenue
COGSAmountInCoCodeCrcy null
RecognizedMarginAmtInCCCrcy Recognized Margin
SalesDeductionAmtInCoCodeCrcy null
💲 Global Currency (GlobalCurrency):
RevenueInGlobalCurrency Recognized Revenue
COGSAmountInGlobCrcy null
RecognizedMarginAmount Recognized Margin
SalesDeductionAmountInGlobCrcy null
Column Name Description
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid To Date
DocumentDate Journal Entry Date
FiscalPeriodStartDate Start Date of Fiscal Period
PostingDate Posting Date
CreationDate Creation Date
ClearingDate Clearing Date
Column Name Description
JrnlEntrDerivedFiscalQuarter Journal Entry Derived Fiscal Quarter Show values
DebitCreditCode Debit/Credit Code Show values
GLAccountType Type of a General Ledger Account Show values
FinancialAccountType Account Type Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
JrnlEntryItemObsoleteReason Reason Item is Obsolete Show values
SalesOrderType Sales Order Selection Show values
Column Name Description Domain name
SalesOrganization Sales Organization VKORG
CustomerGroup Customer Group KDGRP
CustomerGroupName Name TEXT20
Customer Customer Number KUNNR
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod null
JrnlEntrDerivedFiscalYear Journal Entry Derived Fiscal Year GJAHR
JrnlEntrDerivedFiscalPeriod Journal Entry Derived Fiscal Period POPER
JrnlEntrDerivdFiscalYearPeriod Journal Entry Derived Fiscal Year Period NUMC07
ProductGroup Product Group MATKL
ProductGroupName Product Group Description TEXT20
ProfitCenter Profit Center PRCTR
ProfitCenterName Description of Profit Center TEXT20
ControllingArea Controlling Area CACCD
SalesDistrict Sales District BZIRK
Segment Segment for Segmental Reporting FB_SEGMENT
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item NUM06
SoldProduct Product Sold MATNR
DistributionChannel Distribution Channel VTWEG
BusinessTransactionType Business Transaction Type FINS_CUSTBTTYPE
BusinessArea Business Area GSBER
CostCenter Cost Center KOSTL
CustomerSupplierCountry Customer or Supplier Country/Region LAND1
GLAccount G/L Account
GLAccountName G/L Account Name TEXT20
ChartOfAccounts Chart of Accounts KTOPL
LedgerFiscalYear Ledger Fiscal Year GJAHR
FinancialTransactionType Financial Transaction Type RMVCT
AssignmentReference Assignment Reference ZUONR
PostingKey Posting Key BSCHL
AccountingDocCreatedByUser User that created the journal entry
Plant Plant WERKS
SpecialGLCode Special G/L Indicator UMSKZ
ClearingAccountingDocument Clearing Journal Entry BELNR
BillingDocumentType Billing Type FKART
CustomerSupplierIndustry Customer Supplier Industry BRSCH
BillToParty Bill-to Party KUNNR
ShipToParty Ship-to Party KUNNR
SourceReferenceDocumentType Source Document Type AWTYP
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
OperatingConcern Operating Concern ERKRS
AccountingDocumentItem Journal Entry Posting View Item BUZEI
TransactionTypeDetermination Transaction Key CHAR3
AccountingDocumentType Journal Entry Type BLART
ReferenceDocumentType Reference Document Type AWTYP
ServiceDocument Service Document ID CRM_OBJECT_ID
ServiceDocumentItem Service Document Item ID FCO_SRVDOC_ITEM_ID
ServiceDocumentType Service Document Type CRM_PROCESS_TYPE
ValuationArea Valuation area BWKEY
Supplier Supplier LIFNR
SalesDocument Sales Document VBELN
FixedAsset Asset Subnumber ANLN2
MasterFixedAsset Fixed Asset ANLN1
OrderID Order ID AUFNR
OrganizationDivision Division SPART
AssetClass Asset Class ANLKL
Master Data Relations Join Conditions
Division in order header
  • Client
  • ?
  • ?
  • Division
  • C_GLINCGORDORDENTRVISLFLTR.MANDT == TVTA.MANDT
  • C_GLINCGORDORDENTRVISLFLTR.[column in domain "VKORG"] == TVTA.VKORG
  • C_GLINCGORDORDENTRVISLFLTR.[column in domain "VTWEG"] == TVTA.VTWEG
  • C_GLINCGORDORDENTRVISLFLTR.DIVISION == TVTA.SPART
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
Order type in order header
  • Client
  • Sales Document Type
  • C_GLINCGORDORDENTRVISLFLTR.MANDT == TVAK.MANDT
  • C_GLINCGORDORDENTRVISLFLTR.ORDERTYPE == TVAK.AUART
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting