I_CABillgDocItemTP

DDL: I_CABILLGDOCITEMTP Type: view_entity TRANSACTIONAL Package: FCI_RAP_BILLDOC
91 Fields 1 Data Sources

Billing Document Item - TP

I_CABillgDocItemTP is a Transactional CDS View that provides data about "Billing Document Item - TP" in SAP S/4HANA. It reads from 1 data source (R_CABillgDocItemTP) and exposes 91 fields with key fields CABillgDocument, CABillgDocItem. Part of development package FCI_RAP_BILLDOC.

Data Sources (1)

SourceAliasJoin Type
R_CABillgDocItemTP R_CABillgDocItemTP projection

Annotations (16)

NameValueLevelField
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix BLI view
AbapCatalog.extensibility.quota.maximumFields 340 view
AbapCatalog.extensibility.quota.maximumBytes 6800 view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Billing Document Item - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.representativeKey CABillgDocItem view
ObjectModel.sapObjectNodeType.name ContrAcctgBillingDocumentItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (91)

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
UnitOfMeasure UnitOfMeasure Unit Protected Qty
CABillgDocItemExternalNumber CABillgDocItemExternalNumber External Item
CABillgDocItemIsReversal 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
CADependentItemType CADependentItemType Dependent Item Type
ConditionType ConditionType Condition type
CAAltvMDOriginalIsEnbld CAAltvMDOriginalIsEnbld OriglMasterData
CAInvcgOffsettingReferenceKey CAInvcgOffsettingReferenceKey Offsetting Ref.
CAInvcgOffsettingCategory CAInvcgOffsettingCategory Offsetting Cat.
CAInvcgOffsettingProcedure CAInvcgOffsettingProcedure Offsett. Proc.
CAInvcgOffsettingAction CAInvcgOffsettingAction Action Offsett.
CAInvcgOffsettingGroup CAInvcgOffsettingGroup Offsetting Grp
CAInvcgOffsettingRefKeyLong CAInvcgOffsettingRefKeyLong Offst.Ref(Long)
RAOriginalDocItemType RAOriginalDocItemType OrigItemType
RAOriginalDocItemID RAOriginalDocItemID OriginalItemID
CAAmountPerUnitAmount CAAmountPerUnitAmount Amount per Quantity
CAAmountPerUnitCurrency CAAmountPerUnitCurrency Crcy Amt per Qty
CAAmountPerUnitQuantityUnit CAAmountPerUnitQuantityUnit UoM Amount
CAAmountPerUnitQuantity CAAmountPerUnitQuantity Qty Amt per Qty
CAIntcoCompanyCodeRequesting CAIntcoCompanyCodeRequesting ReqCCode
CAIntcoCompanyCodeSupplying CAIntcoCompanyCodeSupplying Supplying CCode
CAIntcoType CAIntcoType IntSettlmntType
CAIntcoProcedure CAIntcoProcedure IntSettlmntProc
CABillToParty CABillToParty Bill-To Party
CABillToRegion CABillToRegion Bill-To Region
CABillFromRegion CABillFromRegion Region Dlv.Plnt
CAControlCode CAControlCode Control Code
CASupplyRegion CASupplyRegion Supply Regi
CABillToCountry CABillToCountry Bill-To Country

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 I_CABillgDocItemTP.
-- 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 I_CABillgDocItemTP AS
SELECT
  CABillgDocument,
  CABillgDocItem,
  CAIsDocItemSimulated,
  CABillgDocumentItemType,
  CAContract,
  CompanyCode,
  CAMainTransaction,
  CASubTransaction,
  CAInvcgIsItemPostingRelevant,
  CAInvcgIsItemPrintingRelevant,
  CABillgDocItemAmount,
  CABillgCurrency,
  CATaxIsIncluded,
  TaxCode,
  UnitOfMeasure,
  CABillgDocItemExternalNumber,
  CABillgDocItemIsReversal,
  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,
  CADependentItemType,
  ConditionType,
  CAAltvMDOriginalIsEnbld,
  CAInvcgOffsettingReferenceKey,
  CAInvcgOffsettingCategory,
  CAInvcgOffsettingProcedure,
  CAInvcgOffsettingAction,
  CAInvcgOffsettingGroup,
  CAInvcgOffsettingRefKeyLong,
  RAOriginalDocItemType,
  RAOriginalDocItemID,
  CAAmountPerUnitAmount,
  CAAmountPerUnitCurrency,
  CAAmountPerUnitQuantityUnit,
  CAAmountPerUnitQuantity,
  CAIntcoCompanyCodeRequesting,
  CAIntcoCompanyCodeSupplying,
  CAIntcoType,
  CAIntcoProcedure,
  CABillToParty,
  CABillToRegion,
  CABillFromRegion,
  CAControlCode,
  CASupplyRegion,
  CABillToCountry
FROM R_CABillgDocItemTP
;

Learn More