Deprecated
This CDS view is deprecated in S/4HANA. Use C_CABillgDocHeader instead. View all deprecated CDS views →

C_CABillgDocDisp

DDL: C_CABILLGDOCDISP Type: view_entity CONSUMPTION Package: ODATA_O2C_CI_BILLDOC

Abrechnungsbelege anzeigen

C_CABillgDocDisp is a Consumption CDS View that provides data about "Abrechnungsbelege anzeigen" in SAP S/4HANA. It reads from 1 data source (R_CABillgDocumentTP) and exposes 117 fields with key field CABillgDocument. It has 12 associations to related views. Part of development package ODATA_O2C_CI_BILLDOC.

Data Sources (1)

SourceAliasJoin Type
R_CABillgDocumentTP _CABillgDocHeader from

Associations (12)

CardinalityTargetAliasCondition
[1..*] C_CABillgDocItem _CABillgDocItem $projection.CABillgDocument = _CABillgDocItem.CABillgDocument
[1..*] C_CABillgDocSource _CABillgDocSource $projection.CABillgDocument = _CABillgDocSource.CABillgDocument
[1..*] C_CABillgDocTax _CABillgDocTax $projection.CABillgDocument = _CABillgDocTax.CABillgDocument
[1..*] C_CABillgDocPayment _CABillgDocPayment $projection.CABillgDocument = _CABillgDocPayment.CABillgDocument
[1..*] C_CABillgDocAdditional _CABillgDocAdditional $projection.CABillgDocument = _CABillgDocAdditional.CABillgDocument
[1..*] C_CABillgDocReference _CABillgDocReference $projection.CABillgDocument = _CABillgDocReference.CABillgDocument
[1..*] C_CABillgDocInvcgDocSource _CABillgDocInvcgDocSource $projection.CABillgDocument = _CABillgDocInvcgDocSource.CABillgDocument
[0..1] C_CABillgDocDisp _CABillgReversedDocument $projection.CABillgReversedDocument = _CABillgReversedDocument.CABillgDocument
[0..1] C_CABillgDocDisp _CABillgReversalDocument $projection.CABillgReversalDocument = _CABillgReversalDocument.CABillgDocument
[0..1] C_CABillgDocDisp _CABillgAdjustedDocument $projection.CABillgAdjustedDocument = _CABillgAdjustedDocument.CABillgDocument
[0..1] C_CABillgDocDisp _CABillgAdjustmentDocument $projection.CABillgAdjustmentDocument = _CABillgAdjustmentDocument.CABillgDocument
[0..1] E_CABillgDocHeader _Extension $projection.CABillgDocument = _Extension.CABillgDocument

Annotations (19)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Abrechnungsbelege anzeigen view
Consumption.semanticObject CABillgDocument view
Search.searchable true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey CABillgDocument view
Analytics.technicalName CCAINVBILL_DISP view
UI.headerInfo.typeName Abrechnungsbeleg anzeigen view
UI.headerInfo.typeNamePlural Abrechnungsbelege view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.label Abrechnungsbeleg view
UI.headerInfo.title.value CABillgDocument view
UI.headerInfo.description.value CABillgDocumentDescription view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_CABillgDocHeader view

Fields (117)

