P_CN_CustAcctBalRawSum

Customer Account Balance Sum | view: PCNCUSTACCTBALS | Extraction: Not supported | Component: Financials China
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
GLAccount FK G/L Account
AlternativeGLAccount Alternative Account Number in Company Code
Customer FK Customer Number
Supplier FK Supplier
DisplayCurrency Company Code Currency
Column Name Description
💲 Company Code Currency (DisplayCurrency):
BalCarFwdAmtInDspCrcy null
StartingBalAmtInDspCrcy null
EndingBalAmtInDspCrcy null
DebitAmountInDspCrcy null
CreditAmountInDspCrcy null
YTDDebitAmtInDspCrcy null
YTDCrdtAmtInDspCrcy null
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_CN_CUSTACCTBALRAWSUM.COMPANYCODE == T001.BUKRS
  • P_CN_CUSTACCTBALRAWSUM.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • P_CN_CUSTACCTBALRAWSUM.CUSTOMER == KNA1.KUNNR
  • P_CN_CUSTACCTBALRAWSUM.MANDT == KNA1.MANDT
G/L Account
  • ?
  • G/L Account
  • Client
  • P_CN_CUSTACCTBALRAWSUM.[column in domain "BUKRS"] == SKB1.BUKRS
  • P_CN_CUSTACCTBALRAWSUM.GLACCOUNT == SKB1.SAKNR
  • P_CN_CUSTACCTBALRAWSUM.MANDT == SKB1.MANDT
Supplier
  • Supplier
  • Client
  • P_CN_CUSTACCTBALRAWSUM.SUPPLIER == LFA1.LIFNR
  • P_CN_CUSTACCTBALRAWSUM.MANDT == LFA1.MANDT