P_CndnContrConditionUsage

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_CndnContrConditionUsage.
-- 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.

CREATE VIEW P_CndnContrConditionUsage AS
SELECT
  ruuid AS DocRelationshipUUID,
  knumv AS PricingDocument,
  stunr AS PricingProcedureStep,
  zaehk AS PricingProcedureCounter,
  num AS ConditionContract,
  guid AS CndnContrUUID,
  knumh AS ConditionRecord,
  kopos AS ConditionSequentialNumberShort,
  accr_rev_status AS CndnContrAccrRvslSts,
  cast( doc_type_to as wcb_accdoc_category preserving type ) AS AccrSrceDocCategory,
  cast( docnr_to as wcb_accdoc_number preserving type ) AS AccrSrceDocument,
  cast( doc_year_to as wcb_accdoc_year preserving type ) AS AccrSrceDocumentYear,
  cast( kposn as wcb_accdoc_item preserving type ) AS AccrSrceDocumentItem,
  kappl AS ConditionApplication,
  kschl AS ConditionType,
  kwert AS ConditionAmount,
  cast( waers as wcb_accdoc_currency preserving type ) AS AccrSrceDocCurrency,
  cast( budat as wcb_accdoc_posting_date preserving type ) AS AccrSrceDocPostingDate,
  settl_date AS SettlmtDate,
  settl_date_seq_id AS SettlmtDateSequentialID,
  ref_settl_date AS RefSettlmtDate,
  ref_settl_date_seq_id AS RefSettlmtDateSequentialID,
  cast( gjahr as wcb_accdoc_fiscal_year preserving type ) AS AccrSrceDocFiscalYear,
  cast( werks as wcb_accdoc_item_plant preserving type ) AS AccrSrceDocItemPlant,
  cast( bukrs as wcb_accdoc_company_code preserving type ) AS AccrSrceDocCompanyCode
FROM wcocof
LEFT OUTER JOIN I_ConditionApplication AS _ConditionApplication ON ConditionApplication = _ConditionApplication.ConditionApplication  -- association [0..1]
LEFT OUTER JOIN I_PricingConditionType AS _ConditionType ON ConditionApplication = _ConditionType.ConditionApplication AND ConditionType = _ConditionType.ConditionType  -- association [0..1]
LEFT OUTER JOIN I_ConditionContract AS _ConditionContract ON ConditionContract = _ConditionContract.ConditionContract  -- association [1..1]
LEFT OUTER JOIN I_CndnContrAccrRvslSts AS _CndnContrAccrRvslSts ON CndnContrAccrRvslSts = _CndnContrAccrRvslSts.CndnContrAccrRvslSts  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AccrSrceDocCurrency ON AccrSrceDocCurrency = _AccrSrceDocCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _AccrSrceDocItemPlant ON AccrSrceDocItemPlant = _AccrSrceDocItemPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _AccrSrceDocCompanyCode ON AccrSrceDocCompanyCode = _AccrSrceDocCompanyCode.CompanyCode  -- association [0..1]
;