VFCLM_BAM_DDL_AMD_SIG

DDL: FCLM_BAM_AMDSIG SQL: VFCLM_BAM_AMDSIG Type: view

VFCLM_BAM_DDL_AMD_SIG is a CDS View in SAP S/4HANA. It reads from 1 data source (VFCLM_BAM_DDL_SIG_DB) and exposes 8 fields with key fields AccountID, Signatory, ValidTo.

Data Sources (1)

SourceAliasJoin Type
VFCLM_BAM_DDL_SIG_DB sigheader from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName VFCLM_BAM_AMDSIG view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY AccountID VFCLM_BAM_DDL_SIG_DB acc_id Technical ID
KEY Signatory VFCLM_BAM_DDL_SIG_DB bname User name
KEY ValidTo VFCLM_BAM_DDL_SIG_DB valid_to Validity End Time
Currency VFCLM_BAM_DDL_SIG_DB waers Transaction Currency
ValidFrom VFCLM_BAM_DDL_SIG_DB valid_from Validity Start Time
SignatoryGroup VFCLM_BAM_DDL_SIG_DB sign_group Approver Group
PaymentAmount VFCLM_BAM_DDL_SIG_DB pay_amount Max. Paymt Amt
BatchPaymentAmount VFCLM_BAM_DDL_SIG_DB batch_amount Max. Batch Amt

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 VFCLM_BAM_DDL_AMD_SIG.
-- 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: VFCLM_BAM_AMDSIG

CREATE VIEW VFCLM_BAM_DDL_AMD_SIG AS
SELECT
  sigheader.acc_id AS AccountID,
  sigheader.bname AS Signatory,
  sigheader.valid_to AS ValidTo,
  sigheader.waers AS Currency,
  sigheader.valid_from AS ValidFrom,
  sigheader.sign_group AS SignatoryGroup,
  sigheader.pay_amount AS PaymentAmount,
  sigheader.batch_amount AS BatchPaymentAmount
FROM VFCLM_BAM_DDL_SIG_DB AS sigheader
;