What is C_CABillgPlnItem in SAP S/4HANA?

C_CABillgPlnItem is a consumption CDS view in SAP S/4HANA. Abrechnungsplanpositionen It contains 142 fields.

Which tables does C_CABillgPlnItem read from?

C_CABillgPlnItem reads data from: I_CABillgPlnItemTP.

What VDM layer is C_CABillgPlnItem?

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

C_CABillgPlnItem

DDL: C_CABILLGPLNITEM Type: view_entity CONSUMPTION Package: ODATA_O2C_CI_BILLPLAN

142 Fields 1 Data Sources 1 Associations

Abrechnungsplanpositionen

C_CABillgPlnItem is a Consumption CDS View that provides data about "Abrechnungsplanpositionen" in SAP S/4HANA. It reads from 1 data source (I_CABillgPlnItemTP) and exposes 142 fields with key fields CABillgPlnNumber, CABillgPlnItem. It has 1 association to related views. Part of development package ODATA_O2C_CI_BILLPLAN.

Data Sources (1)

Source	Alias	Join Type
I_CABillgPlnItemTP	_CABillgPlnItemTP	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	C_CABillgPln	_CABillgPln	`$projection.CABillgPlnNumber = _CABillgPln.CABillgPlnNumber`

Annotations (15)

Name	Value	Level
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	C_CABillgPln_2	view
EndUserText.label	Abrechnungsplanpositionen	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.representativeKey	CABillgPlnItem	view
UI.headerInfo.typeName	Abrechnungsplanposition	view
UI.headerInfo.typeNamePlural	Abrechnungsplanpositionen	view
UI.headerInfo.title.label	Abrechnungsplanposition	view
UI.headerInfo.title.value	CABillgPlnItem	view
UI.headerInfo.description.value	CABillgPlnItmTxt	view

Fields (142)

