P_MX_OperationalAcctDocItem

Journal Entries Items with Payments | view: PMXOPERADOCIT | Extraction: Not supported | Component: Financials Mexico
Column Name Description
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
PostingDate Posting Date
ClearingDate Clearing Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
OrganizationBPName1 Name 1 TEXT40
Country Country/Region Key LAND1
TaxNumber1 Tax Number 1 STCD1
DigInvcOp1 null
DigInvcOp2 null
ExchangeRate Exchange rate KURSF
DocumentReferenceID Document Reference ID XBLNR1
ClearingAccountingDocument Clearing Journal Entry BELNR
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Document Context AWORG
SenderLogicalSystem Sender Logical System LOGSYS
AccountingDocumentHeaderText Document Header Text TEXT25
TransactionCode Transaction Code TCODE
JrnlEntryCntrySpecificRef1 Country/Region Specific Reference 1 in the Document FAC_GLO_REF1_HD
OplAcctgDocItmCntrySpcfcRef1 Country/Region Specific Reference 1 on line item FAC_GLO_REF1
JrnlEntryCntrySpecificRef5 Manual Payment Details for Mexico
TaxNumberLineItem ID of Reference 3 by Business Partner CHAR20
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Fiscal Year FIS_GJAHR_NO_CONV
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_MX_OPERATIONALACCTDOCITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_MX_OPERATIONALACCTDOCITEM.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • P_MX_OPERATIONALACCTDOCITEM.COMPANYCODE == T001.BUKRS
  • P_MX_OPERATIONALACCTDOCITEM.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • P_MX_OPERATIONALACCTDOCITEM.CUSTOMER == KNA1.KUNNR
  • P_MX_OPERATIONALACCTDOCITEM.MANDT == KNA1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Payment Method
  • ?
  • Client
  • Payment Method
  • P_MX_OPERATIONALACCTDOCITEM.[column in domain "LAND1"] == T042Z.LAND1
  • P_MX_OPERATIONALACCTDOCITEM.MANDT == T042Z.MANDT
  • P_MX_OPERATIONALACCTDOCITEM.PAYMENTMETHOD == T042Z.ZLSCH
Reference Document Type P_MX_OPERATIONALACCTDOCITEM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Reporting Entity
  • Client
  • Reporting Entity
  • P_MX_OPERATIONALACCTDOCITEM.MANDT == SRF_RPG_ENT.MANDT
  • P_MX_OPERATIONALACCTDOCITEM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Supplier
  • Client
  • P_MX_OPERATIONALACCTDOCITEM.SUPPLIER == LFA1.LIFNR
  • P_MX_OPERATIONALACCTDOCITEM.MANDT == LFA1.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • P_MX_OPERATIONALACCTDOCITEM.MANDT == TCURC.MANDT
  • P_MX_OPERATIONALACCTDOCITEM.TRANSACTIONCURRENCY == TCURC.WAERS