C_CABillgDocVH

DDL: C_CABILLGDOCVH Type: view_entity CONSUMPTION
17 Fields 1 Data Sources

Wertehilfe Abrechnungsbeleg

C_CABillgDocVH is a Consumption CDS View that provides data about "Wertehilfe Abrechnungsbeleg" in SAP S/4HANA. It reads from 1 data source (I_CABillgDocHeader) and exposes 17 fields with key field CABillgDocument.

Data Sources (1)

SourceAliasJoin Type
I_CABillgDocHeader _CABillgDocHeader from

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Wertehilfe Abrechnungsbeleg view
Search.searchable true view
Consumption.ranked true view
ObjectModel.representativeKey CABillgDocument view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CABillgDocument CABillgDocument Billing Doc.
BusinessPartnerFullName Geschäftspartnername
BusinessPartner I_CABillgDocHeader BusinessPartner Issuing Authority
ContractAccount ContractAccount Contract Acct
CABillgType CABillgType Billing Type
CAInvcgDocumentType CAInvcgDocumentType Document Type
CreatedByUser CreatedByUser User Name
CABillgDocCreationDate CABillgDocCreationDate Billed On
CABillgDocCreationTime CABillgDocCreationTime Billed At
CABillgDocOriginProcess CABillgDocOriginProcess Origin
CABillgIsDocumentSimulated CABillgIsDocumentSimulated Simulation Doc.
CABillgReversedDocument CABillgReversedDocument Rev. Doc. For
CABillgReversalDocument CABillgReversalDocument Reversal Document Number
_ContractAccountPartner _ContractAccountPartner
_BusinessPartner _BusinessPartner
_ContractAccountHeader _ContractAccountHeader
_CABillgType _CABillgType

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_CABillgDocVH.
-- 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_CABillgDocVH AS
SELECT
  CABillgDocument,
  _CABillgDocHeader._BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _CABillgDocHeader.BusinessPartner AS BusinessPartner,
  ContractAccount,
  CABillgType,
  CAInvcgDocumentType,
  CreatedByUser,
  CABillgDocCreationDate,
  CABillgDocCreationTime,
  CABillgDocOriginProcess,
  CABillgIsDocumentSimulated,
  CABillgReversedDocument,
  CABillgReversalDocument
FROM I_CABillgDocHeader AS _CABillgDocHeader
;

Learn More