P_FIARCN_CUST_BALANCE01

DDL: P_FIARCN_CUST_BALANCE01 SQL: PVFIARCNCUSTBAL1 Type: view CONSUMPTION Package: GLO_FIN_CN
115 Fields 3 Data Sources

Customer Balance

P_FIARCN_CUST_BALANCE01 is a Consumption CDS View that provides data about "Customer Balance" in SAP S/4HANA. It reads from 3 data sources (I_FiscalYearForCompanyCode, I_GLAccountLineItem, I_GLAccountLineItem) and exposes 115 fields with key fields CompanyCode, FiscalYear, FiscalPeriod, GLAccount, Supplier. Part of development package GLO_FIN_CN.

Data Sources (3)

SourceAliasJoin Type
I_FiscalYearForCompanyCode _fiscalyear inner
I_GLAccountLineItem item from
I_GLAccountLineItem item union_all

Parameters (2)

NameTypeDefault
P_CompanyCode bukrs
P_FiscalYear gjahr

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PVFIARCNCUSTBAL1 view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (115)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_GLAccountLineItem CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY GLAccount GLAccount General Ledger
KEY Supplier Supplier Supplier
KEY Customer Customer Sold-to Party
KEY SpecialGLCode SpecialGLCode Special G/L Ind
KEY ProfitCenter ProfitCenter Profit Center
KEY Segment Segment Segment number
KEY BusinessArea BusinessArea Business Area
KEY AccountingDocumentType I_GLAccountLineItem AccountingDocumentType Journal Entry Type
AssignmentReference I_GLAccountLineItem AssignmentReference Assignment Reference
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency Local Currency
GlobalCurrency I_GLAccountLineItem GlobalCurrency GM Billing Element: Global Currency
FreeDefinedCurrency1 I_GLAccountLineItem FreeDefinedCurrency1 Freely Defined Currency 1
FreeDefinedCurrency2 I_GLAccountLineItem FreeDefinedCurrency2 Freely Defined Currency 2
FreeDefinedCurrency3 I_GLAccountLineItem FreeDefinedCurrency3 Freely Defined Currency 3
FreeDefinedCurrency4 I_GLAccountLineItem FreeDefinedCurrency4 Freely Defined Currency 4
FreeDefinedCurrency5 I_GLAccountLineItem FreeDefinedCurrency5 Freely Defined Currency 5
FreeDefinedCurrency6 I_GLAccountLineItem FreeDefinedCurrency6 Freely Defined Currency 6
FreeDefinedCurrency7 I_GLAccountLineItem FreeDefinedCurrency7 Freely Defined Currency 7
FreeDefinedCurrency8 I_GLAccountLineItem FreeDefinedCurrency8 Freely Defined Currency 8
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
DebitAmountInTransCrcy DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy CreditAmountInTransCrcy Credit Amt in DC
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
DebitAmountInGlobalCrcy DebitAmountInGlobalCrcy
DebitAmountInFreeDefinedCrcy1 DebitAmountInFreeDefinedCrcy1
DebitAmountInFreeDefinedCrcy2 DebitAmountInFreeDefinedCrcy2
DebitAmountInFreeDefinedCrcy3 DebitAmountInFreeDefinedCrcy3
DebitAmountInFreeDefinedCrcy4 DebitAmountInFreeDefinedCrcy4
DebitAmountInFreeDefinedCrcy5 DebitAmountInFreeDefinedCrcy5
DebitAmountInFreeDefinedCrcy6 DebitAmountInFreeDefinedCrcy6
DebitAmountInFreeDefinedCrcy7 DebitAmountInFreeDefinedCrcy7
DebitAmountInFreeDefinedCrcy8 DebitAmountInFreeDefinedCrcy8
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
CreditAmountInGlobalCrcy CreditAmountInGlobalCrcy
CreditAmountInFreeDefinedCrcy1 CreditAmountInFreeDefinedCrcy1
CreditAmountInFreeDefinedCrcy2 CreditAmountInFreeDefinedCrcy2
CreditAmountInFreeDefinedCrcy3 CreditAmountInFreeDefinedCrcy3
CreditAmountInFreeDefinedCrcy4 CreditAmountInFreeDefinedCrcy4
CreditAmountInFreeDefinedCrcy5 CreditAmountInFreeDefinedCrcy5
CreditAmountInFreeDefinedCrcy6 CreditAmountInFreeDefinedCrcy6
CreditAmountInFreeDefinedCrcy7 CreditAmountInFreeDefinedCrcy7
CreditAmountInFreeDefinedCrcy8 CreditAmountInFreeDefinedCrcy8
_Supplier I_GLAccountLineItem _Supplier
CompanyCode Receiver Company Code
KEY FiscalYear G/L Fiscal Year
KEY FiscalPeriod Tax period
KEY GLAccount GLAccount General Ledger
KEY Supplier Supplier Supplier
KEY Customer Customer Sold-to Party
KEY SpecialGLCode SpecialGLCode Special G/L Ind
KEY ProfitCenter ProfitCenter Profit Center
KEY Segment Segment Segment number
KEY BusinessArea BusinessArea Business Area
KEY AccountingDocumentType I_GLAccountLineItem AccountingDocumentType Journal Entry Type
AssignmentReference I_GLAccountLineItem AssignmentReference Assignment Reference
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency Local Currency
GlobalCurrency I_GLAccountLineItem GlobalCurrency GM Billing Element: Global Currency
FreeDefinedCurrency1 I_GLAccountLineItem FreeDefinedCurrency1 Freely Defined Currency 1
FreeDefinedCurrency2 I_GLAccountLineItem FreeDefinedCurrency2 Freely Defined Currency 2
FreeDefinedCurrency3 I_GLAccountLineItem FreeDefinedCurrency3 Freely Defined Currency 3
FreeDefinedCurrency4 I_GLAccountLineItem FreeDefinedCurrency4 Freely Defined Currency 4
FreeDefinedCurrency5 I_GLAccountLineItem FreeDefinedCurrency5 Freely Defined Currency 5
FreeDefinedCurrency6 I_GLAccountLineItem FreeDefinedCurrency6 Freely Defined Currency 6
FreeDefinedCurrency7 I_GLAccountLineItem FreeDefinedCurrency7 Freely Defined Currency 7
FreeDefinedCurrency8 I_GLAccountLineItem FreeDefinedCurrency8 Freely Defined Currency 8
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
DebitAmountInTransCrcy DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy CreditAmountInTransCrcy Credit Amt in DC
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
DebitAmountInGlobalCrcy DebitAmountInGlobalCrcy
DebitAmountInFreeDefinedCrcy1 DebitAmountInFreeDefinedCrcy1
DebitAmountInFreeDefinedCrcy2 DebitAmountInFreeDefinedCrcy2
DebitAmountInFreeDefinedCrcy3 DebitAmountInFreeDefinedCrcy3
DebitAmountInFreeDefinedCrcy4 DebitAmountInFreeDefinedCrcy4
DebitAmountInFreeDefinedCrcy5 DebitAmountInFreeDefinedCrcy5
DebitAmountInFreeDefinedCrcy6 DebitAmountInFreeDefinedCrcy6
DebitAmountInFreeDefinedCrcy7 DebitAmountInFreeDefinedCrcy7
DebitAmountInFreeDefinedCrcy8 DebitAmountInFreeDefinedCrcy8
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
CreditAmountInGlobalCrcy CreditAmountInGlobalCrcy
CreditAmountInFreeDefinedCrcy1 CreditAmountInFreeDefinedCrcy1
CreditAmountInFreeDefinedCrcy2 CreditAmountInFreeDefinedCrcy2
CreditAmountInFreeDefinedCrcy3 CreditAmountInFreeDefinedCrcy3
CreditAmountInFreeDefinedCrcy4 CreditAmountInFreeDefinedCrcy4
CreditAmountInFreeDefinedCrcy5 CreditAmountInFreeDefinedCrcy5
CreditAmountInFreeDefinedCrcy6 CreditAmountInFreeDefinedCrcy6
CreditAmountInFreeDefinedCrcy7 CreditAmountInFreeDefinedCrcy7
CreditAmountInFreeDefinedCrcy8 CreditAmountInFreeDefinedCrcy8
_Supplier I_GLAccountLineItem _Supplier
BusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_FIARCN_CUST_BALANCE01.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PVFIARCNCUSTBAL1
-- Parameters: P_CompanyCode : bukrs, P_FiscalYear : gjahr

