P_FIARCN_CUST_BALANCE01

Customer Balance | view: PVFIARCNCUSTBAL1 | Extraction: Not supported | Component: Financials China
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
GLAccount FK G/L Account
Supplier FK Supplier
Customer FK Customer Number
SpecialGLCode FK Special G/L Indicator
ProfitCenter FK Profit Center
BusinessArea FK Business Area
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
AmountInGlobalCurrency Amount in Global Currency
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
DebitAmountInGlobalCrcy Debit Amount in Global Currency
DebitAmountInFreeDefinedCrcy1 Debit Amount in Free Defined Currency 1
DebitAmountInFreeDefinedCrcy2 Debit Amount in Free Defined Currency 2
DebitAmountInFreeDefinedCrcy3 Debit Amount in Free Defined Currency 3
DebitAmountInFreeDefinedCrcy4 Debit Amount in Free Defined Currency 4
DebitAmountInFreeDefinedCrcy5 Debit Amount in Free Defined Currency 5
DebitAmountInFreeDefinedCrcy6 Debit Amount in Free Defined Currency 6
DebitAmountInFreeDefinedCrcy7 Debit Amount in Free Defined Currency 7
DebitAmountInFreeDefinedCrcy8 Debit Amount in Free Defined Currency 8
CreditAmountInGlobalCrcy Credit Amount in Global Currency
CreditAmountInFreeDefinedCrcy1 Credit Amount in Free Defined Currency 1
CreditAmountInFreeDefinedCrcy2 Credit Amount in Free Defined Currency 2
CreditAmountInFreeDefinedCrcy3 Credit Amount in Free Defined Currency 3
CreditAmountInFreeDefinedCrcy4 Credit Amount in Free Defined Currency 4
CreditAmountInFreeDefinedCrcy5 Credit Amount in Free Defined Currency 5
CreditAmountInFreeDefinedCrcy6 Credit Amount in Free Defined Currency 6
CreditAmountInFreeDefinedCrcy7 Credit Amount in Free Defined Currency 7
CreditAmountInFreeDefinedCrcy8 Credit Amount in Free Defined Currency 8
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
AssignmentReference Assignment Reference ZUONR
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • P_FIARCN_CUST_BALANCE01.MANDT == TGSB.MANDT
  • P_FIARCN_CUST_BALANCE01.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • P_FIARCN_CUST_BALANCE01.MANDT == T001.MANDT
  • P_FIARCN_CUST_BALANCE01.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • P_FIARCN_CUST_BALANCE01.COMPANYCODECURRENCY == TCURC.WAERS
  • P_FIARCN_CUST_BALANCE01.MANDT == TCURC.MANDT
Customer Number
  • Customer Number
  • Client
  • P_FIARCN_CUST_BALANCE01.CUSTOMER == KNA1.KUNNR
  • P_FIARCN_CUST_BALANCE01.MANDT == KNA1.MANDT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_FIARCN_CUST_BALANCE01.MANDT == TCURC.MANDT
  • P_FIARCN_CUST_BALANCE01.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_FIARCN_CUST_BALANCE01.MANDT == TCURC.MANDT
  • P_FIARCN_CUST_BALANCE01.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_FIARCN_CUST_BALANCE01.MANDT == TCURC.MANDT
  • P_FIARCN_CUST_BALANCE01.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_FIARCN_CUST_BALANCE01.MANDT == TCURC.MANDT
  • P_FIARCN_CUST_BALANCE01.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_FIARCN_CUST_BALANCE01.MANDT == TCURC.MANDT
  • P_FIARCN_CUST_BALANCE01.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_FIARCN_CUST_BALANCE01.MANDT == TCURC.MANDT
  • P_FIARCN_CUST_BALANCE01.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_FIARCN_CUST_BALANCE01.MANDT == TCURC.MANDT
  • P_FIARCN_CUST_BALANCE01.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_FIARCN_CUST_BALANCE01.MANDT == TCURC.MANDT
  • P_FIARCN_CUST_BALANCE01.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_FIARCN_CUST_BALANCE01.GLACCOUNT == SKB1.SAKNR
  • P_FIARCN_CUST_BALANCE01.MANDT == SKB1.MANDT
  • P_FIARCN_CUST_BALANCE01.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • P_FIARCN_CUST_BALANCE01.MANDT == TCURC.MANDT
  • P_FIARCN_CUST_BALANCE01.GLOBALCURRENCY == TCURC.WAERS
Profit Center
  • ?
  • Client
  • ?
  • Profit Center
  • P_FIARCN_CUST_BALANCE01.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_FIARCN_CUST_BALANCE01.MANDT == CEPC.MANDT
  • P_FIARCN_CUST_BALANCE01.[column in domain "DATBI"] == CEPC.DATBI
  • P_FIARCN_CUST_BALANCE01.PROFITCENTER == CEPC.PRCTR
Special G/L Indicator
  • ?
  • Client
  • Special G/L Indicator
  • P_FIARCN_CUST_BALANCE01.[column in domain "KOART"] == T074U.KOART
  • P_FIARCN_CUST_BALANCE01.MANDT == T074U.MANDT
  • P_FIARCN_CUST_BALANCE01.SPECIALGLCODE == T074U.UMSKZ
Supplier
  • Client
  • Supplier
  • P_FIARCN_CUST_BALANCE01.MANDT == LFA1.MANDT
  • P_FIARCN_CUST_BALANCE01.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Transaction Currency
  • Client
  • P_FIARCN_CUST_BALANCE01.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_FIARCN_CUST_BALANCE01.MANDT == TCURC.MANDT