P_FIARCN_CUST_BALANCE06

DDL: P_FIARCN_CUST_BALANCE06 SQL: PVFIARCNCUSTBAL6 Type: view CONSUMPTION Package: GLO_FIN_CN
117 Fields 3 Data Sources 1 Associations

Customer Balance

P_FIARCN_CUST_BALANCE06 is a Consumption CDS View that provides data about "Customer Balance" in SAP S/4HANA. It reads from 3 data sources (P_FIARCN_CUST_BALANCE01, P_FIARCN_CUST_BALANCE03, P_FIARCN_CUST_BALANCE05) and exposes 117 fields with key fields CompanyCode, FiscalYear, FiscalPeriod, GLAccount, AlternativeGLAccount. It has 1 association to related views. Part of development package GLO_FIN_CN.

Data Sources (3)

SourceAliasJoin Type
P_FIARCN_CUST_BALANCE01 P_FIARCN_CUST_BALANCE01 from
P_FIARCN_CUST_BALANCE03 P_FIARCN_CUST_BALANCE03 inner
P_FIARCN_CUST_BALANCE05 P_FIARCN_CUST_BALANCE05 union_all

Parameters (2)

NameTypeDefault
P_CompanyCode bukrs
P_FiscalYear gjahr

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_GLAccountInCompanyCode _GLAccountInCompanyCode $projection.CompanyCode = _GLAccountInCompanyCode.CompanyCode and $projection.GLAccount = _GLAccountInCompanyCode.GLAccount

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PVFIARCNCUSTBAL6 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 (117)

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

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_BALANCE06.
-- 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: PVFIARCNCUSTBAL6
-- Parameters: P_CompanyCode : bukrs, P_FiscalYear : gjahr

CREATE VIEW P_FIARCN_CUST_BALANCE06 AS
SELECT
  CompanyCode,
  FiscalYear,
  FiscalPeriod,
  GLAccount,
  _GLAccountInCompanyCode.AlternativeGLAccount AS AlternativeGLAccount,
  Customer,
  cast('' as lifnr ) AS Supplier,
  SpecialGLCode,
  ProfitCenter,
  Segment,
  BusinessArea,
  AccountingDocumentType,
  AssignmentReference,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  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,
  BusinessPartner,
  _GLAccountInCompanyCode._Text[1: Language = $session.system_language].GLAccountName AS GLAccountName
FROM P_FIARCN_CUST_BALANCE01
INNER JOIN P_FIARCN_CUST_BALANCE03 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [1..1]
-- UNION ALL with additional select branch(es): P_FIARCN_CUST_BALANCE05
;

Learn More