I_CABllbleItmError

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_CABllbleItmError.
-- 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_CABllbleItmError AS
SELECT
  bitcat AS CABllbleItmClass,
  cast(srctatype as srctatype_gfn_kk preserving type ) AS CABllbleItmSourceTransType,
  cast(srctaid as srctaid_gfn_kk preserving type ) AS CABllbleItmSourceTransId,
  erruuid AS CAErrorUUID,
  bitstatus AS CABllbleItmStatus,
  gpart AS BusinessPartner,
  bitcrdate AS CABllbleItmCreationDate,
  bitdatapackid AS CABllbleItmDataPackageID,
  cast(bitpackuuid as bitpackuuid_gfn_kk preserving type ) AS CABllbleItmPackageUUID,
  processid AS CABllbleItmProcess,
  billdate AS CABillgDate,
  cast (billrunno as billrunno_gfn_kk preserving type ) AS CABillgDocInternalNumber,
  billprocess AS CABillgProcess,
  billtype AS CABillgType,
  subprocess AS CABillgSubprocess,
  vtref AS CAContract,
  targprocess AS CAInvcgTargetProcess,
  subap AS CASubApplication,
  vkont AS ContractAccount,
  cruser AS CreatedByUser,
  crdate AS CreationDate,
  crtime AS CreationTime,
  runkey AS CAMassRunInternalID,
  LogHandle,
  msgty AS SystemMessageType,
  msgid AS SystemMessageIdentification,
  msgno AS SystemMessageNumber,
  msgv1 AS SystemMessageVariable1,
  msgv2 AS SystemMessageVariable2,
  msgv3 AS SystemMessageVariable3,
  msgv4 AS SystemMessageVariable4
FROM dfkkbixbit_err
LEFT OUTER JOIN I_CABllbleItmStatus AS _CABllbleItmStatus ON CABllbleItmStatus = _CABllbleItmStatus.CABllbleItmStatus  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CABillgProcess AS _CABillgProcess ON CABillgProcess = _CABillgProcess.CABillgProcess  -- association [0..1]
LEFT OUTER JOIN I_CABillgSubProcess AS _CABillgSubprocess ON CABillgSubprocess = _CABillgSubprocess.CABillgSubprocess  -- association [0..1]
LEFT OUTER JOIN I_CABillgType AS _CABillgType ON CABillgType = _CABillgType.CABillgType  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmClass AS _CABllbleItmClass ON CABllbleItmClass = _CABllbleItmClass.CABllbleItmClass  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgTargetProc AS _CAInvcgTargetProcess ON CAInvcgTargetProcess = _CAInvcgTargetProcess.CAInvcgTargetProcess  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmSrceTransType AS _CABllbleItmSourceTransType ON CABllbleItmSourceTransType = _CABllbleItmSourceTransType.CABllbleItmSourceTransType  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmProcess AS _CABllbleItmProcess ON CABllbleItmProcess = _CABllbleItmProcess.CABllbleItmProcess  -- association [0..1]
;