P_SG_OperationalAcctgDocItem

Operational Accounting Document Item | view: PSGOPACCTGDOCIT | Extraction: Not supported | Component: Financials Singapore
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
Column Name Description
DebitCreditCode Debit/Credit Code Show values
TaxType Tax Type Show values
FinancialAccountType Account Type Show values
CompanyCodeCurrencyDetnMethod Company Code Currency Determination Method Show values
IsAutomaticallyCreated Is Automatically Created Show values
Column Name Description Domain name
TransactionCode Transaction Code TCODE
ReferenceDocumentType Reference Document Type AWTYP
AccountingDocumentHeaderText Document Header Text TEXT25
BankName Name of Financial Institution TEXT60
TaxID1 Tax Number 1 STCD1
TransactionTypeDetermination Transaction Key CHAR3
ProfitLossAccountType Profit Loss Account Type CHAR2
DocumentItemText Item Text TEXT50
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_SG_OPERATIONALACCTGDOCITEM.COMPANYCODE == T001.BUKRS
  • P_SG_OPERATIONALACCTGDOCITEM.MANDT == T001.MANDT
Planning Level
  • Client
  • Planning Level
  • P_SG_OPERATIONALACCTGDOCITEM.MANDT == T036.MANDT
  • P_SG_OPERATIONALACCTGDOCITEM.PLANNINGLEVEL == T036.EBENE
Product Number
  • Client
  • Product Number
  • P_SG_OPERATIONALACCTGDOCITEM.MANDT == MARA.MANDT
  • P_SG_OPERATIONALACCTGDOCITEM.PRODUCT == MARA.MATNR
Tax on Sales/Purchases Code
  • ?
  • Client
  • Tax on Sales/Purchases Code
  • P_SG_OPERATIONALACCTGDOCITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • P_SG_OPERATIONALACCTGDOCITEM.MANDT == T007A.MANDT
  • P_SG_OPERATIONALACCTGDOCITEM.TAXCODE == T007A.MWSKZ
Transaction Currency
  • Transaction Currency
  • Client
  • P_SG_OPERATIONALACCTGDOCITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_SG_OPERATIONALACCTGDOCITEM.MANDT == TCURC.MANDT