What is C_CAInvcgOvwInvcgRequest in SAP S/4HANA?

C_CAInvcgOvwInvcgRequest is a consumption CDS view in SAP S/4HANA. Fakturierungsaufträge anzeigen It contains 67 fields.

Which tables does C_CAInvcgOvwInvcgRequest read from?

C_CAInvcgOvwInvcgRequest reads data from: I_CAInvcgRequest.

What VDM layer is C_CAInvcgOvwInvcgRequest?

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

C_CAInvcgOvwInvcgRequest

DDL: C_CAINVCGOVWINVCGREQUEST Type: view_entity CONSUMPTION

67 Fields 1 Data Sources 1 Associations

Fakturierungsaufträge anzeigen

C_CAInvcgOvwInvcgRequest is a Consumption CDS View that provides data about "Fakturierungsaufträge anzeigen" in SAP S/4HANA. It reads from 1 data source (I_CAInvcgRequest) and exposes 67 fields with key fields CAInvcgSourceDocumentCat, CAInvcgSourceDocumentNumber. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
I_CAInvcgRequest	_CAInvcgRequest	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_ContractAccountPartner	_ContractAccountPartner	`$projection.ContractAccount = _ContractAccountPartner.ContractAccount and $projection.BusinessPartner = _ContractAccountPartner.BusinessPartner`

Annotations (9)

Name	Value	Level
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
Metadata.allowExtensions	true	view
ObjectModel.representativeKey	CAInvcgSourceDocumentNumber	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
EndUserText.label	Fakturierungsaufträge anzeigen	view

Fields (67)

