I_CABillgDocumentTP

DDL: I_CABILLGDOCUMENTTP Type: view_entity TRANSACTIONAL Package: FCI_RAP_BILLDOC
55 Fields 1 Data Sources

Billing Document - TP

I_CABillgDocumentTP is a Transactional CDS View that provides data about "Billing Document - TP" in SAP S/4HANA. It reads from 1 data source (R_CABillgDocumentTP) and exposes 55 fields with key field CABillgDocument. Part of development package FCI_RAP_BILLDOC.

Data Sources (1)

SourceAliasJoin Type
R_CABillgDocumentTP R_CABillgDocumentTP projection

Annotations (16)

NameValueLevelField
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix BLH 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 - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.representativeKey CABillgDocument view
ObjectModel.sapObjectNodeType.name ContrAcctgBillingDocument 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 (55)

KeyFieldSource TableSource FieldDescription
KEY CABillgDocument CABillgDocument Billing Doc.
BusinessPartner BusinessPartner Issuing Authority
ContractAccount ContractAccount Contract Acct
CABillgType CABillgType Billing Type
CABillgDocPeriodStartDate CABillgDocPeriodStartDate Start of Document Period
CABillgDocPeriodEndDate CABillgDocPeriodEndDate End of Document Period
CABillgDocumentReversalReason CABillgDocumentReversalReason Reversal Reason
CABillgIsDocumentSimulated CABillgIsDocumentSimulated Simulation Doc.
CABillgDocumentExternal CABillgDocumentExternal External Document Number
LogicalSystem LogicalSystem Logical System
CAApplicationArea CAApplicationArea ApplicationArea
CABillgDocOriginProcess CABillgDocOriginProcess Origin
CAInvcgSourceDocumentType CAInvcgSourceDocumentType Source Doc.Type
CAInvcgTechnicalDocumentType CAInvcgTechnicalDocumentType Technical Document Type
CAInvcgDocumentType CAInvcgDocumentType Document Type
CAInvcgTargetProcess CAInvcgTargetProcess Target Process
CAInvcgMasterDataType CAInvcgMasterDataType MasterData Type
CAInvcgAltvBusinessPartner CAInvcgAltvBusinessPartner Altv Business Partner
CAInvcgAltvContractAccount CAInvcgAltvContractAccount Altv Contract Account
CABillgBaseDate CABillgBaseDate Baseline Date
CABillgCurrency CABillgCurrency Currency
CAInvcgCurrency CAInvcgCurrency Invoicing Target Currency
CATaxDetnType CATaxDetnType Tax Calculation
CATaxDateType CATaxDateType Tax Date
CAInvcgCategory CAInvcgCategory Invoicing Cat.
CAInvcgControlOfInvoicingUnit CAInvcgControlOfInvoicingUnit Invoicing Unit Control
CAInvcgFirstDate CAInvcgFirstDate Invoice From
CABillgReversalDocument CABillgReversalDocument Reversal Document Number
CABillgReversedDocument CABillgReversedDocument Rev. Doc. For
CABillgAdjustmentDocument CABillgAdjustmentDocument Adjustment Billg Documnt
CABillgAdjustedDocument CABillgAdjustedDocument Adjusted Document
CAInvcgCorrectionCategory CAInvcgCorrectionCategory Invcg Correction Category
CaInvcgIsOrderDeleted CaInvcgIsOrderDeleted Invoicing Order Deleted
CABillgHasAdditionalInvoice CABillgHasAdditionalInvoice Info in Invoice
CAInvcgIsAccrualPostingRlvt CAInvcgIsAccrualPostingRlvt Accrual/Deferral Posting
CABillgLockedForInvoicing CABillgLockedForInvoicing Invoicing Lock
CABillgGrpgOfAdditionalItems CABillgGrpgOfAdditionalItems Additional Item Grouping
CABillgDocHasRefObjects CABillgDocHasRefObjects Object References Exist
CABillgDocumentNumberOfItems CABillgDocumentNumberOfItems Number of Items
CABllbleItmNumber CABllbleItmNumber Number of Billable Items
CreatedByUser CreatedByUser User Name
CABillgDocCreationDate CABillgDocCreationDate Billed On
CABillgDocCreationTime CABillgDocCreationTime Billed At
CABillgDocInternalNumber CABillgDocInternalNumber Billing Run Number
CABillgProcess CABillgProcess Billing Process
CABillgDocHasPrepaidItems CABillgDocHasPrepaidItems Prepaid
CABillgDocHasRefillItems CABillgDocHasRefillItems Prepaid Refill
CABillgDocHasRevnRecgnItems CABillgDocHasRevnRecgnItems Rev Deferral
CAPartnerSettlementRule CAPartnerSettlementRule Settlement Rule
CABillgDocumentInvcgStatus CABillgDocumentInvcgStatus Invoicg Status
CAInvoicingDocument CAInvoicingDocument Invoic. Doc.
CAInvcgCreationDate CAInvcgCreationDate Invoiced On
CASubAreaForParallelization CASubAreaForParallelization Subarea
CAAltvMDOriginalIsIncluded CAAltvMDOriginalIsIncluded OriglMasterData
_ContractAccountPartner _ContractAccountPartner

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_CABillgDocumentTP.
-- 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_CABillgDocumentTP AS
SELECT
  CABillgDocument,
  BusinessPartner,
  ContractAccount,
  CABillgType,
  CABillgDocPeriodStartDate,
  CABillgDocPeriodEndDate,
  CABillgDocumentReversalReason,
  CABillgIsDocumentSimulated,
  CABillgDocumentExternal,
  LogicalSystem,
  CAApplicationArea,
  CABillgDocOriginProcess,
  CAInvcgSourceDocumentType,
  CAInvcgTechnicalDocumentType,
  CAInvcgDocumentType,
  CAInvcgTargetProcess,
  CAInvcgMasterDataType,
  CAInvcgAltvBusinessPartner,
  CAInvcgAltvContractAccount,
  CABillgBaseDate,
  CABillgCurrency,
  CAInvcgCurrency,
  CATaxDetnType,
  CATaxDateType,
  CAInvcgCategory,
  CAInvcgControlOfInvoicingUnit,
  CAInvcgFirstDate,
  CABillgReversalDocument,
  CABillgReversedDocument,
  CABillgAdjustmentDocument,
  CABillgAdjustedDocument,
  CAInvcgCorrectionCategory,
  CaInvcgIsOrderDeleted,
  CABillgHasAdditionalInvoice,
  CAInvcgIsAccrualPostingRlvt,
  CABillgLockedForInvoicing,
  CABillgGrpgOfAdditionalItems,
  CABillgDocHasRefObjects,
  CABillgDocumentNumberOfItems,
  CABllbleItmNumber,
  CreatedByUser,
  CABillgDocCreationDate,
  CABillgDocCreationTime,
  CABillgDocInternalNumber,
  CABillgProcess,
  CABillgDocHasPrepaidItems,
  CABillgDocHasRefillItems,
  CABillgDocHasRevnRecgnItems,
  CAPartnerSettlementRule,
  CABillgDocumentInvcgStatus,
  CAInvoicingDocument,
  CAInvcgCreationDate,
  CASubAreaForParallelization,
  CAAltvMDOriginalIsIncluded
FROM R_CABillgDocumentTP
;

Learn More