A_CABillgDocument

DDL: A_CABILLGDOCUMENT Type: view_entity CONSUMPTION Package: FCI_ODATA_API_BILLDOC
53 Fields 1 Data Sources 1 Associations 1 OData Services

Billing Document

A_CABillgDocument is a Consumption CDS View that provides data about "Billing Document" in SAP S/4HANA. It reads from 1 data source (R_CABillgDocumentTP) and exposes 53 fields with key field CABillgDocument. It has 1 association to related views. It is exposed through 1 OData service (API_CABILLINGDOCUMENT). Part of development package FCI_ODATA_API_BILLDOC.

Data Sources (1)

SourceAliasJoin Type
R_CABillgDocumentTP R_CABillgDocumentTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_CABillgDocSource _CABillgDocSource $projection.CABillgDocument = _CABillgDocSource.CABillgDocument

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Billing Document view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name CABillgDocument_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_CABILLINGDOCUMENT API_CABILLINGDOCUMENT V4 C2 C1

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY CABillgDocument CABillgDocument Billing Doc.
BusinessPartner BusinessPartner Issuing Authority
ContractAccount ContractAccount Contract Acct
CABillgType CABillgType Billing Type
CABillgDocPeriodStartDate CABillgDocPeriodStartDate Start of Document Period
CABillgDocPeriodEndDate CABillgDocPeriodEndDate End of Document Period
CABillgDocumentReversalReason CABillgDocumentReversalReason Reversal Reason
CABillgIsDocumentSimulated CABillgIsDocumentSimulated Simulation Doc.
CABillgDocumentExternal CABillgDocumentExternal External Document Number
LogicalSystem LogicalSystem Logical System
CAApplicationArea CAApplicationArea ApplicationArea
CABillgDocOriginProcess CABillgDocOriginProcess Origin
CAInvcgSourceDocumentType CAInvcgSourceDocumentType Source Doc.Type
CAInvcgTechnicalDocumentType CAInvcgTechnicalDocumentType Technical Document Type
CAInvcgDocumentType CAInvcgDocumentType Document Type
CAInvcgTargetProcess CAInvcgTargetProcess Target Process
CAInvcgMasterDataType CAInvcgMasterDataType MasterData Type
CAInvcgAltvBusinessPartner CAInvcgAltvBusinessPartner Altv Business Partner
CAInvcgAltvContractAccount CAInvcgAltvContractAccount Altv Contract Account
CABillgBaseDate CABillgBaseDate Baseline Date
CABillgCurrency CABillgCurrency Currency
CAInvcgCurrency CAInvcgCurrency Invoicing Target Currency
CATaxDetnType CATaxDetnType Tax Calculation
CATaxDateType CATaxDateType Tax Date
CAInvcgCategory CAInvcgCategory Invoicing Cat.
CAInvcgControlOfInvoicingUnit CAInvcgControlOfInvoicingUnit Invoicing Unit Control
CAInvcgFirstDate CAInvcgFirstDate Invoice From
CABillgReversalDocument CABillgReversalDocument Reversal Document Number
CABillgReversedDocument CABillgReversedDocument Rev. Doc. For
CABillgAdjustmentDocument CABillgAdjustmentDocument Adjustment Billg Documnt
CABillgAdjustedDocument CABillgAdjustedDocument Adjusted Document
CAInvcgCorrectionCategory CAInvcgCorrectionCategory Invcg Correction Category
CaInvcgIsOrderDeleted CaInvcgIsOrderDeleted Invoicing Order Deleted
CABillgHasAdditionalInvoice CABillgHasAdditionalInvoice Info in Invoice
CAInvcgIsAccrualPostingRlvt CAInvcgIsAccrualPostingRlvt Accrual/Deferral Posting
CABillgLockedForInvoicing CABillgLockedForInvoicing Invoicing Lock
CABillgGrpgOfAdditionalItems CABillgGrpgOfAdditionalItems Additional Item Grouping
CABillgDocHasRefObjects CABillgDocHasRefObjects Object References Exist
CABillgDocumentNumberOfItems CABillgDocumentNumberOfItems Number of Items
CABllbleItmNumber CABllbleItmNumber Number of Billable Items
CreatedByUser CreatedByUser User Name
CABillgDocCreationDate CABillgDocCreationDate Billed On
CABillgDocCreationTime CABillgDocCreationTime Billed At
CABillgDocInternalNumber CABillgDocInternalNumber Billing Run Number
CABillgProcess CABillgProcess Billing Process
CABillgDocHasPrepaidItems CABillgDocHasPrepaidItems Prepaid
CABillgDocHasRefillItems CABillgDocHasRefillItems Prepaid Refill
CABillgDocHasRevnRecgnItems CABillgDocHasRevnRecgnItems Rev Deferral
CAPartnerSettlementRule CAPartnerSettlementRule Settlement Rule
CABillgDocumentInvcgStatus CABillgDocumentInvcgStatus Invoicg Status
CAInvoicingDocument CAInvoicingDocument Invoic. Doc.
_ContractAccountPartner _ContractAccountPartner
_CABillgDocSource _CABillgDocSource

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 A_CABillgDocument.
-- 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 A_CABillgDocument AS
SELECT
  CABillgDocument,
  BusinessPartner,
  ContractAccount,
  CABillgType,
  CABillgDocPeriodStartDate,
  CABillgDocPeriodEndDate,
  CABillgDocumentReversalReason,
  CABillgIsDocumentSimulated,
  CABillgDocumentExternal,
  LogicalSystem,
  CAApplicationArea,
  CABillgDocOriginProcess,
  CAInvcgSourceDocumentType,
  CAInvcgTechnicalDocumentType,
  CAInvcgDocumentType,
  CAInvcgTargetProcess,
  CAInvcgMasterDataType,
  CAInvcgAltvBusinessPartner,
  CAInvcgAltvContractAccount,
  CABillgBaseDate,
  CABillgCurrency,
  CAInvcgCurrency,
  CATaxDetnType,
  CATaxDateType,
  CAInvcgCategory,
  CAInvcgControlOfInvoicingUnit,
  CAInvcgFirstDate,
  CABillgReversalDocument,
  CABillgReversedDocument,
  CABillgAdjustmentDocument,
  CABillgAdjustedDocument,
  CAInvcgCorrectionCategory,
  CaInvcgIsOrderDeleted,
  CABillgHasAdditionalInvoice,
  CAInvcgIsAccrualPostingRlvt,
  CABillgLockedForInvoicing,
  CABillgGrpgOfAdditionalItems,
  CABillgDocHasRefObjects,
  CABillgDocumentNumberOfItems,
  CABllbleItmNumber,
  CreatedByUser,
  CABillgDocCreationDate,
  CABillgDocCreationTime,
  CABillgDocInternalNumber,
  CABillgProcess,
  CABillgDocHasPrepaidItems,
  CABillgDocHasRefillItems,
  CABillgDocHasRevnRecgnItems,
  CAPartnerSettlementRule,
  CABillgDocumentInvcgStatus,
  CAInvoicingDocument
FROM R_CABillgDocumentTP
LEFT OUTER JOIN A_CABillgDocSource AS _CABillgDocSource ON CABillgDocument = _CABillgDocSource.CABillgDocument  -- association [0..*]
;

Learn More