R_CABillgDocItemDraft

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_CABillgDocItemDraft.
-- 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_CABillgDocItemDraft AS
SELECT
  CABillgDocument,
  CABillgDocItem,
  DraftUUID,
  ParentDraftUUID,
  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,
  cast( wbselementinternalid as fis_wbsint_no_conv preserving type ) AS WBSElementInternalID,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM dfkkinvbill_i_d AS _CABillgDocItemDraft
LEFT OUTER JOIN R_CABillgDocumentDraft AS _CABillgDocumentDraft ON CABillgDocument = _CABillgDocumentDraft.CABillgDocument AND ParentDraftUUID = _CABillgDocumentDraft.DraftUUID  -- association [0..1]
LEFT OUTER JOIN E_CABillgDocItemDraft AS _Extension ON CABillgDocument = _Extension.CABillgDocument AND DraftUUID = _Extension.DraftUUID  -- association [0..1]
;