C_CABillgPlnBllbleItm

DDL: C_CABILLGPLNBLLBLEITM SQL: CCA_BIP_BILL_I Type: view CONSUMPTION
59 Fields 1 Data Sources

Abrechenbare Pos. zum Abrechnungsplan

C_CABillgPlnBllbleItm is a Consumption CDS View that provides data about "Abrechenbare Pos. zum Abrechnungsplan" in SAP S/4HANA. It reads from 1 data source (I_CABillgPlnBllbleItm) and exposes 59 fields with key fields CABillgPlnNumber, CABillgPlnItem, CABllbleItmUUID.

Data Sources (1)

SourceAliasJoin Type
I_CABillgPlnBllbleItm BillgPlnBillItem from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCA_BIP_BILL_I view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
UI.headerInfo.typeName Abrechenbare Position view
UI.headerInfo.typeNamePlural Abrechenbare Positionen view
EndUserText.label Abrechenbare Pos. zum Abrechnungsplan view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY CABillgPlnNumber I_CABillgPlnBllbleItm CABillgPlnNumber Billing Plan
KEY CABillgPlnItem I_CABillgPlnBllbleItm CABillgPlnItem Item
KEY CABllbleItmUUID I_CABillgPlnBllbleItm CABllbleItmUUID Bill. Itms GUID
CABllbleItmCreationDate I_CABillgPlnBllbleItm CABllbleItmCreationDate Created On
CABllbleItmCreationTime I_CABillgPlnBllbleItm CABllbleItmCreationTime Created At
CABllbleItmPackNo I_CABillgPlnBllbleItm CABllbleItmPackNo
CABillgBaseDate I_CABillgPlnBllbleItm CABillgBaseDate Baseline Date
CABillgFirstDate I_CABillgPlnBllbleItm CABillgFirstDate Bill From
CABllbleItmClass I_CABillgPlnBllbleItm CABllbleItmClass Class
CABillgPlnLastRequestDate I_CABillgPlnBllbleItm CABillgPlnLastRequestDate Last Request
CABillgPlnDvtgNextRequestDate I_CABillgPlnBllbleItm CABillgPlnDvtgNextRequestDate Diff. ReqDate
CABillgPlnRequestDate I_CABillgPlnBllbleItm CABillgPlnRequestDate Request Date
CABillgSubprocess I_CABillgPlnBllbleItm CABillgSubprocess Subprocess
CABllbleItmDate I_CABillgPlnBllbleItm CABllbleItmDate Date of Origin
CABllbleItmTime I_CABillgPlnBllbleItm CABllbleItmTime Time of Origin
CABllbleItmTimeZone
CABllbleItmStartDate I_CABillgPlnBllbleItm CABllbleItmStartDate From Date
CABllbleItmEndDate I_CABillgPlnBllbleItm CABllbleItmEndDate To Date
CABllbleItmCurrency I_CABillgPlnBllbleItm CABllbleItmCurrency Currency
CABllbleItmHandle I_CABillgPlnBllbleItm CABllbleItmHandle Log Number
CABllbleItmSimlnSts I_CABillgPlnBllbleItm CABllbleItmSimlnSts Simulation Doc.
CABllbleItmAmount I_CABillgPlnBllbleItm CABllbleItmAmount Amount
CABllbleItmQty I_CABillgPlnBllbleItm CABllbleItmQty Billing Quantity
CABllbleItmQtyUnit I_CABillgPlnBllbleItm CABllbleItmQtyUnit Unit of Measure
CAIsRevenueAccountingRelevant I_CABillgPlnBllbleItm CAIsRevenueAccountingRelevant Rev. Acctg Relevant
CABllbleItmIsReversed I_CABillgPlnBllbleItm CABllbleItmIsReversed Reversed Req.
CABllbleItmSourceTransId I_CABillgPlnBllbleItm CABllbleItmSourceTransId
CABllbleItmSourceTransType I_CABillgPlnBllbleItm CABllbleItmSourceTransType
CABllbleItmType I_CABillgPlnBllbleItm CABllbleItmType Bill.Item Type
CABllbleItmPackageUUID I_CABillgPlnBllbleItm CABllbleItmPackageUUID
CAProviderContractItemNumber I_CABillgPlnBllbleItm CAProviderContractItemNumber Contract Item
CASubApplication I_CABillgPlnBllbleItm CASubApplication Subapplication
BusinessPartner I_CABillgPlnBllbleItm BusinessPartner Issuing Authority
ContractAccount I_CABillgPlnBllbleItm ContractAccount Contract Acct
CAContract I_CABillgPlnBllbleItm CAContract Contract
CABllbleItmStatus
CABllbleItmStatusText
CABillgDocument
CAInvoicingDocument
BusinessPartnerName _BusinessPartner BusinessPartnerName Extracted Customer Name
ContractAccountName _ContractAccount ContractAccountName Cont. acct name
CABllbleItmClassText
CABillgSubprocessText
CABllbleItmSrceTransTypeText
CABllbleItmSimlnStsText
CABllbleItmTypeText
CASubApplicationText
_CABillgPln _CABillgPln
_CABillgPlnItem _CABillgPlnItem
_CABllbleItmClass _CABllbleItmClass
_CABillgSubprocess _CABillgSubprocess
_CABllbleItmSrceTransType _CABllbleItmSrceTransType
_CABllbleItmSimlnSts _CABllbleItmSimlnSts
_CABllbleItmType _CABllbleItmType
_CASubApplication _CASubApplication
_BusinessPartner _BusinessPartner
_ContractAccount _ContractAccount
_CABllbleItmCurrency _CABllbleItmCurrency
_CABllbleItmQtyUnit _CABllbleItmQtyUnit

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_CABillgPlnBllbleItm.
-- 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.
-- SQL view name: CCA_BIP_BILL_I

