R_CABillgPlnItemDraft

DDL: R_CABILLGPLNITEMDRAFT Type: view_entity BASIC Package: FCI_RAP_BILLPLAN
78 Fields 1 Data Sources 2 Associations

Billing Plan Item Draft

R_CABillgPlnItemDraft is a Basic CDS View that provides data about "Billing Plan Item Draft" in SAP S/4HANA. It reads from 1 data source (dfkkbix_bip_i_d2) and exposes 78 fields with key fields CABillgPlnNumber, CABillgPlnItem, DraftUUID. It has 2 associations to related views. Part of development package FCI_RAP_BILLPLAN.

Data Sources (1)

SourceAliasJoin Type
dfkkbix_bip_i_d2 dfkkbix_bip_i_d2 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] R_CABillgPlnDraft _CABillgPlnDraft $projection.CABillgPlnNumber = _CABillgPlnDraft.CABillgPlnNumber and $projection.ParentDraftUUID = _CABillgPlnDraft.DraftUUID
[0..1] E_CABillgPlnItemDraft _Extension $projection.CABillgPlnNumber = _Extension.CABillgPlnNumber and $projection.CABillgPlnItem = _Extension.CABillgPlnItem and $projection.DraftUUID = _Extension.DraftUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Billing Plan Item Draft view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (78)

