What is C_CAInvcgOvwBillgDocHeader in SAP S/4HANA?

C_CAInvcgOvwBillgDocHeader is a consumption CDS view in SAP S/4HANA. Abrechnungsbelegkopf anzeigen It contains 105 fields.

Which tables does C_CAInvcgOvwBillgDocHeader read from?

C_CAInvcgOvwBillgDocHeader reads data from: I_CABillgDocHeader.

What VDM layer is C_CAInvcgOvwBillgDocHeader?

C_CAInvcgOvwBillgDocHeader is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CAInvcgOvwBillgDocHeader

DDL: C_CAINVCGOVWBILLGDOCHEADER Type: view_entity CONSUMPTION

105 Fields 1 Data Sources 7 Associations

Abrechnungsbelegkopf anzeigen

C_CAInvcgOvwBillgDocHeader is a Consumption CDS View that provides data about "Abrechnungsbelegkopf anzeigen" in SAP S/4HANA. It reads from 1 data source (I_CABillgDocHeader) and exposes 105 fields with key field CABillgDocument. It has 7 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CABillgDocHeader	_CABillgDocHeader	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..1]	I_CABillgDocInvcgDoc	_CABillgDocInvcgDoc	`$projection.CABillgDocument = _CABillgDocInvcgDoc.CABillgDocument`
[0..1]	I_BusinessPartner	_BusinessPartner	`$projection.BusinessPartner = _BusinessPartner.BusinessPartner`
[0..1]	I_ContractAccountPartner	_ContractAccountPartner	`$projection.ContractAccount = _ContractAccountPartner.ContractAccount and $projection.BusinessPartner = _ContractAccountPartner.BusinessPartner and $projection.BusinessPartner = _ContractAccountPartner.BusinessPartner`
[0..1]	I_ContractAccountHeader	_ContractAccountHeader	`$projection.ContractAccount = _ContractAccountHeader.ContractAccount`
[0..1]	I_CAInvcgDocumentType	_CAInvcgDocumentType	`$projection.CAInvcgDocumentType = _CAInvcgDocumentType.CAInvcgDocumentType and $projection.CAApplicationArea = _CAInvcgDocumentType.CAApplicationArea and _CAInvcgDocumentType.NameNumberRangeObject = 'FKKINVBILL'`
[0..1]	C_CAInvcgUserContact	_CAInvcgUserContact	`$projection.CreatedByUser = _CAInvcgUserContact.ContactCardID`
[0..1]	E_CABillgDocHeader	_Extension	`$projection.CABillgDocument = _Extension.CABillgDocument`

Annotations (9)

Name	Value	Level
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Abrechnungsbelegkopf anzeigen	view
Consumption.semanticObject	CABillgDocument	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (105)

