P_CN_JOURNALENTRYITEM

Journal Entry Items | view: PCNJRNLENTRITM | Extraction: Not supported | Component: E-Payment Integration China
Tables used: ACDOCABKPFBSEG_ADDBSEGT001T014FINSC_LEDGER_REP
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Six-figure number of line item
Column Name Description
💲 Additional Currency 2 (AdditionalCurrency2):
AmountInTransCrcyWithNoSign null
AmountInAdditionalCurrency2 Amount in Additional Currency 2
ValuationDiffAmtInAddlCrcy2 Valuation Difference Amount in Additional Currency 2
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
TaxAmountInCoCodeCrcy Signed Tax Amount in Company Code Currency
ValuationDiffAmtInCoCodeCrcy Valuation Difference Amount In Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
TaxAmount Tax Amount in Transaction 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
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
ClearingDate Clearing Date
ClearingCreationDate Clearing Creation Date
ValueDate Value date
DueCalculationBaseDate Due Calculation Base Date
SettlementReferenceDate Reference Date for Settlement
PostingDate Posting Date
NetDueDate Due Date for Net Payment
Column Name Description
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
IsAutomaticallyCreated Is Automatically Created Show values
IsBalanceSheetAccount Is Balance Sheet Account Show values
BillOfExchangeUsage Bill of Exchange Usage Type Show values
TreasuryContractType Treasury Contract Type Show values
ClearingIsReversed Clearing Is Reversed Show values
OffsettingAccountType Offsetting Account Type Show values
Column Name Description Domain name
ClearingAccountingDocument Clearing Journal Entry BELNR
SpecialGLCode null
SpecialGLTransactionType null
BusinessArea Business Area GSBER
PartnerBusinessArea Partner Business Area GSBER
WithholdingTaxCode Withholding Tax Code QSSKZ
TaxType null
TransactionTypeDetermination Transaction Key CHAR3
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
CorporateGroupAccount Corporate Group Account SAKNR
PlanningLevel null
CostCenter Cost Center KOSTL
Project Project definition PS_PSPID
BillingDocument null
SalesDocument null
SalesDocumentItem null
ScheduleLine null
AssetTransactionType Asset Transaction Type BWASL
AssetValueDate null
PersonnelNumber null
IsSalesRelated null
LineItemDisplayIsEnabled null
IsNotCashDiscountLiable null
IsUsedInPaymentTransaction null
OperationalGLAccount null
Customer null
Supplier null
BranchAccount null
ProfitLossAccountType Profit Loss Account Type CHAR2
SpecialGLAccountAssignment null
PaymentTerms null
CashDiscount1Days null
CashDiscount2Days null
NetPaymentDays null
CashDiscount1Percent null
CashDiscount2Percent null
PaymentMethod null
PaymentBlockingReason null
FixedCashDiscount null
BPBankAccountInternalID null
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
FollowOnDocumentType Follow-On Document Type REBZT
StateCentralBankPaymentReason null
SupplyingCountry null
InvoiceList null
PurchasingDocument null
PurchasingDocumentItem null
AccountAssignmentNumber null
VATRegistration null
DelivOfGoodsDestCountry null
PaymentDifferenceReason null
AssetContract Asset Contract RANL
CashFlowType Flow Type SBEWART
RealEstateObject Internal Key for Real Estate Object IMKEY
CommitmentItem Commitment Item FIPOS
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 PS_POSNR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
PaymentMethodSupplement Payment Method Supplement UZAWE
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
FundsCenter Funds Management Center FISTL
Fund Fund BP_GEBER
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
ClearingItem Clearing Item AGZEI
CostCtrActivityType Activity Type LSTAR
BusinessProcess Business Process CO_PRZNR
GrantID Grant GM_GRANT_NBR
FundedProgram Funded Program FM_MEASURE
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
Segment Segment for Segmental Reporting FB_SEGMENT
PartnerSegment Partner Segment for Segmental Reporting FB_SEGMENT
PartnerFunctionalArea Partner Functional Area FKBER
CostElement Cost Element KSTAR
OffsettingAccount Offsetting Account GKONT
PartnerFund Partner Fund BP_GEBER
PartnerGrant Partner Grant GM_GRANT_NBR
BudgetPeriod Budget Period FM_BUDGET_PERIOD
PartnerBudgetPeriod FM: Partner Budget Period FM_BUDGET_PERIOD
NumberOfItems Number of Items DEC12
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_CN_JOURNALENTRYITEM.MANDT == T006.MANDT
  • P_CN_JOURNALENTRYITEM.BASEUNIT == T006.MSEHI
Business Place
  • ?
  • Business Place
  • Client
  • Company Code
  • P_CN_JOURNALENTRYITEM.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
  • P_CN_JOURNALENTRYITEM.BUSINESSPLACE == J_1BBRANCH.BRANCH
  • P_CN_JOURNALENTRYITEM.MANDT == J_1BBRANCH.MANDT
  • P_CN_JOURNALENTRYITEM.COMPANYCODE == J_1BBRANCH.BUKRS
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_CN_JOURNALENTRYITEM.MANDT == T004.MANDT
  • P_CN_JOURNALENTRYITEM.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • P_CN_JOURNALENTRYITEM.MANDT == T001.MANDT
  • P_CN_JOURNALENTRYITEM.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • P_CN_JOURNALENTRYITEM.CONTROLLINGAREA == TKA01.KOKRS
  • P_CN_JOURNALENTRYITEM.MANDT == TKA01.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • P_CN_JOURNALENTRYITEM.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • P_CN_JOURNALENTRYITEM.MANDT == T856.MANDT
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_CN_JOURNALENTRYITEM.GLACCOUNT == SKA1.SAKNR
  • P_CN_JOURNALENTRYITEM.MANDT == SKA1.MANDT
  • P_CN_JOURNALENTRYITEM.COMPANYCODE == SKA1.KTOPL