KeyFieldSource TableSource FieldDescription
KEY CABillgPlnNumber cabillgplnnumber Billing Plan
KEY CABillgPlnItem cabillgplnitem Item
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
CABillgPlnType _CABillgPlnDraft CABillgPlnType Billing Plan Type
CABillgPlnItmCat cabillgplnitmcat Billing Pln Itm Cat.
CABillgPlnItmType cabillgplnitmtype Billing Plan Itm Typ
CABillgPlnItmTxt cabillgplnitmtxt Name
CABillgPlnItemExtRef cabillgplnitemextref Ext. Reference
CABillgPlnItemAmount cabillgplnitemamount Amount
TransactionCurrency transactioncurrency Transaction Currency
CATaxIsIncluded cataxisincluded Gross
CABillgPlnItemQuantity cabillgplnitemquantity Billing Quantity
CABillgPlnItemQuantityUnit cabillgplnitemquantityunit Unit of Measure
CATaxDeterminationCode cataxdeterminationcode Tax Determination
TaxCode taxcode Tax Code
CABillgPlnItemStartDate cabillgplnitemstartdate Valid From
CABillgPlnItmEndDate cabillgplnitmenddate Valid to
CABillgPlnItemTermStartDate cabillgplnitemtermstartdate Term From
CABillgPlnItemTermEndDate cabillgplnitemtermenddate Term To
CABillgPlnItemRecurring cabillgplnitemrecurring RecurringBillgPlnItm
CABillgCycle cabillgcycle Billing Cycle
CAConditionType caconditiontype Condition Type
CABillgPlnItemAmountDetnType cabillgplnitemamountdetntype Type of Amount Detn
CABillgPlnItemAmountDateType cabillgplnitemamountdatetype Type of Amount Detn Date
CABillgPlnItemPriceDateType cabillgplnitempricedatetype Type Pricing Date
CAContract cacontract Contract
CAProviderContractItemNumber caprovidercontractitemnumber Contract Item
CASubApplication casubapplication Subapplication
CAProviderContractItemUUID caprovidercontractitemuuid Contr.Item ID
Division division Internal Division ID
CompanyCode companycode Receiver Company Code
BusinessArea businessarea Business Area
Segment segment Segment number
CAMainTransaction camaintransaction Main Trans.
CASubTransaction casubtransaction Subtransaction
CABillgPlnItemServiceType cabillgplnitemservicetype Service Type
CADependentItemType cadependentitemtype Dependent Item Type
Material material Vehicle Model
SalesOrganization salesorganization Sales Organization
DistributionChannel distributionchannel RefDistCh-Cust/Mat.
CAAccountDeterminationCode caaccountdeterminationcode Acct Determ. ID
CAInvcgOffsettingAction cainvcgoffsettingaction Action Offsett.
CAInvcgOffsettingCategory cainvcgoffsettingcategory Offsetting Cat.
CAInvcgOffsettingProcedure cainvcgoffsettingprocedure Offsett. Proc.
CAInvcgOffsettingReferenceKey cainvcgoffsettingreferencekey Offsetting Ref.
CABillgPlnItemReqDteLast cabillgplnitemreqdtelast Last Request
CABillgPlnItemReqDteNext cabillgplnitemreqdtenext Next Request
CABillgPlnDvtgNextRequestDate cabillgplndvtgnextrequestdate Diff. ReqDate
CABillgPlnItemRequestedToDte cabillgplnitemrequestedtodte Requested Until
CABillgPlnItemCanceled cabillgplnitemcanceled Item Discarded
CABillgPlnSubItmExist cabillgplnsubitmexist Subitm Exists
CABillgPlnItemMain cabillgplnitemmain Main Item
CABillgPlnItmExcptnReason cabillgplnitmexcptnreason Adjust. Reason
CABillgPlnItemChildExist cabillgplnitemchildexist Follow-On Itm Exists
CABillgPlnItemParent cabillgplnitemparent HigherLevelItem
CABillgPlnItemStatus cabillgplnitemstatus Status
CABillgPlnItemNrOfBllbleItm cabillgplnitemnrofbllbleitm No. of Requests
CAIsRevnAcctgTransfRecordRlvt caisrevnacctgtransfrecordrlvt OrderItm Exists
ConditionType conditiontype Condition type
ConditionIsForStatistics conditionisforstatistics Statistical
CANetDueDate canetduedate Net Due Date
CABillgPlnItmIsNotToBeReqd cabillgplnitmisnottobereqd Checkbox
CABllbleItmCostType cabllbleitmcosttype Billable Item Cost Type
CABllbleItmCostSubType cabllbleitmcostsubtype Billable Item Cost Subtype
CAIntcoCompanyCodeRequesting caintcocompanycoderequesting ReqCCode
CAIntcoCompanyCodeSupplying caintcocompanycodesupplying Supplying CCode
CAIntcoType caintcotype IntSettlmntType
CAIntcoSubtype caintcosubtype Intco Settlmt Subtype
TaxCalculationProcedure taxcalculationprocedure Tax Procedure
CAApplicationArea caapplicationarea ApplicationArea
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
_CABillgPlnDraft _CABillgPlnDraft

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 R_CABillgPlnItemDraft.
-- 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 R_CABillgPlnItemDraft AS
SELECT
  CABillgPlnNumber,
  CABillgPlnItem,
  DraftUUID,
  ParentDraftUUID,
  _CABillgPlnDraft.CABillgPlnType AS CABillgPlnType,
  CABillgPlnItmCat,
  CABillgPlnItmType,
  CABillgPlnItmTxt,
  CABillgPlnItemExtRef,
  CABillgPlnItemAmount,
  TransactionCurrency,
  CATaxIsIncluded,
  CABillgPlnItemQuantity,
  CABillgPlnItemQuantityUnit,
  CATaxDeterminationCode,
  TaxCode,
  CABillgPlnItemStartDate,
  CABillgPlnItmEndDate,
  CABillgPlnItemTermStartDate,
  CABillgPlnItemTermEndDate,
  CABillgPlnItemRecurring,
  CABillgCycle,
  CAConditionType,
  CABillgPlnItemAmountDetnType,
  CABillgPlnItemAmountDateType,
  CABillgPlnItemPriceDateType,
  CAContract,
  CAProviderContractItemNumber,
  CASubApplication,
  CAProviderContractItemUUID,
  Division,
  CompanyCode,
  BusinessArea,
  Segment,
  CAMainTransaction,
  CASubTransaction,
  CABillgPlnItemServiceType,
  CADependentItemType,
  Material,
  SalesOrganization,
  DistributionChannel,
  CAAccountDeterminationCode,
  CAInvcgOffsettingAction,
  CAInvcgOffsettingCategory,
  CAInvcgOffsettingProcedure,
  CAInvcgOffsettingReferenceKey,
  CABillgPlnItemReqDteLast,
  CABillgPlnItemReqDteNext,
  CABillgPlnDvtgNextRequestDate,
  CABillgPlnItemRequestedToDte,
  CABillgPlnItemCanceled,
  CABillgPlnSubItmExist,
  CABillgPlnItemMain,
  CABillgPlnItmExcptnReason,
  CABillgPlnItemChildExist,
  CABillgPlnItemParent,
  CABillgPlnItemStatus,
  CABillgPlnItemNrOfBllbleItm,
  CAIsRevnAcctgTransfRecordRlvt,
  ConditionType,
  ConditionIsForStatistics,
  CANetDueDate,
  CABillgPlnItmIsNotToBeReqd,
  CABllbleItmCostType,
  CABllbleItmCostSubType,
  CAIntcoCompanyCodeRequesting,
  CAIntcoCompanyCodeSupplying,
  CAIntcoType,
  CAIntcoSubtype,
  TaxCalculationProcedure,
  CAApplicationArea,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM dfkkbix_bip_i_d2
LEFT OUTER JOIN R_CABillgPlnDraft AS _CABillgPlnDraft ON CABillgPlnNumber = _CABillgPlnDraft.CABillgPlnNumber AND ParentDraftUUID = _CABillgPlnDraft.DraftUUID  -- association [0..1]
LEFT OUTER JOIN E_CABillgPlnItemDraft AS _Extension ON CABillgPlnNumber = _Extension.CABillgPlnNumber AND CABillgPlnItem = _Extension.CABillgPlnItem AND DraftUUID = _Extension.DraftUUID  -- association [0..1]
;

Learn More