C_CABillgDocHeader

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_CABillgDocHeader.
-- 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 C_CABillgDocHeader AS
SELECT
  _CABillgDocHeader.CABillgDocument AS CABillgDocument,
  CAInvoicingDocument,
  virtual CAInvcgDocExternal : ext_invdocno_kk AS virtualCAInvcgDocExternalext_invdocno_kk,
  virtual CAInvcgDocExternalIsHidden : boolean AS virtualCAInvcgDocExternalIsHiddenboolean,
  virtual UICT_CABillgDocument : abap.char(50) AS char50,
  _CAInvcgBPAddress.BusinessPartnerFullName AS BusinessPartnerFullName,
  _CAInvcgBPAddress.StreetName AS StreetName,
  _CAInvcgBPAddress.AddressCityName AS AddressCityName,
  _CAInvcgBPAddress.CountryName AS CountryName,
  _CABillgDocHeader.BusinessPartner AS BusinessPartner,
  _CABillgDocHeader.ContractAccount AS ContractAccount,
  _ContractAccountHeader.ContractAccountName AS ContractAccountName,
  virtual CAContract : vtref_kk AS virtualCAContractvtref_kk,
  _CABillgDocHeader.CABillgType AS CABillgType,
  _CABillgType._CABillgTypeText.CABillgTypeText : localized AS CABillgTypeTextlocalized,
  _CABillgDocHeader.CABillgDocPeriodStartDate AS CABillgDocPeriodStartDate,
  _CABillgDocHeader.CABillgDocPeriodEndDate AS CABillgDocPeriodEndDate,
  _CABillgDocHeader.CABillgDocCreationDate AS CABillgDocCreationDate,
  _CABillgDocHeader.CABillgDocCreationTime AS CABillgDocCreationTime,
  _CABillgDocHeader.CABillgDocumentReversalReason AS CABillgDocumentReversalReason,
  _CABillgDocReversalReason._CABillgDocReversalReasonText.CABillgDocReversalReasonText : localized AS CABillgDocReversalReasonTextlocalized,
  _CABillgDocHeader.CABillgIsDocumentSimulated AS CABillgIsDocumentSimulated,
  _CABillgDocHeader.CABillgDocumentExternal AS CABillgDocumentExternal,
  _CABillgDocHeader.LogicalSystem AS LogicalSystem,
  _CABillgDocHeader.CAApplicationArea AS CAApplicationArea,
  _CABillgDocHeader.CABillgDocOriginProcess AS CABillgDocOriginProcess,
  _CABillgDocOriginProcess._CABillgDocOriginProcessText.CABillgDocOriginProcessText : localized AS CABillgDocOriginProcessTextlocalized,
  _CABillgDocHeader.CAInvcgSourceDocumentType AS CAInvcgSourceDocumentType,
  _CAInvcgSourceDocType._CAInvcgSourceDocTypeText.CAInvcgSourceDocTypeText : localized AS CAInvcgSourceDocTypeTextlocalized,
  _CABillgDocHeader.CAInvcgTechnicalDocumentType AS CAInvcgTechnicalDocumentType,
  _CAInvcgDocTechDocType._CAInvcgDocTechDocTypeText.CAInvcgDocTechDocTypeText : localized AS CAInvcgDocTechDocTypeTextlocalized,
  _CABillgDocHeader.CAInvcgDocumentType AS CAInvcgDocumentType,
  _CAInvcgDocumentType._CAInvcgDocumentTypeText.CAInvcgDocumentTypeText : localized AS CAInvcgDocumentTypeTextlocalized,
  _CABillgDocHeader.CAInvcgTargetProcess AS CAInvcgTargetProcess,
  _CAInvcgTargetProc._CAInvcgTargetProcText.CAInvcgTargetProcText : localized AS CAInvcgTargetProcTextlocalized,
  _CABillgDocHeader.CAInvcgMasterDataType AS CAInvcgMasterDataType,
  _CAInvcgMasterDataType._CAInvcgMasterDataTypeText.CAInvcgMasterDataTypeText : localized AS CAInvcgMasterDataTypeTextlocalized,
  _CABillgDocHeader.CAInvcgAltvBusinessPartner AS CAInvcgAltvBusinessPartner,
  _CABillgDocHeader.CAInvcgAltvContractAccount AS CAInvcgAltvContractAccount,
  _CABillgDocHeader.CABillgBaseDate AS CABillgBaseDate,
  _CABillgDocHeader.CABillgCurrency AS CABillgCurrency,
  _CABillgDocHeader.CAInvcgCurrency AS CAInvcgCurrency,
  _CABillgDocHeader.CATaxDetnType AS CATaxDetnType,
  _CATaxDetnType._CATaxDetnTypeText.CATaxDetnTypeText : localized AS CATaxDetnTypeTextlocalized,
  _CABillgDocHeader.CATaxDateType AS CATaxDateType,
  _CATaxDateType._CATaxDateTypeText.CATaxDateTypeText : localized AS CATaxDateTypeTextlocalized,
  _CABillgDocHeader.CAInvcgCategory AS CAInvcgCategory,
  _CAInvcgCategory._CAInvcgCategoryText.CAInvcgCategoryText : localized AS CAInvcgCategoryTextlocalized,
  _CABillgDocHeader.CAInvcgControlOfInvoicingUnit AS CAInvcgControlOfInvoicingUnit,
  _CAInvcgControlOfInvcgUnit._CAInvcgControlOfInvcgUnitTxt.CAInvcgControlOfInvcgUnitTxt : localized AS CAInvcgControlOfInvcgUnitTxtlocalized,
  _CABillgDocHeader.CAInvcgFirstDate AS CAInvcgFirstDate,
  _CABillgDocHeader.CABillgReversalDocument AS CABillgReversalDocument,
  _CABillgDocHeader.CABillgReversedDocument AS CABillgReversedDocument,
  _CABillgDocHeader.CABillgAdjustmentDocument AS CABillgAdjustmentDocument,
  _CABillgDocHeader.CABillgAdjustedDocument AS CABillgAdjustedDocument,
  _CABillgDocHeader.CAInvcgCorrectionCategory AS CAInvcgCorrectionCategory,
  _CAInvcgCorrectionCat._CAInvcgCorrectionCatText.CAInvcgCorrectionCatText : localized AS CAInvcgCorrectionCatTextlocalized,
  _CABillgDocHeader.CaInvcgIsOrderDeleted AS CaInvcgIsOrderDeleted,
  _CABillgDocHeader.CABillgHasAdditionalInvoice AS CABillgHasAdditionalInvoice,
  _CABillgExistsAddInvcg._CABillgExistsAddInvcgText.CABillgAdditionalInvoiceText : localized AS CABillgAdditionalInvoiceTextlocalized,
  _CABillgDocHeader.CAInvcgIsAccrualPostingRlvt AS CAInvcgIsAccrualPostingRlvt,
  _CABillgDocHeader.CABillgLockedForInvoicing AS CABillgLockedForInvoicing,
  _CABillgLockedForInvcg._CABillgLockedForInvcgText.CABillgLockedForInvcgText : localized AS CABillgLockedForInvcgTextlocalized,
  _CABillgDocHeader.CABillgGrpgOfAdditionalItems AS CABillgGrpgOfAdditionalItems,
  _CABillgDocHeader.CABillgDocHasRefObjects AS CABillgDocHasRefObjects,
  _CABillgDocHeader.CABillgDocumentNumberOfItems AS CABillgDocumentNumberOfItems,
  _CABillgDocHeader.CABllbleItmNumber AS CABllbleItmNumber,
  _CABillgDocHeader.CreatedByUser AS CreatedByUser,
  _CABillgDocHeader.CABillgDocInternalNumber AS CABillgDocInternalNumber,
  _CABillgDocHeader.CABillgProcess AS CABillgProcess,
  _CABillgProcess._CABillgProcessText.CABillgProcessText : localized AS CABillgProcessTextlocalized,
  _CABillgDocHeader.CABillgDocHasPrepaidItems AS CABillgDocHasPrepaidItems,
  _CABillgDocHeader.CABillgDocHasRefillItems AS CABillgDocHasRefillItems,
  _CABillgDocHeader.CABillgDocHasRevnRecgnItems AS CABillgDocHasRevnRecgnItems,
  _CABillgDocHeader.CAPartnerSettlementRule AS CAPartnerSettlementRule,
  _CABillgDocHeader.CABillgDocumentInvcgStatus AS CABillgDocumentInvcgStatus,
  _CABillgDocInvcgStatus._CABillgDocInvcgStatusText.CABillgDocumentInvcgStatusText : localized AS CABillgDocumentInvcgStatusTextlocalized,
  _CABillgDocHeader.CAInvcgCreationDate AS CAInvcgCreationDate,
  _CABillgDocHeader.CASubAreaForParallelization AS CASubAreaForParallelization,
  _CABillgDocHeader.CAAltvMDOriginalIsIncluded AS CAAltvMDOriginalIsIncluded,
  virtual CABillgDocReversalIsEnabled : xfeld AS virtualCABillgDocReversalIsEnabledxfeld
