P_OperationalAcctgDocBrowser

P_OperationalAcctgDocBrowser | view: PFIOPACCTGDCBRWS | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: VBKPF, VBKPF, VBSEGK, VBKPF, VBSEGD, BKPF, BSEG_ADD, BSEG, VBKPF, VBSEGA, VBSEGS, T001, TKA02, T001, T001, T014, T001
Column Name Description
AccountingDocumentCatGroup Journal Entry Category Group Show values
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
TaxAmountInCoCodeCrcy Signed Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Company Code Currency
ValuationDiffAmtInCoCodeCrcy Valuation Difference Amount In Company Code Currency
CashDiscountAmtInCoCodeCrcy Cash Discount Amount in Company Code Currency
InvoiceAmtInCoCodeCrcy Invoice Amount in Company Code Currency
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
OriginalTaxBaseAmount Original Tax Base Amount in Transaction Currency
TaxAmount Tax Amount in Transaction Currency
TaxBaseAmountInTransCrcy Tax Base Amount in Transaction Currency
WithholdingTaxBaseAmount Withholding Tax Base Amount
PlannedAmtInTransactionCrcy Planned Amount in Transaction Currency
CashDiscountBaseAmount Cash Discount Base Amount
CashDiscountAmount Cash Discount Amount
NetPaymentAmount Net Payment Amount
WithholdingTaxAmount Withholding Tax Amount
WithholdingTaxExemptionAmt Withholding Tax-Exemption Amount
InvoiceAmountInFrgnCurrency Invoice Amount in Foreign Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Additional Currency 1 (AdditionalCurrency1):
ValuationDiffAmtInAddlCrcy1 Valuation Difference Amount in Additional Currency 1
AmountInAdditionalCurrency1 Amount in Additional Currency 1
💲 Additional Currency 2 (AdditionalCurrency2):
AmountInAdditionalCurrency2 Amount in Additional Currency 2
ValuationDiffAmtInAddlCrcy2 Valuation Difference Amount in Additional Currency 2
💲 Currency for Automatic Payment (PaymentCurrency):
AmountInPaymentCurrency Amount in Payment Currency
💲 Credit Control Area Currency (CreditControlAreaCurrency):
HedgedAmount Credit Management: Hedged Amount
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
AbsoluteQuantity Absolute Quantity
📏 Unit of entry (GoodsMovementEntryUnit):
QuantityInEntryUnit Quantity in Entry Unit
📏 Order Price Unit (Purchasing) (PurchasingDocumentPriceUnit):
PurchaseOrderQty Purchase Order Quantity
Column Name Description
ClearingDate Clearing Date
ClearingCreationDate Clearing Creation Date
ValueDate Value date
AssetValueDate Asset Value Date
DueCalculationBaseDate Due Calculation Base Date
LastDunningDate Date of Last Dunning Notice
SettlementReferenceDate Reference Date for Settlement
TaxDeterminationDate Date for Determination of Tax Rates
PostingDate Posting Date
DocumentDate Journal Entry Date
NetDueDate Due Date for Net Payment
CashDiscount1DueDate Due Date for Cash Discount 1
CashDiscount2DueDate Cash Discount 2 Due Date
Column Name Description
AccountingDocumentCatGroup Journal Entry Category Group Show values
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
TaxType Tax Type Show values
IsSalesRelated Is Sales Related Show values
LineItemDisplayIsEnabled Indicator: Can Line Items Be Displayed by Account? Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
IsNotCashDiscountLiable Is Not Cash Discount Liable Show values
IsAutomaticallyCreated Is Automatically Created Show values
IsUsedInPaymentTransaction Is Used In Payment Transaction Show values
IsBalanceSheetAccount Is Balance Sheet Account Show values
FixedCashDiscount Fixed Cash Discount Show values
BillOfExchangeUsage Bill of Exchange Usage Type Show values
IsCompletelyDelivered Is completely delivered Show values
MaterialPriceControl Price control indicator Show values
TreasuryContractType Treasury Contract Type Show values
IsEUTriangularDeal Is EU Triangular Deal Show values
CompanyCodeCurrencyDetnMethod Company Code Currency Determination Method Show values
ClearingIsReversed Clearing Is Reversed Show values
IsNegativePosting Is Negative Posting Show values
HasPaymentOrder Indicator: Payment Order Exists for this Item Show values
CustomerIsInExecution Customer Is In Execution Show values
AccountingDocumentCategory Journal Entry Category Show values
OffsettingAccountType Offsetting Account Type Show values
Column Name Description Domain name
ClearingAccountingDocument Clearing Journal Entry BELNR
SpecialGLTransactionType Special G/L Transaction Type UMSKS
TransactionTypeDetermination Transaction Key CHAR3
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
CorporateGroupAccount Corporate Group Account SAKNR
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
PersonnelNumber Personnel Number PERNR
BranchAccount Branch Account MAXKK
ProfitLossAccountType Profit Loss Account Type CHAR2
SpecialGLAccountAssignment Assignment Number for Special G/L Accounts ZUONR
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
BPBankAccountInternalID Business Partner Bank Account Internal ID BVTYP
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
FollowOnDocumentType Follow-On Document Type REBZT
InvoiceList Invoice List SAMNR
DunningLevel Dunning Level MAHNS
WithholdingTaxCertificate Withholding Tax Certificate CHAR10
AccountAssignmentNumber Sequential Number of Account Assignment NUM02
VATRegistration VAT Registration STCEG
ProfitCenter Profit Center PRCTR
AssetContract Asset Contract RANL
CashFlowType Flow Type SBEWART
RealEstateObject Internal Key for Real Estate Object IMKEY
CommitmentItem Commitment Item FIPOS
CommitmentItemShortID Commitment Item ShortID FIS_FIPOS_SHORTID
CostObject Cost Object KSTRG
ProjectNetwork Network Number for Account Assignment AUFNR
OrderInternalBillOfOperations Order Internal Bill of Operations ID AUFPL
OrderIntBillOfOperationsItem Order Internal Bill of Operations Item CO_APLZL
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
CostOriginGroup Origin Group as Subdivision of Cost Element HRKFT
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
Reference1IDByBusinessPartner ID of Reference 1 by Business Partner CHAR12
Reference2IDByBusinessPartner ID of Reference 2 by Business Partner CHAR12
PaymentCardItem Payment Card Item NUM03
PaymentCardPaymentSettlement Payment Card Payment Settlement CCBTC
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
DataExchangeInstruction1 Data Exchange Instruction 1 DTWSX
DataExchangeInstruction2 Data Exchange Instruction 2 DTWSX
DataExchangeInstruction3 Data Exchange Instruction 3 DTWSX
DataExchangeInstruction4 Data Exchange Instruction 4 DTWSX
PaymentReference Payment Reference CHAR30
ClearingItem Clearing Item AGZEI
CostCtrActivityType Activity Type LSTAR
BusinessProcess Business Process CO_PRZNR
FunctionalArea Functional Area FKBER
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
Segment Segment for Segmental Reporting FB_SEGMENT
PartnerSegment Partner Segment for Segmental Reporting FB_SEGMENT
PartnerFunctionalArea Partner Functional Area FKBER
CostElement Cost Element KSTAR
PaymentServiceProvider Payment Service Provider COM_WEC_PAYMENT_SRV_PROVIDER
PaymentRefByPaytSrvcProvider Payment Reference by Payment Service Provider COM_WEC_PSP_TRANSACTION_ID
SEPAMandate Unique Reference to Mandate for each Payee ID035
ReferenceDocumentType Reference Document Type AWTYP
OriginalReferenceDocument Original Reference Document AWKEY
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
AccountingDocumentItemRef Journal Entry Line Item Reference POSNR_ACC
FiscalPeriod Fiscal Period POPER
OffsettingAccount Offsetting Account GKONT
OffsettingChartOfAccounts Offsetting Chart of Accounts KTOPL
CashLedgerCompanyCode Cash Origin Company Code BUKRS
CashLedgerAccount Cash Origin Account SAKNR
FinancialManagementArea Financial Management Area FIKRS
FundsCenter Funds Management Center FISTL
FundedProgram Funded Program FM_MEASURE
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
BudgetPeriod Budget Period FM_BUDGET_PERIOD
PartnerFund Partner Fund BP_GEBER
PartnerGrant Partner Grant GM_GRANT_NBR
PartnerBudgetPeriod FM: Partner Budget Period FM_BUDGET_PERIOD
PubSecBudgetAccount Budget Account SAKNR
PubSecBudgetAccountCoCode Budget Account Company Code BUKRS
MaterialPriceUnitQty Price unit PACK3
NumberOfItems Number of Items DEC12
ClearingStatusSelection Clearing Status Selection FIS_CLEARINGSTATUSSELECTION
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T003.MANDT
Accounts Receivable Is Pledged
  • Client
  • Company Code
  • Accounts Receivable Is Pledged
  • Accounts Receivable Pledging Code
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == TCESSION.CLIENT
  • P_OPERATIONALACCTGDOCBROWSER.COMPANYCODE == TCESSION.COMPANY
  • P_OPERATIONALACCTGDOCBROWSER.ACCOUNTSRECEIVABLEISPLEDGED == TCESSION.CESSION_KZ
  • P_OPERATIONALACCTGDOCBROWSER.ACCTSRECEIVABLEPLEDGINGCODE == TCESSION.CESSION_KZ
