C_CAInvcgDocHeader

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_CAInvcgDocHeader.
-- 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_CAInvcgDocHeader AS
SELECT
  _CAInvcgDocHeader.CAInvoicingDocument AS CAInvoicingDocument,
  virtual UICT_CAInvoicingDocument : abap.char(50) AS char50,
  _CAInvcgDocHeader.CAOfficialDocumentNumber AS CAOfficialDocumentNumber,
  _CAInvcgBPAddress.BusinessPartnerFullName AS BusinessPartnerFullName,
  _CAInvcgBPAddress.StreetName AS StreetName,
  _CAInvcgBPAddress.AddressCityName AS AddressCityName,
  _CAInvcgBPAddress.CountryName AS CountryName,
  _CAInvcgDocHeader.BusinessPartner AS BusinessPartner,
  _CAInvcgDocHeader.ContractAccount AS ContractAccount,
  _CAInvcgDocHeader._ContractAccountHeader.ContractAccountName AS ContractAccountName,
  _CAInvcgDocHeader.CAInvcgType AS CAInvcgType,
  _CAInvcgType._CAInvcgTypeText.CAInvcgTypeText : localized AS CAInvcgTypeTextlocalized,
  _CAInvcgDocHeader.CAInvcgDocPeriodDate AS CAInvcgDocPeriodDate,
  _CAInvcgDocHeader.DocumentDate AS DocumentDate,
  _CAInvcgDocHeader.TransactionCurrency AS TransactionCurrency,
  _CAInvcgDocHeader.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _CAInvcgDocHeader.CAInvcgProcess AS CAInvcgProcess,
  _CAInvcgProcess._CAInvcgProcessText.CAInvcgProcessText : localized AS CAInvcgProcessTextlocalized,
  _CAInvcgDocHeader.CAInvcgDocumentType AS CAInvcgDocumentType,
  _CAInvcgDocumentType._CAInvcgDocumentTypeText.CAInvcgDocumentTypeText : localized AS CAInvcgDocumentTypeTextlocalized,
  _CAInvcgDocHeader.CADunningCounter AS CADunningCounter,
  _CAInvcgDocHeader.CAInvcgDocHasControlDoc AS CAInvcgDocHasControlDoc,
  _CAInvcgDocHeader.CAInvcgDocFormID AS CAInvcgDocFormID,
  _CAInvcgDocHeader.ApplicationForm AS ApplicationForm,
  _CAInvcgDocHeader.CAInvcgDocumentPrintDate AS CAInvcgDocumentPrintDate,
  _CAInvcgDocHeader.CAInvcgDocIsLockedForPrinting AS CAInvcgDocIsLockedForPrinting,
  _CAInvcgDocLockedforPrint._CAInvcgDocLockedForPrintText.CAInvcgDocLockedForPrintText : localized AS CAInvcgDocLockedForPrintTextlocalized,
  _CAInvcgDocHeader.CANetDueDate AS CANetDueDate,
  _CAInvcgDocHeader.CAInvcgDocumentReversalReason AS CAInvcgDocumentReversalReason,
  _CAInvcgDocReversalReason._CAInvcgDocReversalReasonText.CAInvcgDocReversalReasonText : localized AS CAInvcgDocReversalReasonTextlocalized,
  _CAInvcgDocHeader.CAInvcgIsDocumentPosted AS CAInvcgIsDocumentPosted,
  _CAInvcgDocHeader.CAInvcgIsDocumentPreliminary AS CAInvcgIsDocumentPreliminary,
  _CAInvcgDocHeader.CAInvcgIsDocumentSimulated AS CAInvcgIsDocumentSimulated,
  _CAInvcgDocHeader.CAPostingDate AS CAPostingDate,
  _CAInvcgDocHeader.CAApplicationArea AS CAApplicationArea,
  _CAInvcgDocHeader.CAInvcgTechnicalDocumentType AS CAInvcgTechnicalDocumentType,
  _CAInvcgDocTechDocType._CAInvcgDocTechDocTypeText.CAInvcgDocTechDocTypeText : localized AS CAInvcgDocTechDocTypeTextlocalized,
  _CAInvcgDocHeader.CAInvcgTargetProcess AS CAInvcgTargetProcess,
  _CAInvcgTargetProc._CAInvcgTargetProcText.CAInvcgTargetProcText : localized AS CAInvcgTargetProcTextlocalized,
  _CAInvcgDocHeader.CAInvcgMasterDataType AS CAInvcgMasterDataType,
  _CAInvcgMasterDataType._CAInvcgMasterDataTypeText.CAInvcgMasterDataTypeText : localized AS CAInvcgMasterDataTypeTextlocalized,
  _CAInvcgDocHeader.AltvContractAcctForCollvBills AS AltvContractAcctForCollvBills,
  _CAInvcgDocHeader.CASubstituteDocumentNumber AS CASubstituteDocumentNumber,
  _CAInvcgDocHeader.CreatedByUser AS CreatedByUser,
  _CAInvcgDocHeader.CAInvcgCreationDate AS CAInvcgCreationDate,
  _CAInvcgDocHeader.CAInvcgCreationTime AS CAInvcgCreationTime,
  _CAInvcgDocHeader.CAInvcgDocCreationMode AS CAInvcgDocCreationMode,
  _CAInvcgDocCreationMode._CAInvcgDocCreationModeText.CAInvcgDocCreationModeText : localized AS CAInvcgDocCreationModeTextlocalized,
  _CAInvcgDocHeader.CAInvcgNmbrOfInvoicingDocItems AS CAInvcgNmbrOfInvoicingDocItems,
  _CAInvcgDocHeader.CABllbleItmNumber AS CABllbleItmNumber,
  _CAInvcgDocHeader.CAInvcgDocInternalNumber AS CAInvcgDocInternalNumber,
  _CAInvcgDocHeader.CAReconciliationKey AS CAReconciliationKey,
  _CAInvcgDocHeader.CACashDiscountDueDate AS CACashDiscountDueDate,
  _CAInvcgDocHeader.CACashDiscountRate AS CACashDiscountRate,
  _CAInvcgDocHeader.CAInvcgPreliminaryCategory AS CAInvcgPreliminaryCategory,
  _CAInvcgPreliminaryCategory._Text.CAInvcgPreliminaryCategoryTxt : localized AS CAInvcgPreliminaryCategoryTxtlocalized,
  _CAInvcgDocHeader.CAPrelimInvcgDocValue AS CAPrelimInvcgDocValue,
  _CAInvcgDocHeader.CAPreliminaryInvcgDocStatus AS CAPreliminaryInvcgDocStatus,
  _CAPreliminaryInvcgDocStatus._Text.CAPreliminaryInvcgDocStatusTxt : localized AS CAPreliminaryInvcgDocStatusTxtlocalized,
  _CAInvcgDocHeader.CAInvcgCategory AS CAInvcgCategory,
  _CAInvcgCategory._CAInvcgCategoryText.CAInvcgCategoryText : localized AS CAInvcgCategoryTextlocalized,
  _CAInvcgDocHeader.CAInvcgReversalDocument AS CAInvcgReversalDocument,
  _CAInvcgDocHeader.CAInvcgReversedDocument AS CAInvcgReversedDocument,
  _CAInvcgDocHeader.CAInvcgCorrectionCategory AS CAInvcgCorrectionCategory,
  _CAInvcgCorrectionCat._CAInvcgCorrectionCatText.CAInvcgCorrectionCatText : localized AS CAInvcgCorrectionCatTextlocalized,
  _CAInvcgDocHeader.CAPaymentMethod AS CAPaymentMethod,
  _CAPaymentMethod._Text.CAPaymentMethodName : localized AS CAPaymentMethodNamelocalized,
  _CAInvcgDocHeader.CAPaymentCompanyCodeCountry AS CAPaymentCompanyCodeCountry,
  _CAInvcgDocHeader.CAPaymentFormNumber AS CAPaymentFormNumber,
  _CAInvcgDocHeader.FormIDForAttachedPaymentMedium AS FormIDForAttachedPaymentMedium,
  _CAInvcgDocHeader.CAKeyIdentification AS CAKeyIdentification,
  _CAInvcgDocHeader.CAPartnerSettlementRule AS CAPartnerSettlementRule,
  _CAInvcgDocHeader.CompanyCode AS CompanyCode,
  _CAInvcgDocHeader._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CAInvcgDocHeader.BusinessPlace AS BusinessPlace,
  _CAInvcgDocHeader.CAContract AS CAContract,
  _CAInvcgDocHeader.CASubApplication AS CASubApplication,
  _CASubApplication._CASubApplicationText.CASubApplicationText : localized AS CASubApplicationTextlocalized,
  _CAInvcgDocHeader.CAInvcgBaseDate AS CAInvcgBaseDate,
  _CAInvcgDocHeader.CAInvcgDocPeriodCategory AS CAInvcgDocPeriodCategory,
  _CAInvcgPeriodCat._CAInvcgPeriodCatText.CAInvcgPeriodCatText : localized AS CAInvcgPeriodCatTextlocalized,
  _CAInvcgDocHeader.CAInvcgDocPeriodStartDate AS CAInvcgDocPeriodStartDate,
  _CAInvcgDocHeader.CAInvcgDocHasChargeOrDiscItems AS CAInvcgDocHasChargeOrDiscItems,
  _CAInvcgDocChrgDiscItems._CAInvcgDocChrgDiscItemsText.CAInvcgDocChrgDiscItemsText : localized AS CAInvcgDocChrgDiscItemsTextlocalized,
  _CAInvcgDocHeader.CAInvcgBolloTaxPostStatus AS CAInvcgBolloTaxPostStatus,
  _CAInvcgBolloTaxPostStatus._CAInvcgBolloTaxPostStatText.CAInvcgBolloTaxPostStatText : localized AS CAInvcgBolloTaxPostStatTextlocalized,
  _CAInvcgDocHeader.CAInvcgDocIsPartOfList AS CAInvcgDocIsPartOfList,
  _CAInvcgDocPartOfList._CAInvcgDocPartOfListText.CAInvcgDocPartOfListText : localized AS CAInvcgDocPartOfListTextlocalized,
  _CAInvcgDocHeader.CAInvcgDocHasObjectRelation AS CAInvcgDocHasObjectRelation,
  _CAInvcgDocHeader.CAInvcgDocHasSEPAPreNotif AS CAInvcgDocHasSEPAPreNotif,
  _CAInvcgDocHeader.CAInvcgDocExternal AS CAInvcgDocExternal,
  _CAInvcgDocHeader.CAInvcgAdjustmentDocument AS CAInvcgAdjustmentDocument,
  _CAInvcgDocHeader.CAInvcgAdjustedDocument AS CAInvcgAdjustedDocument,
  virtual CAInvcgDocReversalIsEnabled : xfeld AS virtualCAInvcgDocReversalIsEnabledxfeld,
  virtual CAInvcgDocBillgReqIsEnabled : xfeld AS virtualCAInvcgDocBillgReqIsEnabledxfeld,
  virtual CAInvcgDocReleaseIsEnabled : xfeld AS virtualCAInvcgDocReleaseIsEnabledxfeld,
  virtual CADisputeCaseIsExisting : xfeld AS virtualCADisputeCaseIsExistingxfeld
