/PF1/P_FCLM_BAM_AMD

DDL: /PF1/P_FCLM_BAM_AMD SQL: /PF1/P_BAMAMD Type: view
46 Fields

P View for FCLM_BAM_AMD

/PF1/P_FCLM_BAM_AMD is a CDS View that provides data about "P View for FCLM_BAM_AMD" in SAP S/4HANA.

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName /PF1/P_BAMAMD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label P View for FCLM_BAM_AMD view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY acc_id acc_id Technical ID
revision revision Revision Number
banks banks Bank Ctry/Rgn. Key
bankl bankl House Bank
acc_num acc_num Account Number
acc_type_id acc_type_id Account Type
valid_from valid_from Validity Start Time
valid_to valid_to Validity End Time
iban iban IBAN House Bank
status status Workflow Status
cash_pool cash_pool Cash Pool
cash_pool_id cash_pool_id Cash Pool Name
bukrs bukrs Value
prctr prctr Profit Centers
gsber gsber Business Area
segment segment Segment number
beneficial beneficial Account Holder
bank_contact bank_contact General Contact
rel_manager rel_manager Relationship Manager
edbsum edbsum EoD
idbsum idbsum Intraday
created_at created_at Uploaded On
created_by created_by Version Created By
opened_at opened_at Timestamp
opened_by opened_by Opened By
changed_at changed_at Timestamp
changed_by changed_by User Name
reviewed_at reviewed_at Timestamp
reviewed_by reviewed_by Reviewed By
closed_at closed_at Timestamp
closed_by closed_by Closed By
deleted_flag deleted_flag TRUE
control_key control_key Control Key
objnr objnr Val. Obj. No.
vgtyp vgtyp Trans. Type
procstat_act procstat_act Process Status
balstat_act balstat_act Difference Sts
serstat_act serstat_act Serial No. Sts
exp_number exp_number Interval
exp_rhyth exp_rhyth Interval Unit
calendar calendar Workdays only
sort_idx sort_idx
amt_diff amt_diff Difference Amt
waers waers Transaction Currency
ext_rule_id ext_rule_id Intraday Stmts Rule
description _text description Well Code Des.

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 /PF1/P_FCLM_BAM_AMD.
-- 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: /PF1/P_BAMAMD

CREATE VIEW /PF1/P_FCLM_BAM_AMD AS
SELECT
  acc_id,
  revision,
  banks,
  bankl,
  acc_num,
  acc_type_id,
  valid_from,
  valid_to,
  iban,
  status,
  cash_pool,
  cash_pool_id,
  bukrs,
  prctr,
  gsber,
  segment,
  beneficial,
  bank_contact,
  rel_manager,
  edbsum,
  idbsum,
  created_at,
  created_by,
  opened_at,
  opened_by,
  changed_at,
  changed_by,
  reviewed_at,
  reviewed_by,
  closed_at,
  closed_by,
  deleted_flag,
  control_key,
  objnr,
  vgtyp,
  procstat_act,
  balstat_act,
  serstat_act,
  exp_number,
  exp_rhyth,
  calendar,
  sort_idx,
  amt_diff,
  waers,
  ext_rule_id,
  _text.description AS description
;

Learn More