Key	Field	Source Table	Source Field	Description
KEY	CABillgDocument	I_CABillgDocHeader	CABillgDocument	Billing Doc.
	CAInvoicingDocument		CAInvoicingDocument	Invoic. Doc.
	FirstName	_BusinessPartner	FirstName	First Name
	LastName	_BusinessPartner	LastName	Last Name
	BusinessPartnerFullName	_BusinessPartner	BusinessPartnerFullName	Broker Name
	StreetName
	AddressCityName
	Country
	BusinessPartner	I_CABillgDocHeader	BusinessPartner	Issuing Authority
	ContractAccount	I_CABillgDocHeader	ContractAccount	Contract Acct
	ContractAccountName	_ContractAccountHeader	ContractAccountName	Cont. acct name
	CABillgType	I_CABillgDocHeader	CABillgType	Billing Type
	CABillgDocPeriodStartDate	I_CABillgDocHeader	CABillgDocPeriodStartDate	Start of Document Period
	CABillgDocPeriodEndDate	I_CABillgDocHeader	CABillgDocPeriodEndDate	End of Document Period
	CABillgDocCreationDate	I_CABillgDocHeader	CABillgDocCreationDate	Billed On
	CABillgDocCreationTime	I_CABillgDocHeader	CABillgDocCreationTime	Billed At
	CABillgDocumentReversalReason	I_CABillgDocHeader	CABillgDocumentReversalReason	Reversal Reason
	CABillgIsDocumentSimulated	I_CABillgDocHeader	CABillgIsDocumentSimulated	Simulation Doc.
	CABillgDocumentExternal	I_CABillgDocHeader	CABillgDocumentExternal	External Document Number
	LogicalSystem	I_CABillgDocHeader	LogicalSystem	Logical System
	CAApplicationArea	I_CABillgDocHeader	CAApplicationArea	ApplicationArea
	CABillgDocOriginProcess	I_CABillgDocHeader	CABillgDocOriginProcess	Origin
	CAInvcgSourceDocumentType	I_CABillgDocHeader	CAInvcgSourceDocumentType	Source Doc.Type
	CAInvcgTechnicalDocumentType	I_CABillgDocHeader	CAInvcgTechnicalDocumentType	Technical Document Type
	CAInvcgDocumentType	I_CABillgDocHeader	CAInvcgDocumentType	Document Type
	CAInvcgTargetProcess	I_CABillgDocHeader	CAInvcgTargetProcess	Target Process
	CAInvcgMasterDataType	I_CABillgDocHeader	CAInvcgMasterDataType	MasterData Type
	CAInvcgAltvBusinessPartner	I_CABillgDocHeader	CAInvcgAltvBusinessPartner	Altv Business Partner
	CAInvcgAltvContractAccount	I_CABillgDocHeader	CAInvcgAltvContractAccount	Altv Contract Account
	CABillgBaseDate	I_CABillgDocHeader	CABillgBaseDate	Baseline Date
	CABillgCurrency	I_CABillgDocHeader	CABillgCurrency	Currency
	CAInvcgCurrency	I_CABillgDocHeader	CAInvcgCurrency	Invoicing Target Currency
	CATaxDetnType	I_CABillgDocHeader	CATaxDetnType	Tax Calculation
	CATaxDateType	I_CABillgDocHeader	CATaxDateType	Tax Date
	CAInvcgCategory	I_CABillgDocHeader	CAInvcgCategory	Invoicing Cat.
	CAInvcgControlOfInvoicingUnit	I_CABillgDocHeader	CAInvcgControlOfInvoicingUnit	Invoicing Unit Control
	CAInvcgFirstDate	I_CABillgDocHeader	CAInvcgFirstDate	Invoice From
	CABillgReversalDocument	I_CABillgDocHeader	CABillgReversalDocument	Reversal Document Number
	CABillgReversedDocument	I_CABillgDocHeader	CABillgReversedDocument	Rev. Doc. For
	CABillgAdjustmentDocument	I_CABillgDocHeader	CABillgAdjustmentDocument	Adjustment Billg Documnt
	CABillgAdjustedDocument	I_CABillgDocHeader	CABillgAdjustedDocument	Adjusted Document
	CAInvcgCorrectionCategory	I_CABillgDocHeader	CAInvcgCorrectionCategory	Invcg Correction Category
	CaInvcgIsOrderDeleted	I_CABillgDocHeader	CaInvcgIsOrderDeleted	Invoicing Order Deleted
	CABillgHasAdditionalInvoice	I_CABillgDocHeader	CABillgHasAdditionalInvoice	Info in Invoice
	CABillgLockedForInvoicing	I_CABillgDocHeader	CABillgLockedForInvoicing	Invoicing Lock
	CABillgGrpgOfAdditionalItems	I_CABillgDocHeader	CABillgGrpgOfAdditionalItems	Additional Item Grouping
	CABillgDocHasRefObjects	I_CABillgDocHeader	CABillgDocHasRefObjects	Object References Exist
	CABillgDocumentNumberOfItems	I_CABillgDocHeader	CABillgDocumentNumberOfItems	Number of Items
	CreatedByUser	I_CABillgDocHeader	CreatedByUser	User Name
	CABillgDocInternalNumber	I_CABillgDocHeader	CABillgDocInternalNumber	Billing Run Number
	CABillgProcess	I_CABillgDocHeader	CABillgProcess	Billing Process
	CABillgDocHasPrepaidItems	I_CABillgDocHeader	CABillgDocHasPrepaidItems	Prepaid
	CABillgDocHasRefillItems	I_CABillgDocHeader	CABillgDocHasRefillItems	Prepaid Refill
	CABillgDocHasRevnRecgnItems	I_CABillgDocHeader	CABillgDocHasRevnRecgnItems	Rev Deferral
	CAPartnerSettlementRule	I_CABillgDocHeader	CAPartnerSettlementRule	Settlement Rule
	CABillgDocumentInvcgStatus	I_CABillgDocHeader	CABillgDocumentInvcgStatus	Invoicg Status
	CAInvcgCreationDate	I_CABillgDocHeader	CAInvcgCreationDate	Invoiced On
	CASubAreaForParallelization	I_CABillgDocHeader	CASubAreaForParallelization	Subarea
	CAAltvMDOriginalIsIncluded	I_CABillgDocHeader	CAAltvMDOriginalIsIncluded	OriglMasterData
	CAInvcgDocumentTypeText
	CABillgDocOriginProcessText
	CAInvcgTargetProcText
	CAInvcgCategoryText
	CABillgProcessText
	CABillgTypeText
	CAInvcgDocTechDocTypeText
	CABillgDocReversalReasonText
	CAInvcgMasterDataTypeText
	CATaxDetnTypeText
	CATaxDateTypeText
	CAInvcgControlOfInvcgUnitTxt
	CAInvcgCorrectionCatText
	CABillgAdditionalInvoiceText
	CABillgLockedForInvcgText
	_ContractAccountPartner		_ContractAccountPartner
	_ContractAccountHeader		_ContractAccountHeader
	_CABillgDocInvcgDoc		_CABillgDocInvcgDoc
	_BusinessPartner		_BusinessPartner
	_CAInvcgAltvBusinessPartner		_CAInvcgAltvBusinessPartner
	_CAInvcgAltvContractAccount		_CAInvcgAltvContractAccount
	_CABillgReversalDocument		_CABillgReversalDocument
	_CABillgReversedDocument		_CABillgReversedDocument
	_CABillgAdjustedDocument		_CABillgAdjustedDocument
	_CABillgAdjustmentDocument		_CABillgAdjustmentDocument
	_CAApplicationArea		_CAApplicationArea
	_CABillgCurrency		_CABillgCurrency
	_CAInvcgCurrency		_CAInvcgCurrency
	_CABillgDocOriginProcess		_CABillgDocOriginProcess
	_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
	_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_CAInvcgOvwBillgDocHeader.