Accounts Receivable Pledging Code
  • Client
  • Company Code
  • Accounts Receivable Is Pledged
  • Accounts Receivable Pledging Code
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == TCESSION.CLIENT
  • P_OPERATIONALACCTGDOCBROWSER.COMPANYCODE == TCESSION.COMPANY
  • P_OPERATIONALACCTGDOCBROWSER.ACCOUNTSRECEIVABLEISPLEDGED == TCESSION.CESSION_KZ
  • P_OPERATIONALACCTGDOCBROWSER.ACCTSRECEIVABLEPLEDGINGCODE == TCESSION.CESSION_KZ
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.ASSETTRANSACTIONTYPE == TABW.BWASL
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == TABW.MANDT
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == TCURC.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.BASEUNIT == T006.MSEHI
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.BUSINESSAREA == TGSB.GSBER
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.CHARTOFACCOUNTS == T004.KTOPL
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T001.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == TKA01.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.CONTROLLINGAREA == TKA01.KOKRS
Credit Control Area
  • Credit Control Area
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.CREDITCONTROLAREA == T014.KKBER
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T014.MANDT
Credit Control Area Currency
  • Client
  • Credit Control Area Currency
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == TCURC.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.CREDITCONTROLAREACURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.CUSTOMER == KNA1.KUNNR
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == KNA1.MANDT
Country/Region of Destination for Delivery of Goods
  • Country/Region of Destination for Delivery of Goods
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.DELIVOFGOODSDESTCOUNTRY == T005.LAND1
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T005.MANDT
Dunning Area
  • Client
  • Company Code
  • Dunning Area
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T047M.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.COMPANYCODE == T047M.BUKRS
  • P_OPERATIONALACCTGDOCBROWSER.DUNNINGAREA == T047M.MABER
