A_CABillgDocItem

DDL: A_CABILLGDOCITEM Type: view_entity CONSUMPTION
71 Fields 1 Data Sources

Billing Document Item

A_CABillgDocItem is a Consumption CDS View that provides data about "Billing Document Item" in SAP S/4HANA. It reads from 1 data source (R_CABillgDocItemTP) and exposes 71 fields with key fields CABillgDocument, CABillgDocItem.

Data Sources (1)

SourceAliasJoin Type
R_CABillgDocItemTP R_CABillgDocItemTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Billing Document Item 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 CABillgDocItem_Type view

Fields (71)

KeyFieldSource TableSource FieldDescription
KEY CABillgDocument CABillgDocument Billing Doc.
KEY CABillgDocItem CABillgDocItem Item
CAIsDocItemSimulated CAIsDocItemSimulated Item Simulated
CABillgDocumentItemType CABillgDocumentItemType Item Type
CAContract CAContract Contract
CompanyCode CompanyCode Receiver Company Code
CAMainTransaction CAMainTransaction Main Trans.
CASubTransaction CASubTransaction Subtransaction
CAInvcgIsItemPostingRelevant CAInvcgIsItemPostingRelevant Posting-Relevt
CAInvcgIsItemPrintingRelevant CAInvcgIsItemPrintingRelevant Print Relevant
CABillgDocItemAmount CABillgDocItemAmount Amount
CABillgCurrency CABillgCurrency Currency
CATaxIsIncluded CATaxIsIncluded Gross
TaxCode TaxCode Tax Code
CABillgDocItemExternalNumber CABillgDocItemExternalNumber External Item
CABillgDocItemIsReversal CABillgDocItemIsReversal Reversal Item
CAInvcgDocItemIsReversal CABillgDocItemIsReversal Reversal Item
CAInvcgCorrectionCategory CAInvcgCorrectionCategory Invcg Correction Category
CAInvcgIsNotBPRelevant CAInvcgIsNotBPRelevant No BP Item
CAInvcgSubstituteGroupPrinting CAInvcgSubstituteGroupPrinting Substitute Group
CAItemPeriodStartDate CAItemPeriodStartDate Start Item Per.
CAItemPeriodEndDate CAItemPeriodEndDate End of Item Per
CANetDueDate CANetDueDate Net Due Date
Division Division Internal Division ID
BusinessArea BusinessArea Business Area
BusinessPlace BusinessPlace Business place
Segment Segment Segment number
ProfitCenter ProfitCenter Profit Center
CAAccountDeterminationCode CAAccountDeterminationCode Acct Determ. ID
CATaxDetnType CATaxDetnType Tax Calculation
CATaxCountry CATaxCountry Country/Region
CATaxDateType CATaxDateType Tax Date
CABillgTaxGroup CABillgTaxGroup Tax Grouping
CAExternalTaxDate CAExternalTaxDate Ext. Tax Date
CATaxDeterminationCode CATaxDeterminationCode Tax Determination
CAAltvTaxDeterminationCode CAAltvTaxDeterminationCode Altv Tax Detn Code
CAAltvTaxCode CAAltvTaxCode Altern.Tax Code
CAOtherTaxCode CAOtherTaxCode TxCde:Oth.Taxes
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
WithholdingTaxCode WithholdingTaxCode WTax Code
CAIsDownPaymentRequest CAIsDownPaymentRequest Down Payment
CABillgDeferredRevenueCategory CABillgDeferredRevenueCategory Deferred Revenue Category
CABillgDeferredRevenueDate CABillgDeferredRevenueDate Transfer date
CAInvcgDfrrdRevenueStatus CAInvcgDfrrdRevenueStatus Deferred Revenues Status
CAIsRevenueAccountingRelevant CAIsRevenueAccountingRelevant Rev. Acctg Relevant
CARevenueAccountingServiceType CARevenueAccountingServiceType Service Type
CAInvcgAccrualPostingType CAInvcgAccrualPostingType Accr/Defrl Postg Type
CABillgDocItemIsBIRelevant CABillgDocItemIsBIRelevant BI-Relevant
CABillgDocItemIsFICORelevant CABillgDocItemIsFICORelevant FI/CO-Relevant
CAProviderContractItemNumber CAProviderContractItemNumber Contract Item
CASubApplication CASubApplication Subapplication
CAIsPrepaid CAIsPrepaid Prepaid
CABillgIsPrepaidBalanceChg CABillgIsPrepaidBalanceChg Prepaid Refill
CABillgPartnerSettlementCat CABillgPartnerSettlementCat Partner Settlement Category
CABillgDocItemCrtnMethod CABillgDocItemCrtnMethod Creation Method
CABillgFunction CABillgFunction Billing Funct.
CABillgGrpgOfAdditionalItems CABillgGrpgOfAdditionalItems Additional Item Grouping
CABillgGrpgOfPaymentData CABillgGrpgOfPaymentData Pmt Data Group
CABillgGroupingSourceItems CABillgGroupingSourceItems Source Item Grp
CABllbleItmNumber CABllbleItmNumber Number of Billable Items
CADiscBaseItmGroup CADiscBaseItmGroup Base Item Group
CAReasonSecurityDeposit CAReasonSecurityDeposit Request Reason
CABillgReqReason CABillgReqReason Billing Request Reason
CABllbleItmDiscountKey CABllbleItmDiscountKey Disc./Chg. Key
CABllbleItmDiscountVersion CABllbleItmDiscountVersion Version No.
CABillingQuantity CABillingQuantity Billing Quantity
UnitOfMeasure UnitOfMeasure Unit Protected Qty
UnitOfMeasureISOCode _UnitOfMeasure UnitOfMeasureISOCode
CADependentItemType CADependentItemType Dependent Item Type
ConditionType ConditionType Condition type
CAAltvMDOriginalIsEnbld CAAltvMDOriginalIsEnbld OriglMasterData

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_CABillgDocItem.
-- 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_CABillgDocItem AS
SELECT
  CABillgDocument,
  CABillgDocItem,
  CAIsDocItemSimulated,
  CABillgDocumentItemType,
  CAContract,
  CompanyCode,
  CAMainTransaction,
  CASubTransaction,
  CAInvcgIsItemPostingRelevant,
  CAInvcgIsItemPrintingRelevant,
  CABillgDocItemAmount,
  CABillgCurrency,
  CATaxIsIncluded,
  TaxCode,
  CABillgDocItemExternalNumber,
  CABillgDocItemIsReversal,
  CABillgDocItemIsReversal AS CAInvcgDocItemIsReversal,
  CAInvcgCorrectionCategory,
  CAInvcgIsNotBPRelevant,
  CAInvcgSubstituteGroupPrinting,
  CAItemPeriodStartDate,
  CAItemPeriodEndDate,
  CANetDueDate,
  Division,
  BusinessArea,
  BusinessPlace,
  Segment,
  ProfitCenter,
  CAAccountDeterminationCode,
  CATaxDetnType,
  CATaxCountry,
  CATaxDateType,
  CABillgTaxGroup,
  CAExternalTaxDate,
  CATaxDeterminationCode,
  CAAltvTaxDeterminationCode,
  CAAltvTaxCode,
  CAOtherTaxCode,
  TaxJurisdiction,
  WithholdingTaxCode,
  CAIsDownPaymentRequest,
  CABillgDeferredRevenueCategory,
  CABillgDeferredRevenueDate,
  CAInvcgDfrrdRevenueStatus,
  CAIsRevenueAccountingRelevant,
  CARevenueAccountingServiceType,
  CAInvcgAccrualPostingType,
  CABillgDocItemIsBIRelevant,
  CABillgDocItemIsFICORelevant,
  CAProviderContractItemNumber,
  CASubApplication,
  CAIsPrepaid,
  CABillgIsPrepaidBalanceChg,
  CABillgPartnerSettlementCat,
  CABillgDocItemCrtnMethod,
  CABillgFunction,
  CABillgGrpgOfAdditionalItems,
  CABillgGrpgOfPaymentData,
  CABillgGroupingSourceItems,
  CABllbleItmNumber,
  CADiscBaseItmGroup,
  CAReasonSecurityDeposit,
  CABillgReqReason,
  CABllbleItmDiscountKey,
  CABllbleItmDiscountVersion,
  CABillingQuantity,
  UnitOfMeasure,
  _UnitOfMeasure.UnitOfMeasureISOCode AS UnitOfMeasureISOCode,
  CADependentItemType,
  ConditionType,
  CAAltvMDOriginalIsEnbld
FROM R_CABillgDocItemTP
;

Learn More