CREATE VIEW C_CABillgPlnBllbleItm AS
SELECT
  BillgPlnBillItem.CABillgPlnNumber AS CABillgPlnNumber,
  BillgPlnBillItem.CABillgPlnItem AS CABillgPlnItem,
  BillgPlnBillItem.CABllbleItmUUID AS CABllbleItmUUID,
  BillgPlnBillItem.CABllbleItmCreationDate AS CABllbleItmCreationDate,
  BillgPlnBillItem.CABllbleItmCreationTime AS CABllbleItmCreationTime,
  BillgPlnBillItem.CABllbleItmPackNo AS CABllbleItmPackNo,
  BillgPlnBillItem.CABillgBaseDate AS CABillgBaseDate,
  BillgPlnBillItem.CABillgFirstDate AS CABillgFirstDate,
  BillgPlnBillItem.CABllbleItmClass AS CABllbleItmClass,
  BillgPlnBillItem.CABillgPlnLastRequestDate AS CABillgPlnLastRequestDate,
  BillgPlnBillItem.CABillgPlnDvtgNextRequestDate AS CABillgPlnDvtgNextRequestDate,
  BillgPlnBillItem.CABillgPlnRequestDate AS CABillgPlnRequestDate,
  BillgPlnBillItem.CABillgSubprocess AS CABillgSubprocess,
  BillgPlnBillItem.CABllbleItmDate AS CABllbleItmDate,
  BillgPlnBillItem.CABllbleItmTime AS CABllbleItmTime,
  cast(abap_system_timezone($session.client, 'NULL') as timezone) AS CABllbleItmTimeZone,
  BillgPlnBillItem.CABllbleItmStartDate AS CABllbleItmStartDate,
  BillgPlnBillItem.CABllbleItmEndDate AS CABllbleItmEndDate,
  BillgPlnBillItem.CABllbleItmCurrency AS CABllbleItmCurrency,
  BillgPlnBillItem.CABllbleItmHandle AS CABllbleItmHandle,
  BillgPlnBillItem.CABllbleItmSimlnSts AS CABllbleItmSimlnSts,
  BillgPlnBillItem.CABllbleItmAmount AS CABllbleItmAmount,
  BillgPlnBillItem.CABllbleItmQty AS CABllbleItmQty,
  BillgPlnBillItem.CABllbleItmQtyUnit AS CABllbleItmQtyUnit,
  BillgPlnBillItem.CAIsRevenueAccountingRelevant AS CAIsRevenueAccountingRelevant,
  BillgPlnBillItem.CABllbleItmIsReversed AS CABllbleItmIsReversed,
  BillgPlnBillItem.CABllbleItmSourceTransId AS CABllbleItmSourceTransId,
  BillgPlnBillItem.CABllbleItmSourceTransType AS CABllbleItmSourceTransType,
  BillgPlnBillItem.CABllbleItmType AS CABllbleItmType,
  BillgPlnBillItem.CABllbleItmPackageUUID AS CABllbleItmPackageUUID,
  BillgPlnBillItem.CAProviderContractItemNumber AS CAProviderContractItemNumber,
  BillgPlnBillItem.CASubApplication AS CASubApplication,
  BillgPlnBillItem.BusinessPartner AS BusinessPartner,
  BillgPlnBillItem.ContractAccount AS ContractAccount,
  BillgPlnBillItem.CAContract AS CAContract,
  cast( '' as bitstatus_fio_kk ) AS CABllbleItmStatus,
  cast( '' as descr_kk ) AS CABllbleItmStatusText,
  cast( '' as billdocno_kk ) AS CABillgDocument,
  cast( '' as invdocno_kk ) AS CAInvoicingDocument,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _ContractAccount.ContractAccountName AS ContractAccountName,
  _CABllbleItmClass._CABllbleItmClassText[1: Language=$session.system_language].CABllbleItmClassText AS CABllbleItmClassText,
  _CABillgSubprocess._CABillgSubprocessText[1: Language=$session.system_language].CABillgSubprocessText AS CABillgSubprocessText,
  _CABllbleItmSrceTransType._CABllbleItmSrceTransTypeText[1: Language=$session.system_language].CABllbleItmSrceTransTypeText AS CABllbleItmSrceTransTypeText,
  _CABllbleItmSimlnSts._CABllbleItmSimlnStsText[1: Language=$session.system_language].CABllbleItmSimlnStsText AS CABllbleItmSimlnStsText,
  _CABllbleItmType._CABllbleItmTypeText[1: Language=$session.system_language].CABllbleItmTypeText AS CABllbleItmTypeText,
  _CASubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText AS CASubApplicationText
FROM I_CABillgPlnBllbleItm AS BillgPlnBillItem
;

Learn More