Dunning Blocking Reason
  • Client
  • Dunning Blocking Reason
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T040S.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.DUNNINGBLOCKINGREASON == T040S.MANSP
Dunning Key
  • Dunning Key
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.DUNNINGKEY == T040.MSCHL
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T040.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T856.MANDT
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == SKB1.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.COMPANYCODE == SKB1.BUKRS
  • P_OPERATIONALACCTGDOCBROWSER.GLACCOUNT == SKB1.SAKNR
Unit of entry
  • Client
  • Unit of entry
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T006.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.GOODSMOVEMENTENTRYUNIT == T006.MSEHI
House Bank Key
  • House Bank Key
  • Client
  • ?
  • P_OPERATIONALACCTGDOCBROWSER.HOUSEBANK == T012.HBKID
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T012.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.[column in domain "BUKRS"] == T012.BUKRS
House Bank Account
  • House Bank Key
  • House Bank Account
  • Client
  • ?
  • P_OPERATIONALACCTGDOCBROWSER.HOUSEBANK == T012K.HBKID
  • P_OPERATIONALACCTGDOCBROWSER.HOUSEBANKACCOUNT == T012K.HKTID
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T012K.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.[column in domain "BUKRS"] == T012K.BUKRS
Valuation Type
  • Client
  • Valuation Type
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T149D.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.INVENTORYVALUATIONTYPE == T149D.BWTAR
Joint venture
  • Client
  • Joint venture
  • Company Code
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T8JV.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.JOINTVENTURE == T8JV.VNAME
  • P_OPERATIONALACCTGDOCBROWSER.COMPANYCODE == T8JV.BUKRS
Recovery Indicator
  • Recovery Indicator
  • Client
  • Company Code
  • P_OPERATIONALACCTGDOCBROWSER.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T8JJ.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.COMPANYCODE == T8JJ.BUKRS
Equity group
  • Equity group
  • Client
  • Joint venture
  • Company Code
  • P_OPERATIONALACCTGDOCBROWSER.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T8JF.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.JOINTVENTURE == T8JF.VNAME
  • P_OPERATIONALACCTGDOCBROWSER.COMPANYCODE == T8JF.BUKRS
Equity type
  • Client
  • Company Code
  • Equity type
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T8JE.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.COMPANYCODE == T8JE.BUKRS
  • P_OPERATIONALACCTGDOCBROWSER.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
Ledger Group
  • Client
  • Ledger Group
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == FAGL_TLDGRP.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.LEDGERGROUP == FAGL_TLDGRP.LDGRP
Operational General Ledger Account
  • Client
  • Operational General Ledger Account
  • Company Code
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == SKB1.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.OPERATIONALGLACCOUNT == SKB1.SAKNR
  • P_OPERATIONALACCTGDOCBROWSER.COMPANYCODE == SKB1.BUKRS
Order ID
  • Order ID
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.ORDERID == AUFK.AUFNR
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == AUFK.MANDT
Partner Business Area
  • Client
  • Partner Business Area
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == TGSB.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T880.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.PARTNERCOMPANY == T880.RCOMP
Partner Profit Center
  • ?
  • Partner Profit Center
  • Client
  • ?
  • P_OPERATIONALACCTGDOCBROWSER.[column in domain "DATBI"] == CEPC.DATBI
  • P_OPERATIONALACCTGDOCBROWSER.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == CEPC.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.[column in domain "KOKRS"] == CEPC.KOKRS