-- 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_CAInvcgOvwBillgDocHeader AS
SELECT
  _CABillgDocHeader.CABillgDocument AS CABillgDocument,
  CAInvoicingDocument,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.LastName AS LastName,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  concat_with_space(_BusinessPartner._CurrentDefaultAddress._StandardAddress.StreetName, _BusinessPartner._CurrentDefaultAddress._StandardAddress.HouseNumber, 1) AS StreetName,
  concat_with_space(_BusinessPartner._CurrentDefaultAddress._StandardAddress.PostalCode, _BusinessPartner._CurrentDefaultAddress._StandardAddress.CityName, 1) AS AddressCityName,
  _BusinessPartner._CurrentDefaultAddress._StandardAddress.Country AS Country,
  _CABillgDocHeader.BusinessPartner AS BusinessPartner,
  _CABillgDocHeader.ContractAccount AS ContractAccount,
  _ContractAccountHeader.ContractAccountName AS ContractAccountName,
  _CABillgDocHeader.CABillgType AS CABillgType,
  _CABillgDocHeader.CABillgDocPeriodStartDate AS CABillgDocPeriodStartDate,
  _CABillgDocHeader.CABillgDocPeriodEndDate AS CABillgDocPeriodEndDate,
  _CABillgDocHeader.CABillgDocCreationDate AS CABillgDocCreationDate,
  _CABillgDocHeader.CABillgDocCreationTime AS CABillgDocCreationTime,
  _CABillgDocHeader.CABillgDocumentReversalReason AS CABillgDocumentReversalReason,
  _CABillgDocHeader.CABillgIsDocumentSimulated AS CABillgIsDocumentSimulated,
  _CABillgDocHeader.CABillgDocumentExternal AS CABillgDocumentExternal,
  _CABillgDocHeader.LogicalSystem AS LogicalSystem,
  _CABillgDocHeader.CAApplicationArea AS CAApplicationArea,
  _CABillgDocHeader.CABillgDocOriginProcess AS CABillgDocOriginProcess,
  _CABillgDocHeader.CAInvcgSourceDocumentType AS CAInvcgSourceDocumentType,
  _CABillgDocHeader.CAInvcgTechnicalDocumentType AS CAInvcgTechnicalDocumentType,
  _CABillgDocHeader.CAInvcgDocumentType AS CAInvcgDocumentType,
  _CABillgDocHeader.CAInvcgTargetProcess AS CAInvcgTargetProcess,
  _CABillgDocHeader.CAInvcgMasterDataType AS CAInvcgMasterDataType,
  _CABillgDocHeader.CAInvcgAltvBusinessPartner AS CAInvcgAltvBusinessPartner,
  _CABillgDocHeader.CAInvcgAltvContractAccount AS CAInvcgAltvContractAccount,
  _CABillgDocHeader.CABillgBaseDate AS CABillgBaseDate,
  _CABillgDocHeader.CABillgCurrency AS CABillgCurrency,
  _CABillgDocHeader.CAInvcgCurrency AS CAInvcgCurrency,
  _CABillgDocHeader.CATaxDetnType AS CATaxDetnType,
  _CABillgDocHeader.CATaxDateType AS CATaxDateType,
  _CABillgDocHeader.CAInvcgCategory AS CAInvcgCategory,
  _CABillgDocHeader.CAInvcgControlOfInvoicingUnit AS CAInvcgControlOfInvoicingUnit,
  _CABillgDocHeader.CAInvcgFirstDate AS CAInvcgFirstDate,
  _CABillgDocHeader.CABillgReversalDocument AS CABillgReversalDocument,
  _CABillgDocHeader.CABillgReversedDocument AS CABillgReversedDocument,
  _CABillgDocHeader.CABillgAdjustmentDocument AS CABillgAdjustmentDocument,
  _CABillgDocHeader.CABillgAdjustedDocument AS CABillgAdjustedDocument,
  _CABillgDocHeader.CAInvcgCorrectionCategory AS CAInvcgCorrectionCategory,
  _CABillgDocHeader.CaInvcgIsOrderDeleted AS CaInvcgIsOrderDeleted,
  _CABillgDocHeader.CABillgHasAdditionalInvoice AS CABillgHasAdditionalInvoice,
  _CABillgDocHeader.CABillgLockedForInvoicing AS CABillgLockedForInvoicing,
  _CABillgDocHeader.CABillgGrpgOfAdditionalItems AS CABillgGrpgOfAdditionalItems,
  _CABillgDocHeader.CABillgDocHasRefObjects AS CABillgDocHasRefObjects,
  _CABillgDocHeader.CABillgDocumentNumberOfItems AS CABillgDocumentNumberOfItems,
  _CABillgDocHeader.CreatedByUser AS CreatedByUser,
  _CABillgDocHeader.CABillgDocInternalNumber AS CABillgDocInternalNumber,
  _CABillgDocHeader.CABillgProcess AS CABillgProcess,
  _CABillgDocHeader.CABillgDocHasPrepaidItems AS CABillgDocHasPrepaidItems,
  _CABillgDocHeader.CABillgDocHasRefillItems AS CABillgDocHasRefillItems,
  _CABillgDocHeader.CABillgDocHasRevnRecgnItems AS CABillgDocHasRevnRecgnItems,
  _CABillgDocHeader.CAPartnerSettlementRule AS CAPartnerSettlementRule,
  _CABillgDocHeader.CABillgDocumentInvcgStatus AS CABillgDocumentInvcgStatus,
  _CABillgDocHeader.CAInvcgCreationDate AS CAInvcgCreationDate,
  _CABillgDocHeader.CASubAreaForParallelization AS CASubAreaForParallelization,
  _CABillgDocHeader.CAAltvMDOriginalIsIncluded AS CAAltvMDOriginalIsIncluded,
  _CAInvcgDocumentType._CAInvcgDocumentTypeText[1: Language=$session.system_language].CAInvcgDocumentTypeText AS CAInvcgDocumentTypeText,
  _CABillgDocOriginProcess._CABillgDocOriginProcessText[1: Language=$session.system_language].CABillgDocOriginProcessText AS CABillgDocOriginProcessText,
  _CAInvcgTargetProc._CAInvcgTargetProcText[1: Language=$session.system_language].CAInvcgTargetProcText AS CAInvcgTargetProcText,
  _CAInvcgCategory._CAInvcgCategoryText[1: Language=$session.system_language].CAInvcgCategoryText AS CAInvcgCategoryText,
  _CABillgProcess._CABillgProcessText[1: Language=$session.system_language].CABillgProcessText AS CABillgProcessText,
  _CABillgType._CABillgTypeText[1: Language=$session.system_language].CABillgTypeText AS CABillgTypeText,
  _CAInvcgDocTechDocType._CAInvcgDocTechDocTypeText[1: Language=$session.system_language].CAInvcgDocTechDocTypeText AS CAInvcgDocTechDocTypeText,
  _CABillgDocReversalReason._CABillgDocReversalReasonText[1: Language=$session.system_language].CABillgDocReversalReasonText AS CABillgDocReversalReasonText,
  _CAInvcgMasterDataType._CAInvcgMasterDataTypeText[1: Language=$session.system_language].CAInvcgMasterDataTypeText AS CAInvcgMasterDataTypeText,
  _CATaxDetnType._CATaxDetnTypeText[1: Language=$session.system_language].CATaxDetnTypeText AS CATaxDetnTypeText,
  _CATaxDateType._CATaxDateTypeText[1: Language=$session.system_language].CATaxDateTypeText AS CATaxDateTypeText,
  _CAInvcgControlOfInvcgUnit._CAInvcgControlOfInvcgUnitTxt[1: Language=$session.system_language].CAInvcgControlOfInvcgUnitTxt AS CAInvcgControlOfInvcgUnitTxt,
  _CAInvcgCorrectionCat._CAInvcgCorrectionCatText[1: Language=$session.system_language].CAInvcgCorrectionCatText AS CAInvcgCorrectionCatText,
  _CABillgExistsAddInvcg._CABillgExistsAddInvcgText[1: Language=$session.system_language].CABillgAdditionalInvoiceText AS CABillgAdditionalInvoiceText,
  _CABillgLockedForInvcg._CABillgLockedForInvcgText[1: Language=$session.system_language].CABillgLockedForInvcgText AS CABillgLockedForInvcgText,
  concat('00000000', _CABillgDocHeader.CABillgDocument ) AS CAInvcgSourceDocumentNumber,
  'INVBI' AS CAInvcgSourceDocumentCat
FROM I_CABillgDocHeader AS _CABillgDocHeader
LEFT OUTER JOIN I_CABillgDocInvcgDoc AS _CABillgDocInvcgDoc ON CABillgDocument = _CABillgDocInvcgDoc.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocumentType AS _CAInvcgDocumentType ON CAInvcgDocumentType = _CAInvcgDocumentType.CAInvcgDocumentType AND CAApplicationArea = _CAInvcgDocumentType.CAApplicationArea AND _CAInvcgDocumentType.NameNumberRangeObject = 'FKKINVBILL'  -- association [0..1]
LEFT OUTER JOIN C_CAInvcgUserContact AS _CAInvcgUserContact ON CreatedByUser = _CAInvcgUserContact.ContactCardID  -- association [0..1]
LEFT OUTER JOIN E_CABillgDocHeader AS _Extension ON CABillgDocument = _Extension.CABillgDocument  -- association [0..1]
;

Depth:

C_CAInvcgOvwBillgDocHeader view_entity

I_CABillgDocHeader view_entity