P_CO_DIANFrmt1001JrnlEntrOplVw

Format 1001 - JE Operational View | view: PSRCO1001JEOPLVW | Extraction: Not supported | Component: Financials Colombia
Column Name Description
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Reporting Currency (ReportingCurrency):
TaxBaseAmount Amount in Global Currency
AmountInReportingCurrency Amount in Global Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
FinancialAccountType Account Type Show values
OffsettingAccountType Offsetting Account Type Show values
Column Name Description Domain name
TransactionTypeDetermination Transaction Key CHAR3
AccountAssignmentNumber Account Assignment Number NUM02
ReferenceDocumentFiscalYear Reference Document Context AWORG
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem null
OffsettingAccount Offsetting Account GKONT
Reference1IDByBusinessPartner ID of Reference 1 by Business Partner CHAR12
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_CO_DIANFRMT1001JRNLENTROPLVW.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == T003.MANDT
Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Alternative G/L Account Number In Company Code
  • Client
  • P_CO_DIANFRMT1001JRNLENTROPLVW.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • P_CO_DIANFRMT1001JRNLENTROPLVW.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == SKA1.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_CO_DIANFRMT1001JRNLENTROPLVW.CHARTOFACCOUNTS == T004.KTOPL
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_CO_DIANFRMT1001JRNLENTROPLVW.COMPANYCODE == T001.BUKRS
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == T001.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == T005.MANDT
  • P_CO_DIANFRMT1001JRNLENTROPLVW.COMPANYCODECOUNTRY == T005.LAND1
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • P_CO_DIANFRMT1001JRNLENTROPLVW.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • P_CO_DIANFRMT1001JRNLENTROPLVW.CUSTOMER == KNA1.KUNNR
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == KNA1.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • P_CO_DIANFRMT1001JRNLENTROPLVW.COMPANYCODE == SKB1.BUKRS
  • P_CO_DIANFRMT1001JRNLENTROPLVW.GLACCOUNT == SKB1.SAKNR
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == SKB1.MANDT
Inventory Valuation Type
  • Inventory Valuation Type
  • Client
  • P_CO_DIANFRMT1001JRNLENTROPLVW.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == T149D.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Product Number
  • Product Number
  • Client
  • P_CO_DIANFRMT1001JRNLENTROPLVW.PRODUCT == MARA.MATNR
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == MARA.MANDT
Reference Document Type P_CO_DIANFRMT1001JRNLENTROPLVW.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Reporting Entity
  • Client
  • Reporting Entity
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == SRF_RPG_ENT.MANDT
  • P_CO_DIANFRMT1001JRNLENTROPLVW.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Supplier
  • Client
  • P_CO_DIANFRMT1001JRNLENTROPLVW.SUPPLIER == LFA1.LIFNR
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == LFA1.MANDT
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • ?
  • Client
  • P_CO_DIANFRMT1001JRNLENTROPLVW.TAXCODE == T007A.MWSKZ
  • P_CO_DIANFRMT1001JRNLENTROPLVW.[column in domain "KALSM_D"] == T007A.KALSM
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == T007A.MANDT
Valuation area
  • Valuation area
  • Client
  • P_CO_DIANFRMT1001JRNLENTROPLVW.VALUATIONAREA == T001K.BWKEY
  • P_CO_DIANFRMT1001JRNLENTROPLVW.MANDT == T001K.MANDT