C_Proccatalogcalldetails

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_Proccatalogcalldetails.
-- 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: CPROCCATCALLDET

CREATE VIEW C_Proccatalogcalldetails AS
SELECT
  I_CatalogCallDetailsTP.OpnCtlgWebServiceID AS OpnCtlgWebServiceID,
  I_CatalogCallDetailsTP.OpnCtlgWebServiceIDForEdit AS OpnCtlgWebServiceIDForEdit,
  I_CatalogCallDetailsTP.OpnCtlgWebServiceName AS OpnCtlgWebServiceName,
  I_CatalogCallDetailsTP.IsDefaultCatalog AS IsDefaultCatalog,
  I_CatalogCallDetailsTP.OpnCtlgIsProdDspAllwd AS OpnCtlgIsProdDspAllwd,
  I_CatalogCallDetailsTP.OpnCtlgIsProdUpdtAllwd AS OpnCtlgIsProdUpdtAllwd,
  I_CatalogCallDetailsTP.OpnCtlgIsSrcgAllwd AS OpnCtlgIsSrcgAllwd,
  I_CatalogCallDetailsTP.OpnCtlgHasCrsCtlgSrch AS OpnCtlgHasCrsCtlgSrch,
  I_CatalogCallDetailsTP.OpnCtlgHasPartDets AS OpnCtlgHasPartDets,
  I_CatalogCallDetailsTP.OpnCtlgHasHttpGet AS OpnCtlgHasHttpGet,
  I_CatalogCallDetailsTP.OpnCtlgIconPath AS OpnCtlgIconPath,
  I_CatalogCallDetailsTP.OpnCtlgItmPriceCheckCat AS OpnCtlgItmPriceCheckCat,
  I_CatalogCallDetailsTP.IsOpnCtlgPunchoutDisabled AS IsOpnCtlgPunchoutDisabled,
  I_CatalogCallDetailsTP.IsOpnCtlgExtractionEnabled AS IsOpnCtlgExtractionEnabled,
  I_CatalogCallDetailsTP.IsSuccessMsgNotToBeLogged AS IsSuccessMsgNotToBeLogged,
  I_CatalogCallDetailsTP.IsErrorMsgNotToBeLogged AS IsErrorMsgNotToBeLogged,
  I_CatalogCallDetailsTP.IsWarningMsgNotToBeLogged AS IsWarningMsgNotToBeLogged
FROM I_CatalogCallDetailsTP
LEFT OUTER JOIN C_Proccatalogcallstruct AS _CatalogCallStructure ON _CatalogCallStructure.OpnCtlgWebServiceID = OpnCtlgWebServiceID  -- association [0..*]
LEFT OUTER JOIN I_OpnCtlgItmPriceCheckCat AS _OpnCtlgItmPriceCheckCat ON _OpnCtlgItmPriceCheckCat.OpnCtlgValType = OpnCtlgItmPriceCheckCat  -- association [0..1]
LEFT OUTER JOIN C_OpnCtlgWebSrvcIdentifierVH AS _OpnCtlgWebSrvcIdentifierVH ON _OpnCtlgWebSrvcIdentifierVH.OpnCtlgWebServiceID = OpnCtlgWebServiceID  -- association [0..1]
;