FROM R_CABillgDocumentTP
LEFT OUTER JOIN C_CABillgDocItem AS _CABillgDocItem ON CABillgDocument = _CABillgDocItem.CABillgDocument  -- association [1..*]
LEFT OUTER JOIN C_CABillgDocSource AS _CABillgDocSource ON CABillgDocument = _CABillgDocSource.CABillgDocument  -- association [1..*]
LEFT OUTER JOIN C_CABillgDocTax AS _CABillgDocTax ON CABillgDocument = _CABillgDocTax.CABillgDocument  -- association [1..*]
LEFT OUTER JOIN C_CABillgDocPayment AS _CABillgDocPayment ON CABillgDocument = _CABillgDocPayment.CABillgDocument  -- association [1..*]
LEFT OUTER JOIN C_CABillgDocAdditional AS _CABillgDocAdditional ON CABillgDocument = _CABillgDocAdditional.CABillgDocument  -- association [1..*]
LEFT OUTER JOIN C_CABillgDocReference AS _CABillgDocReference ON CABillgDocument = _CABillgDocReference.CABillgDocument  -- association [1..*]
LEFT OUTER JOIN C_CABillgDocInvcgDocSource AS _CABillgDocInvcgDocSource ON CABillgDocument = _CABillgDocInvcgDocSource.CABillgDocument  -- association [1..*]
LEFT OUTER JOIN C_CABillgDocHeader AS _CABillgReversedDocument ON CABillgReversedDocument = _CABillgReversedDocument.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN C_CABillgDocHeader AS _CABillgReversalDocument ON CABillgReversalDocument = _CABillgReversalDocument.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN C_CABillgDocHeader AS _CABillgAdjustedDocument ON CABillgAdjustedDocument = _CABillgAdjustedDocument.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN C_CABillgDocHeader AS _CABillgAdjustmentDocument ON CABillgAdjustmentDocument = _CABillgAdjustmentDocument.CABillgDocument  -- association [0..1]
;