CREATE VIEW P_FIARCN_CUST_BALANCE01 AS
SELECT
  item.CompanyCode AS CompanyCode,
  FiscalYear,
  FiscalPeriod,
  GLAccount,
  Supplier,
  Customer,
  SpecialGLCode,
  ProfitCenter,
  Segment,
  BusinessArea,
  item.AccountingDocumentType AS AccountingDocumentType,
  item.AssignmentReference AS AssignmentReference,
  item.CompanyCodeCurrency AS CompanyCodeCurrency,
  item.GlobalCurrency AS GlobalCurrency,
  item.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  item.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  item.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  item.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  item.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  item.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  item.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  item.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  TransactionCurrency,
  AmountInTransactionCurrency,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  DebitAmountInCoCodeCrcy,
  DebitAmountInGlobalCrcy,
  DebitAmountInFreeDefinedCrcy1,
  DebitAmountInFreeDefinedCrcy2,
  DebitAmountInFreeDefinedCrcy3,
  DebitAmountInFreeDefinedCrcy4,
  DebitAmountInFreeDefinedCrcy5,
  DebitAmountInFreeDefinedCrcy6,
  DebitAmountInFreeDefinedCrcy7,
  DebitAmountInFreeDefinedCrcy8,
  CreditAmountInCoCodeCrcy,
  CreditAmountInGlobalCrcy,
  CreditAmountInFreeDefinedCrcy1,
  CreditAmountInFreeDefinedCrcy2,
  CreditAmountInFreeDefinedCrcy3,
  CreditAmountInFreeDefinedCrcy4,
  CreditAmountInFreeDefinedCrcy5,
  CreditAmountInFreeDefinedCrcy6,
  CreditAmountInFreeDefinedCrcy7,
  CreditAmountInFreeDefinedCrcy8,
  item._Supplier AS _Supplier,
  _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner
FROM I_GLAccountLineItem AS item
INNER JOIN I_FiscalYearForCompanyCode AS _fiscalyear ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_GLAccountLineItem
;

Learn More