I_CABillPrntBillgDocHeader

DDL: I_CABILLPRNTBILLGDOCHEADER Type: view_entity COMPOSITE
55 Fields 1 Data Sources 3 Associations

Abrechnungsbelegkopf anzeigen

I_CABillPrntBillgDocHeader is a Composite CDS View that provides data about "Abrechnungsbelegkopf anzeigen" in SAP S/4HANA. It reads from 1 data source (I_CABillgDocHeader) and exposes 55 fields with key field CABillgDocument. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CABillgDocHeader _CABillgDocHeader from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ContractAccountPartner _ContractAccountPartner $projection.ContractAccount = _ContractAccountPartner.ContractAccount and $projection.BusinessPartner = _ContractAccountPartner.BusinessPartner
[0..1] I_ContractAccountHeader _ContractAccountHeader $projection.ContractAccount = _ContractAccountHeader.ContractAccount
[0..1] E_CABillgDocHeader _Extension $projection.CABillgDocument = _Extension.CABillgDocument

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Abrechnungsbelegkopf anzeigen view

Fields (55)

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

Learn More