C_CndnContrSettlmtAmtQry

DDL: C_CNDNCONTRSETTLMTAMTQRY Type: view_entity CONSUMPTION Package: WCB_PC
40 Fields 1 Data Sources

CndnContr Amount Statement Query

C_CndnContrSettlmtAmtQry is a Consumption CDS View that provides data about "CndnContr Amount Statement Query" in SAP S/4HANA. It reads from 1 data source (R_CndnContrSettlmtAmtCube) and exposes 40 fields with key fields ConditionContract, SettlmtDate, SettlmtDateSequentialID, SettlmtDocCurrency, Supplier. Part of development package WCB_PC.

Data Sources (1)

SourceAliasJoin Type
R_CndnContrSettlmtAmtCube R_CndnContrSettlmtAmtCube from

Parameters (2)

NameTypeDefault
P_ExchangeRateType kurst
P_DisplayCurrency vdm_v_display_currency

Annotations (12)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
Analytics.query true view
Analytics.internalName #LOCAL view
Analytics.settings.maxProcessingEffort #MEDIUM view
Analytics.technicalName CCOCOAMTSMTQRY view
OData.publish true view
EndUserText.label CndnContr Amount Statement Query view
Metadata.allowExtensions true view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract Condition Contract
KEY SettlmtDate SettlmtDate Settlement Date
KEY SettlmtDateSequentialID SettlmtDateSequentialID Settlement Date ID
KEY SettlmtDocCurrency SettlmtDocCurrency Doc. Currency
KEY Supplier Supplier Supplier
KEY Customer Customer Sold-to Party
SettlmtDocType SettlmtDocType Settlement Document Type
SuplrSettlmtCompanyCode SuplrSettlmtCompanyCode Suppl. Company Code
CustSettlmtCompanyCode CustSettlmtCompanyCode Cust. Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
CndnContrType CndnContrType Contract Type
CndnContrPurgOrg
CndnContrPurgGroup
CndnContrSlsOrg
CndnContrDistrChnl
CndnContrDivn
CndnContrClassfctnType CndnContrClassfctnType Contract Category
DocumentReferenceID DocumentReferenceID Reference
NumberOfSettlementDocuments
CustomerFullName CustomerFullName Customer Name
SupplierFullName SupplierFullName
CndnContrSettlmtDteYrMnth CndnContrSettlmtDteYrMnth
CndnContrSettlmtDteYrQtr CndnContrSettlmtDteYrQtr
CndnContrSettlmtDteYrWk CndnContrSettlmtDteYrWk
CndnContrSettlmtDteYr CndnContrSettlmtDteYr
SettlmtDateCat SettlmtDateCat Settlement Date Type
SettlmtDateCatName SettlmtDateCatName
SettlmtItemNetAmount
SettlmtItemGrossAmount
SettlmtItmElgblAmtForCshDisc
SettlmtEffctvItemAmount
SettlmtItemTaxAmount
SettlmtBusVolAmt
SettlmtAccrRvslAmt
SettlmtPrtlSettlmtRvslAmt
DisplayCurrency

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 C_CndnContrSettlmtAmtQry.
-- 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.
-- Parameters: P_ExchangeRateType : kurst, P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW C_CndnContrSettlmtAmtQry AS
SELECT
  cast( ConditionContract as wcb_coco_num preserving type) AS ConditionContract,
  SettlmtDate,
  SettlmtDateSequentialID,
  SettlmtDocCurrency,
  Supplier,
  Customer,
  SettlmtDocType,
  SuplrSettlmtCompanyCode,
  CustSettlmtCompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  CndnContrType,
  cast(CndnContrPurgOrg as wlf_cndn_contr_purg_org preserving type ) AS CndnContrPurgOrg,
  cast(CndnContrPurgGroup as wlf_cndn_contr_purg_group preserving type ) AS CndnContrPurgGroup,
  cast(CndnContrSlsOrg as wlf_cndn_contr_sls_org preserving type ) AS CndnContrSlsOrg,
  cast(CndnContrDistrChnl as wlf_cndn_contr_distr_chnl preserving type ) AS CndnContrDistrChnl,
  cast(CndnContrDivn as wlf_cndn_contr_divn preserving type ) AS CndnContrDivn,
  CndnContrClassfctnType,
  DocumentReferenceID,
  cast(NumberOfSettlementDocuments as wb2_number_settl_docs preserving type ) AS NumberOfSettlementDocuments,
  CustomerFullName,
  SupplierFullName,
  CndnContrSettlmtDteYrMnth,
  CndnContrSettlmtDteYrQtr,
  CndnContrSettlmtDteYrWk,
  CndnContrSettlmtDteYr,
  SettlmtDateCat,
  SettlmtDateCatName,
  cast( SettlmtItemNetAmount as wb2_netwr_settl ) AS SettlmtItemNetAmount,
  cast(SettlmtItemGrossAmount as wb2_brtwr_settl ) AS SettlmtItemGrossAmount,
  cast(SettlmtItmElgblAmtForCshDisc as wb2_skfbp_settl ) AS SettlmtItmElgblAmtForCshDisc,
  cast(SettlmtEffctvItemAmount as wb2_effwr_settl ) AS SettlmtEffctvItemAmount,
  cast(SettlmtItemTaxAmount as wb2_mwsbp_settl ) AS SettlmtItemTaxAmount,
  cast(SettlmtBusVolAmt as wb2_business_volume_settl ) AS SettlmtBusVolAmt,
  cast(SettlmtAccrRvslAmt as wb2_accruals_reversal_settl ) AS SettlmtAccrRvslAmt,
  cast(SettlmtPrtlSettlmtRvslAmt as wb2_part_settlement_rev_settl) AS SettlmtPrtlSettlmtRvslAmt,
  cast($parameters.P_DisplayCurrency as vdm_v_display_currency preserving type ) AS DisplayCurrency
FROM R_CndnContrSettlmtAmtCube
;

Learn More