P_FIARCN_CUST_BALANCE07

Customer Balance | view: PVFIARCNCUSTBAL7 | Extraction: Not supported | Component: Financials China
Column Name Description
CompanyCode Company Code
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
GLAccount FK G/L Account
AlternativeGLAccount Alternative Account Number in Company Code
BusinessPartner Business Partner Number
Customer FK Customer Number
Supplier null
SpecialGLCode FK Special G/L Indicator
ProfitCenter FK Profit Center
BusinessArea FK Business Area
DisplayCurrency Company Code Currency
TransactionCurrency FK Transaction Currency
Column Name Description
💲 Company Code Currency (DisplayCurrency):
BalCarFwdAmtInDspCrcy null
StartingBalAmtInDspCrcy null
EndingBalAmtInDspCrcy null
DebitAmountInDspCrcy null
CreditAmountInDspCrcy null
YTDDebitAmtInDspCrcy null
YTDCrdtAmtInDspCrcy null
💲 Transaction Currency (TransactionCurrency):
BalCarFwdAmtInTransacCrcy null
StartingBalanceAmtInTransCrcy null
DebitAmountInTransCrcy null
CreditAmountInTransCrcy null
EndingBalanceAmtInTransCrcy null
YTDDebitAmtInTransCrcy null
YTDCrdtAmtInTransCrcy null
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
AssignmentReference Assignment Reference ZUONR
CustomerName Name of Customer TEXT80
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
CustomerVATRegistration Tax Number 5 CHAR60
CustomerCityName City TEXT40
BusinessPartnerName null
CustomerSearchText Search Term CHAR30
GLAccountName G/L Account Name TEXT20
AlternativeGLAccountName G/L Account Name TEXT20
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • P_FIARCN_CUST_BALANCE07.BUSINESSAREA == TGSB.GSBER
  • P_FIARCN_CUST_BALANCE07.MANDT == TGSB.MANDT
Customer Number
  • Customer Number
  • Client
  • P_FIARCN_CUST_BALANCE07.CUSTOMER == KNA1.KUNNR
  • P_FIARCN_CUST_BALANCE07.MANDT == KNA1.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • P_FIARCN_CUST_BALANCE07.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • P_FIARCN_CUST_BALANCE07.MANDT == T077D.MANDT
Country key
  • Client
  • Country/Region Key
  • P_FIARCN_CUST_BALANCE07.MANDT == T005.MANDT
  • P_FIARCN_CUST_BALANCE07.CUSTOMERCOUNTRY == T005.LAND1
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • P_FIARCN_CUST_BALANCE07.MANDT == T005S.MANDT
  • P_FIARCN_CUST_BALANCE07.CUSTOMERCOUNTRY == T005S.LAND1
  • P_FIARCN_CUST_BALANCE07.CUSTOMERREGION == T005S.BLAND
G/L Account
  • ?
  • G/L Account
  • Client
  • P_FIARCN_CUST_BALANCE07.[column in domain "BUKRS"] == SKB1.BUKRS
  • P_FIARCN_CUST_BALANCE07.GLACCOUNT == SKB1.SAKNR
  • P_FIARCN_CUST_BALANCE07.MANDT == SKB1.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • P_FIARCN_CUST_BALANCE07.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_FIARCN_CUST_BALANCE07.[column in domain "DATBI"] == CEPC.DATBI
  • P_FIARCN_CUST_BALANCE07.PROFITCENTER == CEPC.PRCTR
  • P_FIARCN_CUST_BALANCE07.MANDT == CEPC.MANDT
Special G/L Indicator
  • Special G/L Indicator
  • ?
  • Client
  • P_FIARCN_CUST_BALANCE07.SPECIALGLCODE == T074U.UMSKZ
  • P_FIARCN_CUST_BALANCE07.[column in domain "KOART"] == T074U.KOART
  • P_FIARCN_CUST_BALANCE07.MANDT == T074U.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_FIARCN_CUST_BALANCE07.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_FIARCN_CUST_BALANCE07.MANDT == TCURC.MANDT