House Bank Key
  • Client
  • Company Code
  • House Bank Key
  • P_CN_JOURNALENTRYITEM.MANDT == T012.MANDT
  • P_CN_JOURNALENTRYITEM.COMPANYCODE == T012.BUKRS
  • P_CN_JOURNALENTRYITEM.HOUSEBANK == T012.HBKID
House Bank Account
  • Client
  • Company Code
  • House Bank Key
  • House Bank Account
  • P_CN_JOURNALENTRYITEM.MANDT == T012K.MANDT
  • P_CN_JOURNALENTRYITEM.COMPANYCODE == T012K.BUKRS
  • P_CN_JOURNALENTRYITEM.HOUSEBANK == T012K.HBKID
  • P_CN_JOURNALENTRYITEM.HOUSEBANKACCOUNT == T012K.HKTID
Valuation Type
  • Valuation Type
  • Client
  • P_CN_JOURNALENTRYITEM.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • P_CN_JOURNALENTRYITEM.MANDT == T149D.MANDT
Joint venture
  • Client
  • Company Code
  • Joint venture
  • P_CN_JOURNALENTRYITEM.MANDT == T8JV.MANDT
  • P_CN_JOURNALENTRYITEM.COMPANYCODE == T8JV.BUKRS
  • P_CN_JOURNALENTRYITEM.JOINTVENTURE == T8JV.VNAME
Recovery Indicator
  • Recovery Indicator
  • Client
  • Company Code
  • P_CN_JOURNALENTRYITEM.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • P_CN_JOURNALENTRYITEM.MANDT == T8JJ.MANDT
  • P_CN_JOURNALENTRYITEM.COMPANYCODE == T8JJ.BUKRS
Equity group
  • Client
  • Company Code
  • Equity group
  • Joint venture
  • P_CN_JOURNALENTRYITEM.MANDT == T8JF.MANDT
  • P_CN_JOURNALENTRYITEM.COMPANYCODE == T8JF.BUKRS
  • P_CN_JOURNALENTRYITEM.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • P_CN_JOURNALENTRYITEM.JOINTVENTURE == T8JF.VNAME
Material Number
  • Client
  • Material Number
  • P_CN_JOURNALENTRYITEM.MANDT == MARA.MANDT
  • P_CN_JOURNALENTRYITEM.MATERIAL == MARA.MATNR
Order ID
  • Order ID
  • Client
  • P_CN_JOURNALENTRYITEM.ORDERID == AUFK.AUFNR
  • P_CN_JOURNALENTRYITEM.MANDT == AUFK.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_CN_JOURNALENTRYITEM.MANDT == T880.MANDT
  • P_CN_JOURNALENTRYITEM.PARTNERCOMPANY == T880.RCOMP
Partner Profit Center
  • ?
  • Controlling Area
  • Client
  • Partner Profit Center
  • P_CN_JOURNALENTRYITEM.[column in domain "DATBI"] == CEPC.DATBI
  • P_CN_JOURNALENTRYITEM.CONTROLLINGAREA == CEPC.KOKRS
  • P_CN_JOURNALENTRYITEM.MANDT == CEPC.MANDT
  • P_CN_JOURNALENTRYITEM.PARTNERPROFITCENTER == CEPC.PRCTR
Plant
  • Plant
  • Client
  • P_CN_JOURNALENTRYITEM.PLANT == T001W.WERKS
  • P_CN_JOURNALENTRYITEM.MANDT == T001W.MANDT
Posting Key
  • Client
  • Posting Key
  • P_CN_JOURNALENTRYITEM.MANDT == TBSL.MANDT
  • P_CN_JOURNALENTRYITEM.POSTINGKEY == TBSL.BSCHL
Profit Center
  • ?
  • Controlling Area
  • Client
  • Profit Center
  • P_CN_JOURNALENTRYITEM.[column in domain "DATBI"] == CEPC.DATBI
  • P_CN_JOURNALENTRYITEM.CONTROLLINGAREA == CEPC.KOKRS
  • P_CN_JOURNALENTRYITEM.MANDT == CEPC.MANDT
  • P_CN_JOURNALENTRYITEM.PROFITCENTER == CEPC.PRCTR
Tax on Sales/Purchases Code
  • ?
  • Client
  • Tax on Sales/Purchases Code
  • P_CN_JOURNALENTRYITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • P_CN_JOURNALENTRYITEM.MANDT == T007A.MANDT
  • P_CN_JOURNALENTRYITEM.TAXCODE == T007A.MWSKZ
Tax Section
  • Tax Section
  • Client
  • Company Code
  • P_CN_JOURNALENTRYITEM.TAXSECTION == SECCODE.SECCODE
  • P_CN_JOURNALENTRYITEM.MANDT == SECCODE.MANDT
  • P_CN_JOURNALENTRYITEM.COMPANYCODE == SECCODE.BUKRS
Transaction Currency
  • Client
  • Transaction Currency
  • P_CN_JOURNALENTRYITEM.MANDT == TCURC.MANDT
  • P_CN_JOURNALENTRYITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation area
  • Client
  • Valuation area
  • P_CN_JOURNALENTRYITEM.MANDT == T001K.MANDT
  • P_CN_JOURNALENTRYITEM.VALUATIONAREA == T001K.BWKEY