I_PRAChkInptCDEXDetail

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 I_PRAChkInptCDEXDetail.
-- 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 I_PRAChkInptCDEXDetail AS
SELECT
  co_no AS PRACheckInputCDEXCompany,
  own_no AS PRACheckInputOwnerNumber,
  ck_no AS PRACheckInputCDEXCheckNumber,
  line_no AS PRAChkInptLineNumber,
  lease_code AS PRACheckInputPropertyLeaseCode,
  prod_from_dt AS PRAChkInptProdnFrmDteVal,
  prod_to_dt AS PRAChkInptProdnToDteVal,
  pd_cd AS CDEXProductCode,
  tran_code_1 AS PRAChkInputTransactionCodeOne,
  tran_code_2 AS PRAChkInputTransactionCodeTwo,
  lse_gr_vol AS PRAChkInptLeaseGrossVolVal,
  lse_gr_sev AS PRALeaseGrssSvrncTaxAmount,
  lse_net_val AS PRALeaseNetValueAmount,
  lse_gr_crwpt AS PRAChrgReimbmtTaxLeaseGrossAmt,
  own_net_val AS PRAOwnerNetValueAmount,
  own_crwpt AS PRAChrgReimbmtTaxOwnerAmount,
  trans_date AS PRAChkInptTransDateValue,
  type_interest AS PRACheckInputInterestType,
  dec_int_fl AS PRAIsCheckInputDecimalFlag,
  dec_int AS PRAChkInptIntrstDecimalRate,
  btu_fact AS PRACheckInputFactor,
  status AS PRAChkInptCheckPostingStatus,
  rej_rsn_cd AS PRACheckInputRejectionReason,
  _Reference.Remitter AS Remitter,
  _Reference._CompanyCode.Currency AS CompanyCodeCurrency,
  _ProductReference.PRAProduct AS PRAProduct
FROM oiuci_cdexd
LEFT OUTER JOIN I_PRARemitterCDEXReference AS _Reference ON PRACheckInputCDEXCompany = _Reference.PRACheckInputCDEXCompany AND PRACheckInputOwnerNumber = _Reference.PRACheckInputOwnerNumber  -- association [0..1]
LEFT OUTER JOIN I_PRAProductCDEXReference AS _ProductReference ON PRACheckInputCDEXCompany = _ProductReference.PRACheckInputCDEXCompany AND CDEXProductCode = _ProductReference.CDEXProductCode  -- association [0..1]
;