Key	Field	Source Table	Source Field	Description
KEY	CAInvcgSourceDocumentCat		CAInvcgSourceDocumentCat	Source Document Category
KEY	CAInvcgSourceDocumentNumber		CAInvcgSourceDocumentNumber	Source Document Number
	CAInvcgSourceDocumentSemObj
	BusinessPartner	I_CAInvcgRequest	BusinessPartner	Issuing Authority
	BusinessPartnerName	_BusinessPartner	BusinessPartnerName	Extracted Customer Name
	ContractAccount	I_CAInvcgRequest	ContractAccount	Contract Acct
	ContractAccountName	_ContractAccountHeader	ContractAccountName	Cont. acct name
	TransactionCurrency	I_CAInvcgRequest	TransactionCurrency	Transaction Currency
	CAInvcgSourceDocumentAmount	I_CAInvcgRequest	CAInvcgSourceDocumentAmount	Amount in SrcDoc Crcy
	CAInvcgFirstDate	I_CAInvcgRequest	CAInvcgFirstDate	Invoice From
	CAInvcgReqCreationDate	I_CAInvcgRequest	CAInvcgReqCreationDate	Sizing Date
	AltvContractAcctForCollvBills	I_CAInvcgRequest	AltvContractAcctForCollvBills	Coll. Bill Acct
	BusinessPlace	I_CAInvcgRequest	BusinessPlace	Business place
	CAApplicationArea	I_CAInvcgRequest	CAApplicationArea	ApplicationArea
	CABillgDocOriginProcess	I_CAInvcgRequest	CABillgDocOriginProcess	Origin
	CAInvcgReqEndDate	I_CAInvcgRequest	CAInvcgReqEndDate
	CAInvcgReqStartDate	I_CAInvcgRequest	CAInvcgReqStartDate
	CAContract	I_CAInvcgRequest	CAContract	Contract
	CAContractSemanticObject
	CAInvcgCategory	I_CAInvcgRequest	CAInvcgCategory	Invoicing Cat.
	CAInvcgControlOfInvoicingUnit	I_CAInvcgRequest	CAInvcgControlOfInvoicingUnit	Invoicing Unit Control
	CAInvcgCorrectionCategory	I_CAInvcgRequest	CAInvcgCorrectionCategory	Invcg Correction Category
	CAInvcgBaseDate	I_CAInvcgRequest	CAInvcgBaseDate	Baseline Date
	CAInvcgMasterDataType	I_CAInvcgRequest	CAInvcgMasterDataType	MasterData Type
	CAInvcgReqCreationUser	I_CAInvcgRequest	CAInvcgReqCreationUser	Last Changed By
	CAInvcgReqIsDocumentSimulated	I_CAInvcgRequest	CAInvcgReqIsDocumentSimulated
	CAInvcgReqIsLockedForInvoicing	I_CAInvcgRequest	CAInvcgReqIsLockedForInvoicing	Invoicing Lock
	CAInvcgSourceDocumentType	I_CAInvcgRequest	CAInvcgSourceDocumentType	Source Doc.Type
	CAInvcgTargetProcess	I_CAInvcgRequest	CAInvcgTargetProcess	Target Process
	CAInvcgTechnicalDocumentType	I_CAInvcgRequest	CAInvcgTechnicalDocumentType	Technical Document Type
	CAPartnerSettlementRule	I_CAInvcgRequest	CAPartnerSettlementRule	Settlement Rule
	CABllbleItmNumber		CABllbleItmNumber	Number of Billable Items
	CASubApplication	I_CAInvcgRequest	CASubApplication	Subapplication
	CompanyCode	I_CAInvcgRequest	CompanyCode	Receiver Company Code
	Division	I_CAInvcgRequest	Division	Internal Division ID
	LogicalSystem	I_CAInvcgRequest	LogicalSystem	Logical System
	CAInvcgSourceDocCatText
	CAInvcgCategoryText
	CAInvcgSourceDocTypeText
	CAInvcgTargetProcText
	CAInvcgDocTechDocTypeText
	CASubApplicationText
	CAInvcgMasterDataTypeText
	CABillgDocOriginProcessText
	CAInvcgCorrectionCatText
	CAInvcgControlOfInvcgUnitTxt
	CompanyCodeName
	CAClrfctnCategory
	_BusinessPartner		_BusinessPartner
	_ContractAccountPartner		_ContractAccountPartner
	_ContractAccountHeader		_ContractAccountHeader
	_AltvContractAccountHeader		_AltvContractAccountHeader
	_CAInvcgSourceDocCat		_CAInvcgSourceDocCat
	_CAInvcgCategory		_CAInvcgCategory
	_CAInvcgSourceDocType		_CAInvcgSourceDocType
	_CAInvcgTargetProc		_CAInvcgTargetProc
	_CAInvcgDocTechDocType		_CAInvcgDocTechDocType
	_CASubApplication		_CASubApplication
	_CAInvcgMasterDataType		_CAInvcgMasterDataType
	_CABillgDocOriginProcess		_CABillgDocOriginProcess
	_CAInvcgCorrectionCat		_CAInvcgCorrectionCat
	_CAInvcgControlOfInvcgUnit		_CAInvcgControlOfInvcgUnit
	_CACompanyCode		_CACompanyCode
	_Division		_Division
	_TransactionCurrency		_TransactionCurrency
	_CAApplicationArea		_CAApplicationArea
	_User		_User

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_CAInvcgOvwInvcgRequest.
-- 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_CAInvcgOvwInvcgRequest AS
SELECT
  CAInvcgSourceDocumentCat,
  CAInvcgSourceDocumentNumber,
  _CAInvcgRequest._CAInvcgSourceDocCat.CAInvcgSourceDocumentSemObj AS CAInvcgSourceDocumentSemObj,
  _CAInvcgRequest.BusinessPartner AS BusinessPartner,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CAInvcgRequest.ContractAccount AS ContractAccount,
  _ContractAccountHeader.ContractAccountName AS ContractAccountName,
  _CAInvcgRequest.TransactionCurrency AS TransactionCurrency,
  _CAInvcgRequest.CAInvcgSourceDocumentAmount AS CAInvcgSourceDocumentAmount,
  _CAInvcgRequest.CAInvcgFirstDate AS CAInvcgFirstDate,
  _CAInvcgRequest.CAInvcgReqCreationDate AS CAInvcgReqCreationDate,
  _CAInvcgRequest.AltvContractAcctForCollvBills AS AltvContractAcctForCollvBills,
  _CAInvcgRequest.BusinessPlace AS BusinessPlace,
  _CAInvcgRequest.CAApplicationArea AS CAApplicationArea,
  _CAInvcgRequest.CABillgDocOriginProcess AS CABillgDocOriginProcess,
  _CAInvcgRequest.CAInvcgReqEndDate AS CAInvcgReqEndDate,
  _CAInvcgRequest.CAInvcgReqStartDate AS CAInvcgReqStartDate,
  _CAInvcgRequest.CAContract AS CAContract,
  cast ( '' as vtref_semobj_kk ) AS CAContractSemanticObject,
  _CAInvcgRequest.CAInvcgCategory AS CAInvcgCategory,
  _CAInvcgRequest.CAInvcgControlOfInvoicingUnit AS CAInvcgControlOfInvoicingUnit,
  _CAInvcgRequest.CAInvcgCorrectionCategory AS CAInvcgCorrectionCategory,
  _CAInvcgRequest.CAInvcgBaseDate AS CAInvcgBaseDate,
  _CAInvcgRequest.CAInvcgMasterDataType AS CAInvcgMasterDataType,
  _CAInvcgRequest.CAInvcgReqCreationUser AS CAInvcgReqCreationUser,
  _CAInvcgRequest.CAInvcgReqIsDocumentSimulated AS CAInvcgReqIsDocumentSimulated,
  _CAInvcgRequest.CAInvcgReqIsLockedForInvoicing AS CAInvcgReqIsLockedForInvoicing,
  _CAInvcgRequest.CAInvcgSourceDocumentType AS CAInvcgSourceDocumentType,
  _CAInvcgRequest.CAInvcgTargetProcess AS CAInvcgTargetProcess,
  _CAInvcgRequest.CAInvcgTechnicalDocumentType AS CAInvcgTechnicalDocumentType,
  _CAInvcgRequest.CAPartnerSettlementRule AS CAPartnerSettlementRule,
  CABllbleItmNumber,
  _CAInvcgRequest.CASubApplication AS CASubApplication,
  _CAInvcgRequest.CompanyCode AS CompanyCode,
  _CAInvcgRequest.Division AS Division,
  _CAInvcgRequest.LogicalSystem AS LogicalSystem,
  _CAInvcgSourceDocCat._CAInvcgSourceDocCatText[1: Language=$session.system_language].CAInvcgSourceDocCatText AS CAInvcgSourceDocCatText,
  _CAInvcgCategory._CAInvcgCategoryText[1: Language=$session.system_language].CAInvcgCategoryText AS CAInvcgCategoryText,
  _CAInvcgSourceDocType._CAInvcgSourceDocTypeText[1: Language=$session.system_language].CAInvcgSourceDocTypeText AS CAInvcgSourceDocTypeText,
  _CAInvcgTargetProc._CAInvcgTargetProcText[1: Language=$session.system_language].CAInvcgTargetProcText AS CAInvcgTargetProcText,
  _CAInvcgDocTechDocType._CAInvcgDocTechDocTypeText[1: Language=$session.system_language].CAInvcgDocTechDocTypeText AS CAInvcgDocTechDocTypeText,
  _CASubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText AS CASubApplicationText,
  _CAInvcgMasterDataType._CAInvcgMasterDataTypeText[1: Language=$session.system_language].CAInvcgMasterDataTypeText AS CAInvcgMasterDataTypeText,
  _CABillgDocOriginProcess._CABillgDocOriginProcessText[1: Language=$session.system_language].CABillgDocOriginProcessText AS CABillgDocOriginProcessText,
  _CAInvcgCorrectionCat._CAInvcgCorrectionCatText[1: Language=$session.system_language].CAInvcgCorrectionCatText AS CAInvcgCorrectionCatText,
  _CAInvcgControlOfInvcgUnit._CAInvcgControlOfInvcgUnitTxt[1: Language=$session.system_language].CAInvcgControlOfInvcgUnitTxt AS CAInvcgControlOfInvcgUnitTxt,
  _CAInvcgRequest._CACompanyCode.CompanyCodeName AS CompanyCodeName,
  cast (' ' as inv_cfccat_kk) AS CAClrfctnCategory
FROM I_CAInvcgRequest AS _CAInvcgRequest
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [0..1]
;

Depth:

C_CAInvcgOvwInvcgRequest view_entity

I_CAInvcgRequest view_entity