Payment Blocking Reason
  • Client
  • Payment Blocking Reason
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T008.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.PAYMENTBLOCKINGREASON == T008.ZAHLS
Currency for Automatic Payment
  • Currency for Automatic Payment
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.PAYMENTCURRENCY == TCURC.WAERS
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == TCURC.MANDT
Payment Difference Reason
  • Client
  • Company Code
  • Payment Difference Reason
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T053R.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.COMPANYCODE == T053R.BUKRS
  • P_OPERATIONALACCTGDOCBROWSER.PAYMENTDIFFERENCEREASON == T053R.RSTGR
Payment Method
  • Payment Method
  • Client
  • ?
  • P_OPERATIONALACCTGDOCBROWSER.PAYMENTMETHOD == T042Z.ZLSCH
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T042Z.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.[column in domain "LAND1"] == T042Z.LAND1
Payment Method Supplement
  • Payment Method Supplement
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T042F.MANDT
Planning Level
  • Planning Level
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.PLANNINGLEVEL == T036.EBENE
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T036.MANDT
Plant
  • Client
  • Plant
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T001W.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.PLANT == T001W.WERKS
Posting Key
  • Posting Key
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.POSTINGKEY == TBSL.BSCHL
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == TBSL.MANDT
Product Number
  • Client
  • Product Number
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == MARA.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.PRODUCT == MARA.MATNR
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.PURCHASINGDOCUMENTPRICEUNIT == T006.MSEHI
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T006.MANDT
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • ?
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T005S.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.REGION == T005S.BLAND
  • P_OPERATIONALACCTGDOCBROWSER.[column in domain "LAND1"] == T005S.LAND1
Special G/L Indicator
  • Special G/L Indicator
  • Client
  • ?
  • P_OPERATIONALACCTGDOCBROWSER.SPECIALGLCODE == T074U.UMSKZ
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T074U.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.[column in domain "KOART"] == T074U.KOART
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T015L.MANDT
Supplier
  • Supplier
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.SUPPLIER == LFA1.LIFNR
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == LFA1.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.SUPPLYINGCOUNTRY == T005.LAND1
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T005.MANDT
Tax on Sales/Purchases Code
  • ?
  • Client
  • Tax on Sales/Purchases Code
  • P_OPERATIONALACCTGDOCBROWSER.[column in domain "KALSM_D"] == T007A.KALSM
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T007A.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.TAXCODE == T007A.MWSKZ
Tax Code 1 for Distribution
  • ?
  • Client
  • Tax Code 1 for Distribution
  • P_OPERATIONALACCTGDOCBROWSER.[column in domain "KALSM_D"] == T007A.KALSM
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T007A.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.TAXDISTRIBUTIONCODE1 == T007A.MWSKZ
Tax Code 2 for Distribution
  • ?
  • Tax Code 2 for Distribution
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.[column in domain "KALSM_D"] == T007A.KALSM
  • P_OPERATIONALACCTGDOCBROWSER.TAXDISTRIBUTIONCODE2 == T007A.MWSKZ
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T007A.MANDT
Tax Code 3 for Distribution
  • ?
  • Client
  • Tax Code 3 for Distribution
  • P_OPERATIONALACCTGDOCBROWSER.[column in domain "KALSM_D"] == T007A.KALSM
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T007A.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.TAXDISTRIBUTIONCODE3 == T007A.MWSKZ
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • P_OPERATIONALACCTGDOCBROWSER.TAXJURISDICTION == TTXJ.TXJCD
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == TTXJ.MANDT
Tax Section
  • Tax Section
  • Client
  • Company Code
  • P_OPERATIONALACCTGDOCBROWSER.TAXSECTION == SECCODE.SECCODE
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == SECCODE.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.COMPANYCODE == SECCODE.BUKRS
Transaction Currency
  • Transaction Currency
  • Client
  • P_OPERATIONALACCTGDOCBROWSER.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == TCURC.MANDT
Valuation area
  • Client
  • Valuation area
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T001K.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.VALUATIONAREA == T001K.BWKEY
Withholding Tax Code
  • Client
  • Withholding Tax Code
  • ?
  • P_OPERATIONALACCTGDOCBROWSER.MANDT == T059Q.MANDT
  • P_OPERATIONALACCTGDOCBROWSER.WITHHOLDINGTAXCODE == T059Q.QSSKZ
  • P_OPERATIONALACCTGDOCBROWSER.[column in domain "LAND1"] == T059Q.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Ledger
  • Ledger
  • Client
  • Company Code