Key	Field	Source Table	Source Field	Description
KEY	CABillgPlnNumber	I_CABillgPlnItemTP	CABillgPlnNumber	Billing Plan
KEY	CABillgPlnItem	I_CABillgPlnItemTP	CABillgPlnItem	Item
	CABillgPlnItemStatus	I_CABillgPlnItemTP	CABillgPlnItemStatus	Status
	CABillgPlnItmCat	I_CABillgPlnItemTP	CABillgPlnItmCat	Billing Pln Itm Cat.
	CABillgPlnType	_CABillgPln	CABillgPlnType	Billing Plan Type
	CABillgPlnTypeText	_CABillgPln	CABillgPlnTypeText
	CABillgPlnItmType	I_CABillgPlnItemTP	CABillgPlnItmType	Billing Plan Itm Typ
	CABillgPlnItmTxt	I_CABillgPlnItemTP	CABillgPlnItmTxt	Name
	CABillgPlnItemExtRef	I_CABillgPlnItemTP	CABillgPlnItemExtRef	Ext. Reference
	CABillgPlnItemStartDate	I_CABillgPlnItemTP	CABillgPlnItemStartDate	Valid From
	CABillgPlnItmEndDate	I_CABillgPlnItemTP	CABillgPlnItmEndDate	Valid to
	CABillgPlnItemTermStartDate	I_CABillgPlnItemTP	CABillgPlnItemTermStartDate	Term From
	CABillgPlnItemTermEndDate	I_CABillgPlnItemTP	CABillgPlnItemTermEndDate	Term To
	CABillgPlnItemRecurring	I_CABillgPlnItemTP	CABillgPlnItemRecurring	RecurringBillgPlnItm
	CABillgCycle	I_CABillgPlnItemTP	CABillgCycle	Billing Cycle
	CABillgPlnItemAmount	I_CABillgPlnItemTP	CABillgPlnItemAmount	Amount
	TransactionCurrency	I_CABillgPlnItemTP	TransactionCurrency	Transaction Currency
	CATaxIsIncluded	I_CABillgPlnItemTP	CATaxIsIncluded	Gross
	CABillgPlnItemQuantity	I_CABillgPlnItemTP	CABillgPlnItemQuantity	Billing Quantity
	CABillgPlnItemQuantityUnit
	CATaxDeterminationCode	I_CABillgPlnItemTP	CATaxDeterminationCode	Tax Determination
	TaxCode
	TaxCalculationProcedure	I_CABillgPlnItemTP	TaxCalculationProcedure	Tax Procedure
	CABillgPlnItemReqDteLast
	CABillgPlnItemReqDteNext	I_CABillgPlnItemTP	CABillgPlnItemReqDteNext	Next Request
	CABillgPlnDvtgNextRequestDate	I_CABillgPlnItemTP	CABillgPlnDvtgNextRequestDate	Diff. ReqDate
	CABillgPlnItemRequestedToDte	I_CABillgPlnItemTP	CABillgPlnItemRequestedToDte	Requested Until
	CABillgPlnItmExcptnReason	I_CABillgPlnItemTP	CABillgPlnItmExcptnReason	Adjust. Reason
	CAConditionType	I_CABillgPlnItemTP	CAConditionType	Condition Type
	CABillgPlnItemAmountDetnType	I_CABillgPlnItemTP	CABillgPlnItemAmountDetnType	Type of Amount Detn
	CABillgPlnItemAmountDateType	I_CABillgPlnItemTP	CABillgPlnItemAmountDateType	Type of Amount Detn Date
	CABillgPlnItemPriceDateType	I_CABillgPlnItemTP	CABillgPlnItemPriceDateType	Type Pricing Date
	CAContract
	CAContractSemanticObject
	CASubApplication	I_CABillgPlnItemTP	CASubApplication	Subapplication
	CAProviderContractItemNumber	I_CABillgPlnItemTP	CAProviderContractItemNumber	Contract Item
	CAProviderContractItemUUID	I_CABillgPlnItemTP	CAProviderContractItemUUID	Contr.Item ID
	CABillgPlnSubItmExist	I_CABillgPlnItemTP	CABillgPlnSubItmExist	Subitm Exists
	Division	I_CABillgPlnItemTP	Division	Internal Division ID
	CompanyCode	I_CABillgPlnItemTP	CompanyCode	Receiver Company Code
	BusinessArea	I_CABillgPlnItemTP	BusinessArea	Business Area
	Segment	I_CABillgPlnItemTP	Segment	Segment number
	CAApplicationArea	I_CABillgPlnItemTP	CAApplicationArea	ApplicationArea
	CAMainTransaction	I_CABillgPlnItemTP	CAMainTransaction	Main Trans.
	CASubTransaction	I_CABillgPlnItemTP	CASubTransaction	Subtransaction
	Material	I_CABillgPlnItemTP	Material	Vehicle Model
	SalesOrganization	I_CABillgPlnItemTP	SalesOrganization	Sales Organization
	DistributionChannel	I_CABillgPlnItemTP	DistributionChannel	RefDistCh-Cust/Mat.
	CABillgPlnItemServiceType	I_CABillgPlnItemTP	CABillgPlnItemServiceType	Service Type
	CADependentItemType	I_CABillgPlnItemTP	CADependentItemType	Dependent Item Type
	CAAccountDeterminationCode	I_CABillgPlnItemTP	CAAccountDeterminationCode	Acct Determ. ID
	CABillgPlnItemCanceled	I_CABillgPlnItemTP	CABillgPlnItemCanceled	Item Discarded
	CABillgPlnItemMain	I_CABillgPlnItemTP	CABillgPlnItemMain	Main Item
	CABillgPlnItemChildExist	I_CABillgPlnItemTP	CABillgPlnItemChildExist	Follow-On Itm Exists
	CABillgPlnItemParent	I_CABillgPlnItemTP	CABillgPlnItemParent	HigherLevelItem
	CABillgPlnItemNrOfBllbleItm	I_CABillgPlnItemTP	CABillgPlnItemNrOfBllbleItm	No. of Requests
	CAInvcgOffsettingAction	I_CABillgPlnItemTP	CAInvcgOffsettingAction	Action Offsett.
	CAInvcgOffsettingCategory	I_CABillgPlnItemTP	CAInvcgOffsettingCategory	Offsetting Cat.
	CAInvcgOffsettingProcedure	I_CABillgPlnItemTP	CAInvcgOffsettingProcedure	Offsett. Proc.
	CAInvcgOffsettingReferenceKey	I_CABillgPlnItemTP	CAInvcgOffsettingReferenceKey	Offsetting Ref.
	CAIsRevnAcctgTransfRecordRlvt	I_CABillgPlnItemTP	CAIsRevnAcctgTransfRecordRlvt	OrderItm Exists
	ConditionType	I_CABillgPlnItemTP	ConditionType	Condition type
	ConditionIsForStatistics	I_CABillgPlnItemTP	ConditionIsForStatistics	Statistical
	CANetDueDate	I_CABillgPlnItemTP	CANetDueDate	Net Due Date
	CABillgPlnItmIsNotToBeReqd		CABillgPlnItmIsNotToBeReqd	Checkbox
	CABllbleItmCostType		CABllbleItmCostType	Billable Item Cost Type
	CABllbleItmCostSubType		CABllbleItmCostSubType	Billable Item Cost Subtype
	CAIntcoCompanyCodeRequesting	I_CABillgPlnItemTP	CAIntcoCompanyCodeRequesting	ReqCCode
	CAIntcoCompanyCodeSupplying	I_CABillgPlnItemTP	CAIntcoCompanyCodeSupplying	Supplying CCode
	CAIntcoType	I_CABillgPlnItemTP	CAIntcoType	IntSettlmntType
	CAIntcoSubtype	I_CABillgPlnItemTP	CAIntcoSubtype	Intco Settlmt Subtype
	CABillgPlnItmStatusText
	CABillgPlnItmExcptnRsnText
	CABillgCycleText
	CABillgPlnItmTypeText
	CABillgPlnItmCatText
	CurrencyName
	UnitOfMeasureName
	CAConditionTypeName
	CABillgPlnItmAmtDetnTypeText
	CABillgPlnItmAmtDateTypeText
	CABillgPlnItmPrcDateTypeText
	CAMainTransactionName
	CASubTransactionName
	CARevnAcctgServiceTypeText
	CADependentItemTypeText
	CASubApplicationText
	DivisionName
	CompanyCodeName	_CompanyCode	CompanyCodeName	Company Name
	BusinessAreaName
	MaterialName
	SalesOrganizationName
	DistributionChannelName
	CAInvcgOffsettingActionText
	CAInvcgOffsettingCategoryTxt
	CAInvcgOffsettingProcedText
	CABllbleItmCostTypeText
	CABllbleItmCostSubtypeText
	CAIntcoCoCodeRequestingName	_CAIntcoCompanyCodeRequesting	CompanyCodeName	Company Name
	CAIntcoCoCodeSupplyingName	_CAIntcoCompanyCodeSupplying	CompanyCodeName	Company Name
	CAIntcoTypeText
	CAIntcoSubtypeText
	ConditionTypeName
	CABillgPlnCategory	_CABillgPln	CABillgPlnCategory	Billing Plan Category
	_CABillgPln		_CABillgPln
	_CABillgPlnType	_CABillgPln	_CABillgPlnType
	_CABillgCycle		_CABillgCycle
	_CABillgPlnItmType		_CABillgPlnItmType
	_CABillgPlnItmCat		_CABillgPlnItmCat
	_CABillgPlnItmStatus		_CABillgPlnItmStatus
	_ExcptnRsn		_ExcptnRsn
	_TransactionCurrency		_TransactionCurrency
	_TaxCode		_TaxCode
	_MainTransaction		_MainTransaction
	_SubTransaction		_SubTransaction
	_CARevnAcctgServiceType		_CARevnAcctgServiceType
	_CADependentItemType		_CADependentItemType
	_Material		_Material
	_SalesOrganization		_SalesOrganization
	_DistributionChannel		_DistributionChannel
	_CAConditionType		_CAConditionType
	_CABillgPlnItmAmtDetnType		_CABillgPlnItmAmtDetnType
	_CABillgPlnItmAmtDateType		_CABillgPlnItmAmtDateType
	_CABillgPlnItmPrcDateType		_CABillgPlnItmPrcDateType
	_UnitOfMeasure		_UnitOfMeasure
	_SubApplication		_SubApplication
	_ProviderContract		_ProviderContract
	_CAProviderContractItem		_CAProviderContractItem
	_ConditionType		_CondType
	_CompanyCode		_CompanyCode
	_BusinessArea		_BusinessArea
	_Segment		_Segment
	_Division		_Division
	_CAInvcgOffsettingAction		_CAInvcgOffsettingAction
	_CAInvcgOffsettingCategory		_CAInvcgOffsettingCategory
	_CAInvcgOffsettingProcedure		_CAInvcgOffsettingProcedure
	_CABllbleItmCostType		_CABllbleItmCostType
	_CABllbleItmCostSubtype		_CABllbleItmCostSubtype
	_CAIntcoCompanyCodeRequesting		_CAIntcoCompanyCodeRequesting
	_CAIntcoCompanyCodeSupplying		_CAIntcoCompanyCodeSupplying
	_CAIntcoType		_CAIntcoType
	_CAIntcoSubtype		_CAIntcoSubtype

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_CABillgPlnItem.
-- 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_CABillgPlnItem AS
SELECT
  _CABillgPlnItemTP.CABillgPlnNumber AS CABillgPlnNumber,
  _CABillgPlnItemTP.CABillgPlnItem AS CABillgPlnItem,
  _CABillgPlnItemTP.CABillgPlnItemStatus AS CABillgPlnItemStatus,
  _CABillgPlnItemTP.CABillgPlnItmCat AS CABillgPlnItmCat,
  _CABillgPln.CABillgPlnType AS CABillgPlnType,
  _CABillgPln.CABillgPlnTypeText AS CABillgPlnTypeText,
  _CABillgPlnItemTP.CABillgPlnItmType AS CABillgPlnItmType,
  _CABillgPlnItemTP.CABillgPlnItmTxt AS CABillgPlnItmTxt,
  _CABillgPlnItemTP.CABillgPlnItemExtRef AS CABillgPlnItemExtRef,
  _CABillgPlnItemTP.CABillgPlnItemStartDate AS CABillgPlnItemStartDate,
  _CABillgPlnItemTP.CABillgPlnItmEndDate AS CABillgPlnItmEndDate,
  _CABillgPlnItemTP.CABillgPlnItemTermStartDate AS CABillgPlnItemTermStartDate,
  _CABillgPlnItemTP.CABillgPlnItemTermEndDate AS CABillgPlnItemTermEndDate,
  _CABillgPlnItemTP.CABillgPlnItemRecurring AS CABillgPlnItemRecurring,
  _CABillgPlnItemTP.CABillgCycle AS CABillgCycle,
  _CABillgPlnItemTP.CABillgPlnItemAmount AS CABillgPlnItemAmount,
  _CABillgPlnItemTP.TransactionCurrency AS TransactionCurrency,
  _CABillgPlnItemTP.CATaxIsIncluded AS CATaxIsIncluded,
  _CABillgPlnItemTP.CABillgPlnItemQuantity AS CABillgPlnItemQuantity,
  _CABillgPlnItemTP.CATaxDeterminationCode AS CATaxDeterminationCode,
  _CABillgPlnItemTP.TaxCalculationProcedure AS TaxCalculationProcedure,
  _CABillgPlnItemTP.CABillgPlnItemReqDteNext AS CABillgPlnItemReqDteNext,
  _CABillgPlnItemTP.CABillgPlnDvtgNextRequestDate AS CABillgPlnDvtgNextRequestDate,
  _CABillgPlnItemTP.CABillgPlnItemRequestedToDte AS CABillgPlnItemRequestedToDte,
  _CABillgPlnItemTP.CABillgPlnItmExcptnReason AS CABillgPlnItmExcptnReason,
  _CABillgPlnItemTP.CAConditionType AS CAConditionType,
  _CABillgPlnItemTP.CABillgPlnItemAmountDetnType AS CABillgPlnItemAmountDetnType,
  _CABillgPlnItemTP.CABillgPlnItemAmountDateType AS CABillgPlnItemAmountDateType,
  _CABillgPlnItemTP.CABillgPlnItemPriceDateType AS CABillgPlnItemPriceDateType,
  cast ( '' as vtref_semobj_kk ) AS CAContractSemanticObject,
  _CABillgPlnItemTP.CASubApplication AS CASubApplication,
  _CABillgPlnItemTP.CAProviderContractItemNumber AS CAProviderContractItemNumber,
  _CABillgPlnItemTP.CAProviderContractItemUUID AS CAProviderContractItemUUID,
  _CABillgPlnItemTP.CABillgPlnSubItmExist AS CABillgPlnSubItmExist,
  _CABillgPlnItemTP.Division AS Division,
  _CABillgPlnItemTP.CompanyCode AS CompanyCode,
  _CABillgPlnItemTP.BusinessArea AS BusinessArea,
  _CABillgPlnItemTP.Segment AS Segment,
  _CABillgPlnItemTP.CAApplicationArea AS CAApplicationArea,
  _CABillgPlnItemTP.CAMainTransaction AS CAMainTransaction,
  _CABillgPlnItemTP.CASubTransaction AS CASubTransaction,
  _CABillgPlnItemTP.Material AS Material,
  _CABillgPlnItemTP.SalesOrganization AS SalesOrganization,
  _CABillgPlnItemTP.DistributionChannel AS DistributionChannel,
  _CABillgPlnItemTP.CABillgPlnItemServiceType AS CABillgPlnItemServiceType,
  _CABillgPlnItemTP.CADependentItemType AS CADependentItemType,
  _CABillgPlnItemTP.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  _CABillgPlnItemTP.CABillgPlnItemCanceled AS CABillgPlnItemCanceled,
  _CABillgPlnItemTP.CABillgPlnItemMain AS CABillgPlnItemMain,
  _CABillgPlnItemTP.CABillgPlnItemChildExist AS CABillgPlnItemChildExist,
  _CABillgPlnItemTP.CABillgPlnItemParent AS CABillgPlnItemParent,
  _CABillgPlnItemTP.CABillgPlnItemNrOfBllbleItm AS CABillgPlnItemNrOfBllbleItm,
  _CABillgPlnItemTP.CAInvcgOffsettingAction AS CAInvcgOffsettingAction,
  _CABillgPlnItemTP.CAInvcgOffsettingCategory AS CAInvcgOffsettingCategory,
  _CABillgPlnItemTP.CAInvcgOffsettingProcedure AS CAInvcgOffsettingProcedure,
  _CABillgPlnItemTP.CAInvcgOffsettingReferenceKey AS CAInvcgOffsettingReferenceKey,
  _CABillgPlnItemTP.CAIsRevnAcctgTransfRecordRlvt AS CAIsRevnAcctgTransfRecordRlvt,
  _CABillgPlnItemTP.ConditionType AS ConditionType,
  _CABillgPlnItemTP.ConditionIsForStatistics AS ConditionIsForStatistics,
  _CABillgPlnItemTP.CANetDueDate AS CANetDueDate,
  CABillgPlnItmIsNotToBeReqd,
  CABllbleItmCostType,
  CABllbleItmCostSubType,
  _CABillgPlnItemTP.CAIntcoCompanyCodeRequesting AS CAIntcoCompanyCodeRequesting,
  _CABillgPlnItemTP.CAIntcoCompanyCodeSupplying AS CAIntcoCompanyCodeSupplying,
  _CABillgPlnItemTP.CAIntcoType AS CAIntcoType,
  _CABillgPlnItemTP.CAIntcoSubtype AS CAIntcoSubtype,
  _CABillgPlnItmStatus._Text[1: Language=$session.system_language].CABillgPlnItmStatusText AS CABillgPlnItmStatusText,
  _ExcptnRsn._Text[1: Language=$session.system_language].CABillgPlnItmExcptnRsnText AS CABillgPlnItmExcptnRsnText,
  _CABillgCycle._CABillgCycleText[1: Language=$session.system_language].CABillgCycleText AS CABillgCycleText,
  _CABillgPlnItmType._Text[1: Language=$session.system_language].CABillgPlnItmTypeText AS CABillgPlnItmTypeText,
  _CABillgPlnItmCat._Text[1: Language=$session.system_language].CABillgPlnItmCatText AS CABillgPlnItmCatText,
  _TransactionCurrency._Text[1: Language=$session.system_language].CurrencyName AS CurrencyName,
  _UnitOfMeasure._Text[1: Language=$session.system_language].UnitOfMeasureName AS UnitOfMeasureName,
  _CAConditionType._Text[1: Language=$session.system_language].ConditionTypeName AS CAConditionTypeName,
  _CABillgPlnItmAmtDetnType._CABillgPlnItmAmtDetnTypeText[1: Language=$session.system_language].CABillgPlnItmAmtDetnTypeText AS CABillgPlnItmAmtDetnTypeText,
  _CABillgPlnItmAmtDateType._CABillgPlnItmAmtDateTypeText[1: Language=$session.system_language].CABillgPlnItmAmtDateTypeText AS CABillgPlnItmAmtDateTypeText,
  _CABillgPlnItmPrcDateType._CABillgPlnItmPrcDateTypeText[1: Language=$session.system_language].CABillgPlnItmPrcDateTypeText AS CABillgPlnItmPrcDateTypeText,
  _MainTransaction._Text[1: Language=$session.system_language].CAMainTransactionName AS CAMainTransactionName,
  _SubTransaction._Text[1: Language=$session.system_language].CASubTransactionName AS CASubTransactionName,
  _CARevnAcctgServiceType._CARevnAcctgServiceTypeText[1: Language=$session.system_language].CARevnAcctgServiceTypeText AS CARevnAcctgServiceTypeText,
  _CADependentItemType._CADependentItemTypeText[1: Language=$session.system_language].CADependentItemTypeText AS CADependentItemTypeText,
  _SubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText AS CASubApplicationText,
  _Division._Text[1: Language=$session.system_language].DivisionName AS DivisionName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _BusinessArea._Text[1: Language=$session.system_language].BusinessAreaName AS BusinessAreaName,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  _SalesOrganization._Text[1: Language=$session.system_language].SalesOrganizationName AS SalesOrganizationName,
  _DistributionChannel._Text[1: Language=$session.system_language].DistributionChannelName AS DistributionChannelName,
  _CAInvcgOffsettingAction._Text[1: Language=$session.system_language].CAInvcgOffsettingActionText AS CAInvcgOffsettingActionText,
  _CAInvcgOffsettingCategory._Text[1: Language=$session.system_language].CAInvcgOffsettingCategoryTxt AS CAInvcgOffsettingCategoryTxt,
  _CAInvcgOffsettingProcedure._Text[1: Language=$session.system_language].CAInvcgOffsettingProcedText AS CAInvcgOffsettingProcedText,
  _CABllbleItmCostType._CABllbleItmCostTypeText[1: Language=$session.system_language].CABllbleItmCostTypeText AS CABllbleItmCostTypeText,
  _CABllbleItmCostSubtype._CABllbleItmCostSubtypeText[1: Language=$session.system_language].CABllbleItmCostSubtypeText AS CABllbleItmCostSubtypeText,
  _CAIntcoCompanyCodeRequesting.CompanyCodeName AS CAIntcoCoCodeRequestingName,
  _CAIntcoCompanyCodeSupplying.CompanyCodeName AS CAIntcoCoCodeSupplyingName,
  _CAIntcoType._CAIntcoTypeText[1: Language=$session.system_language].CAIntcoTypeText AS CAIntcoTypeText,
  _CAIntcoSubtype._CAIntcoSubtypeText[1: Language=$session.system_language].CAIntcoSubtypeText AS CAIntcoSubtypeText,
  _CondType._Text[1: Language=$session.system_language].ConditionTypeName AS ConditionTypeName,
  _CABillgPln.CABillgPlnCategory AS CABillgPlnCategory,
  _CABillgPln._CABillgPlnType AS _CABillgPlnType
FROM I_CABillgPlnItemTP AS _CABillgPlnItemTP
LEFT OUTER JOIN C_CABillgPln AS _CABillgPln ON CABillgPlnNumber = _CABillgPln.CABillgPlnNumber  -- association [1..1]
;

Depth:

C_CABillgPlnItem view_entity

I_CABillgPlnItemTP view_entity