P_CN_HouseBankwithoutRecncln

DDL: P_CN_HOUSEBANKWITHOUTRECNCLN SQL: PCNHSBKWTHOUTREC Type: view COMPOSITE
16 Fields 3 Data Sources 1 Associations

P_CN_HouseBankwithoutRecncln is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_CN_BankRecnclnStatement, P_CN_CompanyRecnclnLedger, P_HouseBankAccount) and exposes 16 fields with key fields CompanyCode, HouseBank, HouseBankAccount. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_CN_BankRecnclnStatement Brs left_outer
P_CN_CompanyRecnclnLedger Ldgr left_outer
P_HouseBankAccount T012K from

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Housebank _HouseBank T012K.hbkid = _HouseBank.HouseBank and T012K.bukrs = _HouseBank.CompanyCode

Annotations (6)

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

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_HouseBankAccount bukrs Value
KEY HouseBank P_HouseBankAccount hbkid House Bank
KEY HouseBankAccount P_HouseBankAccount hktid House Bank Account
BankAccount P_HouseBankAccount bankn Bank acct
BankAccountReferenceText P_HouseBankAccount refzl Reference info.
HouseBankCurrency P_HouseBankAccount waers Transaction Currency
GLAccount P_HouseBankAccount hkont Transfer acct
Ledger P_CN_CompanyRecnclnLedger Ledger Ledger
AdjustedBkAcctBalanceAmt I_CN_BankRecnclnStatement AdjustedBkAcctBalanceAmt Adj.Closing Balance
AdjustedGLAcctBalanceAmt I_CN_BankRecnclnStatement AdjustedGLAcctBalanceAmt Adj.Closing Balance
UnmatchedIncgBkStmntPayt I_CN_BankRecnclnStatement UnmatchedIncgBkStmntPayt Umtchd Incing. In BK
UnmatchedIncgJrnlEntrPayt I_CN_BankRecnclnStatement UnmatchedIncgJrnlEntrPayt Umtchd Incing. In JE
UnmatchedOutgBkStmntPayt I_CN_BankRecnclnStatement UnmatchedOutgBkStmntPayt Umtchd Otcing. In BK
UnmatchedOutgJrnlEntrPayt I_CN_BankRecnclnStatement UnmatchedOutgJrnlEntrPayt Umtchd Otcing. In JE
CreationUserName I_CN_BankRecnclnStatement CreationUserName User Name
BankName

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_CN_HouseBankwithoutRecncln.
-- 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: PCNHSBKWTHOUTREC
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW P_CN_HouseBankwithoutRecncln AS
SELECT
  T012K.bukrs AS CompanyCode,
  T012K.hbkid AS HouseBank,
  T012K.hktid AS HouseBankAccount,
  T012K.bankn AS BankAccount,
  T012K.refzl AS BankAccountReferenceText,
  T012K.waers AS HouseBankCurrency,
  T012K.hkont AS GLAccount,
  Ldgr.Ledger AS Ledger,
  Brs.AdjustedBkAcctBalanceAmt AS AdjustedBkAcctBalanceAmt,
  Brs.AdjustedGLAcctBalanceAmt AS AdjustedGLAcctBalanceAmt,
  Brs.UnmatchedIncgBkStmntPayt AS UnmatchedIncgBkStmntPayt,
  Brs.UnmatchedIncgJrnlEntrPayt AS UnmatchedIncgJrnlEntrPayt,
  Brs.UnmatchedOutgBkStmntPayt AS UnmatchedOutgBkStmntPayt,
  Brs.UnmatchedOutgJrnlEntrPayt AS UnmatchedOutgJrnlEntrPayt,
  Brs.CreationUserName AS CreationUserName,
  _HouseBank._Bank.BankName AS BankName
FROM P_HouseBankAccount AS T012K
LEFT OUTER JOIN I_CN_BankRecnclnStatement AS Brs ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CN_CompanyRecnclnLedger AS Ldgr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Housebank AS _HouseBank ON T012K.hbkid = _HouseBank.HouseBank AND T012K.bukrs = _HouseBank.CompanyCode  -- association [0..1]
;

Learn More