FROM R_CAInvcgDocumentTP
LEFT OUTER JOIN C_CAInvcgDocItem AS _CAInvcgDocItem ON CAInvoicingDocument = _CAInvcgDocItem.CAInvoicingDocument  -- association [1..*]
LEFT OUTER JOIN C_CAInvcgDocSource AS _CAInvcgDocSource ON CAInvoicingDocument = _CAInvcgDocSource.CAInvoicingDocument  -- association [1..*]
LEFT OUTER JOIN C_CAInvcgDocPosting AS _CAInvcgDocPosting ON CAInvoicingDocument = _CAInvcgDocPosting.CAInvoicingDocument  -- association [1..*]
LEFT OUTER JOIN C_CAInvcgDocRelation AS _CAInvcgDocRelation ON CAInvoicingDocument = _CAInvcgDocRelation.CAInvoicingDocument  -- association [1..*]
LEFT OUTER JOIN C_CAInvcgDocContractAccount AS _CAInvcgDocContractAccount ON ContractAccount = _CAInvcgDocContractAccount.ContractAccount  -- association [1..*]
LEFT OUTER JOIN C_CAInvcgDocPrintReceiver AS _CAInvcgDocPrintReceiver ON CAInvoicingDocument = _CAInvcgDocPrintReceiver.CAInvoicingDocument AND CAInvcgProcess = _CAInvcgDocPrintReceiver.CAInvcgProcess AND CAInvcgDocumentPrintDate is not initial AND CAInvcgDocIsLockedForPrinting is initial AND CAInvcgIsDocumentSimulated is initial  -- association [0..*]
LEFT OUTER JOIN C_CAInvcgDocHeader AS _CAInvcgReversedDocument ON CAInvcgReversedDocument = _CAInvcgReversedDocument.CAInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN C_CAInvcgDocHeader AS _CAInvcgReversalDocument ON CAInvcgReversalDocument = _CAInvcgReversalDocument.CAInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN C_CAInvcgDocHeader AS _CAInvcgAdjustedDocument ON CAInvcgAdjustedDocument = _CAInvcgAdjustedDocument.CAInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN C_CAInvcgDocHeader AS _CAInvcgAdjustmentDocument ON CAInvcgAdjustmentDocument = _CAInvcgAdjustmentDocument.CAInvoicingDocument  -- association [0..1]
;