KeyFieldSource TableSource FieldDescription
KEY CABillgDocument R_CABillgDocumentTP CABillgDocument Billing Doc.
CAInvoicingDocument CAInvoicingDocument Fakturierungsbeleg
FirstName
LastName
BusinessPartnerFullName
BusinessPartner R_CABillgDocumentTP BusinessPartner Issuing Authority
ContractAccount R_CABillgDocumentTP ContractAccount Contract Acct
ContractAccountName
CAContract
CABillgType R_CABillgDocumentTP CABillgType Billing Type
CABillgTypeText
CABillgDocPeriodStartDate R_CABillgDocumentTP CABillgDocPeriodStartDate Start of Document Period
CABillgDocPeriodEndDate R_CABillgDocumentTP CABillgDocPeriodEndDate End of Document Period
CABillgDocCreationDate R_CABillgDocumentTP CABillgDocCreationDate Billed On
CABillgDocCreationTime R_CABillgDocumentTP CABillgDocCreationTime Billed At
CABillgDocumentReversalReason R_CABillgDocumentTP CABillgDocumentReversalReason Reversal Reason
CABillgDocReversalReasonText
CABillgIsDocumentSimulated R_CABillgDocumentTP CABillgIsDocumentSimulated Simulation Doc.
CABillgDocumentExternal R_CABillgDocumentTP CABillgDocumentExternal External Document Number
LogicalSystem R_CABillgDocumentTP LogicalSystem Logical System
CAApplicationArea R_CABillgDocumentTP CAApplicationArea ApplicationArea
CABillgDocOriginProcess R_CABillgDocumentTP CABillgDocOriginProcess Origin
CABillgDocOriginProcessText
CAInvcgSourceDocumentType R_CABillgDocumentTP CAInvcgSourceDocumentType Source Doc.Type
CAInvcgSourceDocTypeText
CAInvcgTechnicalDocumentType R_CABillgDocumentTP CAInvcgTechnicalDocumentType Technical Document Type
CAInvcgDocTechDocTypeText
CAInvcgDocumentType R_CABillgDocumentTP CAInvcgDocumentType Document Type
CAInvcgDocumentTypeText
CAInvcgTargetProcess R_CABillgDocumentTP CAInvcgTargetProcess Target Process
CAInvcgTargetProcText
CAInvcgMasterDataType R_CABillgDocumentTP CAInvcgMasterDataType MasterData Type
CAInvcgMasterDataTypeText
CAInvcgAltvBusinessPartner R_CABillgDocumentTP CAInvcgAltvBusinessPartner Altv Business Partner
CAInvcgAltvContractAccount R_CABillgDocumentTP CAInvcgAltvContractAccount Altv Contract Account
CABillgBaseDate R_CABillgDocumentTP CABillgBaseDate Baseline Date
CABillgCurrency R_CABillgDocumentTP CABillgCurrency Currency
CAInvcgCurrency R_CABillgDocumentTP CAInvcgCurrency Invoicing Target Currency
CATaxDetnType R_CABillgDocumentTP CATaxDetnType Tax Calculation
CATaxDetnTypeText
CATaxDateType R_CABillgDocumentTP CATaxDateType Tax Date
CATaxDateTypeText
CAInvcgCategory R_CABillgDocumentTP CAInvcgCategory Invoicing Cat.
CAInvcgCategoryText
CAInvcgControlOfInvoicingUnit R_CABillgDocumentTP CAInvcgControlOfInvoicingUnit Invoicing Unit Control
CAInvcgControlOfInvcgUnitTxt
CAInvcgFirstDate R_CABillgDocumentTP CAInvcgFirstDate Invoice From
CABillgReversalDocument R_CABillgDocumentTP CABillgReversalDocument Reversal Document Number
CABillgReversedDocument R_CABillgDocumentTP CABillgReversedDocument Rev. Doc. For
CABillgAdjustmentDocument R_CABillgDocumentTP CABillgAdjustmentDocument Adjustment Billg Documnt
CABillgAdjustedDocument R_CABillgDocumentTP CABillgAdjustedDocument Adjusted Document
CAInvcgCorrectionCategory R_CABillgDocumentTP CAInvcgCorrectionCategory Invcg Correction Category
CAInvcgCorrectionCatText
CaInvcgIsOrderDeleted R_CABillgDocumentTP CaInvcgIsOrderDeleted Invoicing Order Deleted
CABillgHasAdditionalInvoice R_CABillgDocumentTP CABillgHasAdditionalInvoice Info in Invoice
CABillgAdditionalInvoiceText
CAInvcgIsAccrualPostingRlvt R_CABillgDocumentTP CAInvcgIsAccrualPostingRlvt Accrual/Deferral Posting
CABillgLockedForInvoicing R_CABillgDocumentTP CABillgLockedForInvoicing Invoicing Lock
CABillgLockedForInvcgText
CABillgGrpgOfAdditionalItems R_CABillgDocumentTP CABillgGrpgOfAdditionalItems Additional Item Grouping
CABillgDocHasRefObjects R_CABillgDocumentTP CABillgDocHasRefObjects Object References Exist
CABillgDocumentNumberOfItems R_CABillgDocumentTP CABillgDocumentNumberOfItems Number of Items
CABllbleItmNumber R_CABillgDocumentTP CABllbleItmNumber Number of Billable Items
CreatedByUser R_CABillgDocumentTP CreatedByUser User Name
CABillgDocInternalNumber R_CABillgDocumentTP CABillgDocInternalNumber Billing Run Number
CABillgProcess R_CABillgDocumentTP CABillgProcess Billing Process
CABillgProcessText
CABillgDocHasPrepaidItems R_CABillgDocumentTP CABillgDocHasPrepaidItems Prepaid
CABillgDocHasRefillItems R_CABillgDocumentTP CABillgDocHasRefillItems Prepaid Refill
CABillgDocHasRevnRecgnItems R_CABillgDocumentTP CABillgDocHasRevnRecgnItems Rev Deferral
CAPartnerSettlementRule R_CABillgDocumentTP CAPartnerSettlementRule Settlement Rule
CABillgDocumentInvcgStatus R_CABillgDocumentTP CABillgDocumentInvcgStatus Invoicg Status
CABillgDocumentInvcgStatusText
CAInvcgCreationDate R_CABillgDocumentTP CAInvcgCreationDate Invoiced On
CASubAreaForParallelization R_CABillgDocumentTP CASubAreaForParallelization Subarea
CAAltvMDOriginalIsIncluded R_CABillgDocumentTP CAAltvMDOriginalIsIncluded OriglMasterData
CAInvcgClrfctnCreateIsEnabled
CAInvcgClarificationIsExisting
_CABillgDocItem _CABillgDocItem
_CABillgDocTax _CABillgDocTax
_CABillgDocSource _CABillgDocSource
_CABillgDocPayment _CABillgDocPayment
_CABillgDocAdditional _CABillgDocAdditional
_CABillgDocReference _CABillgDocReference
_CABillgDocInvcgDocSource _CABillgDocInvcgDocSource
_ContractAccountPartner _ContractAccountPartner
_BusinessPartner _BusinessPartner
_ContractAccountHeader _ContractAccountHeader
_CAInvcgAltvBusinessPartner _CAInvcgAltvBusinessPartner
_CAInvcgAltvContractAccount _CAInvcgAltvContractAccount
_CABillgReversalDocument _CABillgReversalDocument
_CABillgReversedDocument _CABillgReversedDocument
_CABillgAdjustedDocument _CABillgAdjustedDocument
_CABillgAdjustmentDocument _CABillgAdjustmentDocument
_CAApplicationArea _CAApplicationArea
_CABillgCurrency _CABillgCurrency
_CAInvcgCurrency _CAInvcgCurrency
_CABillgDocOriginProcess _CABillgDocOriginProcess
_CAInvcgSourceDocType _CAInvcgSourceDocType
_CAInvcgTargetProc _CAInvcgTargetProc
_CAInvcgCategory _CAInvcgCategory
_CABillgProcess _CABillgProcess
_CABillgType _CABillgType
_CAInvcgDocTechDocType _CAInvcgDocTechDocType
_CAInvcgMasterDataType _CAInvcgMasterDataType
_CATaxDetnType _CATaxDetnType
_CATaxDateType _CATaxDateType
_CAInvcgDocumentType _CAInvcgDocumentType
_CAInvcgControlOfInvcgUnit _CAInvcgControlOfInvcgUnit
_CAInvcgCorrectionCat _CAInvcgCorrectionCat
_CABillgExistsAddInvcg _CABillgExistsAddInvcg
_CABillgLockedForInvcg _CABillgLockedForInvcg
_CABillgDocInvcgStatus _CABillgDocInvcgStatus
_CABillgDocReversalReason _CABillgDocReversalReason
_CAInvcgUserContact _CAInvcgUserContact
CAInvcgSourceDocumentNumber
CAInvcgSourceDocumentCat

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_CABillgDocDisp.
-- 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_CABillgDocDisp AS
SELECT
  _CABillgDocHeader.CABillgDocument AS CABillgDocument,
  CAInvoicingDocument,
  _CABillgDocHeader._BusinessPartner.FirstName AS FirstName,
  _CABillgDocHeader._BusinessPartner.LastName AS LastName,
  _CABillgDocHeader._BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _CABillgDocHeader.BusinessPartner AS BusinessPartner,
  _CABillgDocHeader.ContractAccount AS ContractAccount,
  _CABillgDocHeader._ContractAccountHeader.ContractAccountName AS ContractAccountName,
  cast('' as vtref_kk) AS CAContract,
  _CABillgDocHeader.CABillgType AS CABillgType,
  _CABillgType._CABillgTypeText[1: Language=$session.system_language].CABillgTypeText AS CABillgTypeText,
  _CABillgDocHeader.CABillgDocPeriodStartDate AS CABillgDocPeriodStartDate,
  _CABillgDocHeader.CABillgDocPeriodEndDate AS CABillgDocPeriodEndDate,
  _CABillgDocHeader.CABillgDocCreationDate AS CABillgDocCreationDate,
  _CABillgDocHeader.CABillgDocCreationTime AS CABillgDocCreationTime,
  _CABillgDocHeader.CABillgDocumentReversalReason AS CABillgDocumentReversalReason,
  _CABillgDocReversalReason._CABillgDocReversalReasonText[1: Language=$session.system_language].CABillgDocReversalReasonText AS CABillgDocReversalReasonText,
  _CABillgDocHeader.CABillgIsDocumentSimulated AS CABillgIsDocumentSimulated,
  _CABillgDocHeader.CABillgDocumentExternal AS CABillgDocumentExternal,
  _CABillgDocHeader.LogicalSystem AS LogicalSystem,
  _CABillgDocHeader.CAApplicationArea AS CAApplicationArea,
  _CABillgDocHeader.CABillgDocOriginProcess AS CABillgDocOriginProcess,
  _CABillgDocOriginProcess._CABillgDocOriginProcessText[1: Language=$session.system_language].CABillgDocOriginProcessText AS CABillgDocOriginProcessText,
  _CABillgDocHeader.CAInvcgSourceDocumentType AS CAInvcgSourceDocumentType,
  _CAInvcgSourceDocType._CAInvcgSourceDocTypeText[1: Language=$session.system_language].CAInvcgSourceDocTypeText AS CAInvcgSourceDocTypeText,
  _CABillgDocHeader.CAInvcgTechnicalDocumentType AS CAInvcgTechnicalDocumentType,
  _CAInvcgDocTechDocType._CAInvcgDocTechDocTypeText[1: Language=$session.system_language].CAInvcgDocTechDocTypeText AS CAInvcgDocTechDocTypeText,
  _CABillgDocHeader.CAInvcgDocumentType AS CAInvcgDocumentType,
  _CAInvcgDocumentType._CAInvcgDocumentTypeText[1: Language=$session.system_language].CAInvcgDocumentTypeText AS CAInvcgDocumentTypeText,
  _CABillgDocHeader.CAInvcgTargetProcess AS CAInvcgTargetProcess,
  _CAInvcgTargetProc._CAInvcgTargetProcText[1: Language=$session.system_language].CAInvcgTargetProcText AS CAInvcgTargetProcText,
  _CABillgDocHeader.CAInvcgMasterDataType AS CAInvcgMasterDataType,
  _CAInvcgMasterDataType._CAInvcgMasterDataTypeText[1: Language=$session.system_language].CAInvcgMasterDataTypeText AS CAInvcgMasterDataTypeText,
  _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[1: Language=$session.system_language].CATaxDetnTypeText AS CATaxDetnTypeText,
  _CABillgDocHeader.CATaxDateType AS CATaxDateType,
  _CATaxDateType._CATaxDateTypeText[1: Language=$session.system_language].CATaxDateTypeText AS CATaxDateTypeText,
  _CABillgDocHeader.CAInvcgCategory AS CAInvcgCategory,
  _CAInvcgCategory._CAInvcgCategoryText[1: Language=$session.system_language].CAInvcgCategoryText AS CAInvcgCategoryText,
  _CABillgDocHeader.CAInvcgControlOfInvoicingUnit AS CAInvcgControlOfInvoicingUnit,
  _CAInvcgControlOfInvcgUnit._CAInvcgControlOfInvcgUnitTxt[1: Language=$session.system_language].CAInvcgControlOfInvcgUnitTxt AS CAInvcgControlOfInvcgUnitTxt,
  _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[1: Language=$session.system_language].CAInvcgCorrectionCatText AS CAInvcgCorrectionCatText,
  _CABillgDocHeader.CaInvcgIsOrderDeleted AS CaInvcgIsOrderDeleted,
  _CABillgDocHeader.CABillgHasAdditionalInvoice AS CABillgHasAdditionalInvoice,
  _CABillgExistsAddInvcg._CABillgExistsAddInvcgText[1: Language=$session.system_language].CABillgAdditionalInvoiceText AS CABillgAdditionalInvoiceText,
  _CABillgDocHeader.CAInvcgIsAccrualPostingRlvt AS CAInvcgIsAccrualPostingRlvt,
  _CABillgDocHeader.CABillgLockedForInvoicing AS CABillgLockedForInvoicing,
  _CABillgLockedForInvcg._CABillgLockedForInvcgText[1: Language=$session.system_language].CABillgLockedForInvcgText AS CABillgLockedForInvcgText,
  _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[1: Language=$session.system_language].CABillgProcessText AS CABillgProcessText,
  _CABillgDocHeader.CABillgDocHasPrepaidItems AS CABillgDocHasPrepaidItems,
  _CABillgDocHeader.CABillgDocHasRefillItems AS CABillgDocHasRefillItems,
  _CABillgDocHeader.CABillgDocHasRevnRecgnItems AS CABillgDocHasRevnRecgnItems,
  _CABillgDocHeader.CAPartnerSettlementRule AS CAPartnerSettlementRule,
  _CABillgDocHeader.CABillgDocumentInvcgStatus AS CABillgDocumentInvcgStatus,
  _CABillgDocInvcgStatus._CABillgDocInvcgStatusText[1: Language=$session.system_language].CABillgDocumentInvcgStatusText AS CABillgDocumentInvcgStatusText,
  _CABillgDocHeader.CAInvcgCreationDate AS CAInvcgCreationDate,
  _CABillgDocHeader.CASubAreaForParallelization AS CASubAreaForParallelization,
  _CABillgDocHeader.CAAltvMDOriginalIsIncluded AS CAAltvMDOriginalIsIncluded,
  cast('' as xfeld ) AS CAInvcgClrfctnCreateIsEnabled,
  cast('' as xfeld ) AS CAInvcgClarificationIsExisting,
  concat('00000000', _CABillgDocHeader.CABillgDocument ) AS CAInvcgSourceDocumentNumber,
  'INVBI' AS CAInvcgSourceDocumentCat
FROM R_CABillgDocumentTP AS _CABillgDocHeader
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_CABillgDocDisp AS _CABillgReversedDocument ON CABillgReversedDocument = _CABillgReversedDocument.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN C_CABillgDocDisp AS _CABillgReversalDocument ON CABillgReversalDocument = _CABillgReversalDocument.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN C_CABillgDocDisp AS _CABillgAdjustedDocument ON CABillgAdjustedDocument = _CABillgAdjustedDocument.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN C_CABillgDocDisp AS _CABillgAdjustmentDocument ON CABillgAdjustmentDocument = _CABillgAdjustmentDocument.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN E_CABillgDocHeader AS _Extension ON CABillgDocument = _Extension.CABillgDocument  -- association [0..1]
;