P_CN_CustLineItemRaw

Customer Line item Raw Data | view: PCNCUSTLINEITEMR | Extraction: Not supported | Component: Financials China
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
💲 Company Code Currency (DisplayCurrency):
AmountInDisplayCurrency null
DebitAmountInDisplayCrcy null
CreditAmountInDisplayCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ClearingDate Clearing Date
Column Name Description
FinancialAccountType Account Type Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
AlternativeGLAccount Alternative Account Number in Company Code SAKNR
AssignmentReference Assignment Reference ZUONR
IsCleared null
DocumentItemText Item Text TEXT50
ClearingAccountingDocument Clearing Journal Entry BELNR
AlternativeReferenceDocument Alternative Reference Document FIS_XBLNR_ALT_WO_EXIT
AccountingDocumentHeaderText Document Header Text TEXT25
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_CN_CUSTLINEITEMRAW.MANDT == T003.MANDT
  • P_CN_CUSTLINEITEMRAW.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Business Area
  • Business Area
  • Client
  • P_CN_CUSTLINEITEMRAW.BUSINESSAREA == TGSB.GSBER
  • P_CN_CUSTLINEITEMRAW.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • P_CN_CUSTLINEITEMRAW.COMPANYCODE == T001.BUKRS
  • P_CN_CUSTLINEITEMRAW.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • P_CN_CUSTLINEITEMRAW.CUSTOMER == KNA1.KUNNR
  • P_CN_CUSTLINEITEMRAW.MANDT == KNA1.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • P_CN_CUSTLINEITEMRAW.COMPANYCODE == SKB1.BUKRS
  • P_CN_CUSTLINEITEMRAW.MANDT == SKB1.MANDT
  • P_CN_CUSTLINEITEMRAW.GLACCOUNT == SKB1.SAKNR
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • P_CN_CUSTLINEITEMRAW.MANDT == CEPC.MANDT
  • P_CN_CUSTLINEITEMRAW.[column in domain "DATBI"] == CEPC.DATBI
  • P_CN_CUSTLINEITEMRAW.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_CN_CUSTLINEITEMRAW.PROFITCENTER == CEPC.PRCTR
Special G/L Indicator
  • Account Type
  • Special G/L Indicator
  • Client
  • P_CN_CUSTLINEITEMRAW.FINANCIALACCOUNTTYPE == T074U.KOART
  • P_CN_CUSTLINEITEMRAW.SPECIALGLCODE == T074U.UMSKZ
  • P_CN_CUSTLINEITEMRAW.MANDT == T074U.MANDT
Supplier
  • Supplier
  • Client
  • P_CN_CUSTLINEITEMRAW.SUPPLIER == LFA1.LIFNR
  • P_CN_CUSTLINEITEMRAW.MANDT == LFA1.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_CN_CUSTLINEITEMRAW.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_CN_CUSTLINEITEMRAW.MANDT == TCURC.MANDT