Deprecated
This CDS view is deprecated in S/4HANA. Use C_CABillgPln_2 instead. View all deprecated CDS views →

C_CABillgPln

DDL: C_CABILLGPLN Type: view_entity CONSUMPTION
70 Fields 1 Data Sources 6 Associations

Abrechnungsplankopf

C_CABillgPln is a Consumption CDS View that provides data about "Abrechnungsplankopf" in SAP S/4HANA. It reads from 1 data source (I_CABillgPlnTP) and exposes 70 fields with key field CABillgPlnNumber. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CABillgPlnTP _CABillgPlnTP from

Associations (6)

CardinalityTargetAliasCondition
[0..*] C_CABillgPlnItem _CABillgPlnItem $projection.CABillgPlnNumber = _CABillgPlnItem.CABillgPlnNumber
[0..*] C_CABillgPlnRef _CABillgPlnRef $projection.CABillgPlnNumber = _CABillgPlnRef.CABillgPlnNumber
[0..*] C_CABillgPlnBllbleItm _CABillgPlnBllbleItm $projection.CABillgPlnNumber = _CABillgPlnBllbleItm.CABillgPlnNumber
[0..1] C_CABillgReqBPAddress _CABillgReqBPAddress $projection.BusinessPartner = _CABillgReqBPAddress.BusinessPartner
[0..1] I_User _CABillgPlnCreatedByUser $projection.CABillgPlnCreatedByUser = _CABillgPlnCreatedByUser.UserID
[0..1] I_User _CABillgPlnChangedByUser $projection.CABillgPlnChangedByUser = _CABillgPlnChangedByUser.UserID

Annotations (17)

NameValueLevelField
VDM.viewType #CONSUMPTION view
EndUserText.label Abrechnungsplankopf view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_CABillgPln_2 view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey CABillgPlnNumber view
UI.headerInfo.typeName Abrechnungsplan view
UI.headerInfo.typeNamePlural Abrechnungspläne view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.label Abrechnungsplan view
UI.headerInfo.title.value CABillgPlnNumber view
UI.headerInfo.description.value CABillgPlnDescription view
Search.searchable true view

Fields (70)

KeyFieldSource TableSource FieldDescription
KEY CABillgPlnNumber I_CABillgPlnTP CABillgPlnNumber Abrechnungsplan
CABillgPlnName I_CABillgPlnTP CABillgPlnName
CABillgPlnStatus I_CABillgPlnTP CABillgPlnStatus Status
CABillgPlnType I_CABillgPlnTP CABillgPlnType Art des Abrechnungsplans
CABillgPlnTypeDisplay I_CABillgPlnTP CABillgPlnTypeDisplay Art des Abrechnungsplans
CABillgPlnDescription I_CABillgPlnTP CABillgPlnDescription Name
BusinessPartner I_CABillgPlnTP BusinessPartner Issuing Authority
BusinessPartnerName
FirstName
LastName
StreetName _CABillgReqBPAddress StreetName Text
AddressCityName _CABillgReqBPAddress AddressCityName City
Country _CABillgReqBPAddress Country Venue: Ctry/Reg
CountryName _CABillgReqBPAddress CountryName Country
ContractAccount I_CABillgPlnTP ContractAccount Contract Acct
ContractAccountName
CAContract I_CABillgPlnTP CAContract Contract
CAContractSemanticObject
CAProviderContractItemUUID I_CABillgPlnTP CAProviderContractItemUUID Contr.Item ID
CABillgPlnStartDate I_CABillgPlnTP CABillgPlnStartDate Valid From
CABillgPlnEndDate I_CABillgPlnTP CABillgPlnEndDate Valid To
CABillgPlnNextRequestDate I_CABillgPlnTP CABillgPlnNextRequestDate Next Request
CABillgPlnExternalReference I_CABillgPlnTP CABillgPlnExternalReference Ext. Reference
CABillgPlnLastRequestDate I_CABillgPlnTP CABillgPlnLastRequestDate Last Request
CABillgPlnCreationDate I_CABillgPlnTP CABillgPlnCreationDate Created On
CABillgPlnCreationTime I_CABillgPlnTP CABillgPlnCreationTime Created At
CABillgPlnCreationDateTime
CABillgPlnCreatedByUser I_CABillgPlnTP CABillgPlnCreatedByUser Created By
CABillgPlnCreatedByUserName _CABillgPlnCreatedByUser UserDescription Angelegt von
CABillgPlnChangeDate I_CABillgPlnTP CABillgPlnChangeDate Changed On
CABillgPlnChangeTime I_CABillgPlnTP CABillgPlnChangeTime Changed at
CABillgPlnChangeDateTime
CABillgPlnChangedByUser I_CABillgPlnTP CABillgPlnChangedByUser Changed By
CABillgPlnChangedByUserName _CABillgPlnChangedByUser UserDescription Geändert von
LastChangeDateTime I_CABillgPlnTP LastChangeDateTime Timestamp
CABillgPlnCompletionDate I_CABillgPlnTP CABillgPlnCompletionDate Completed On
CABillgPlnCategory I_CABillgPlnTP CABillgPlnCategory Billing Plan Category
LogicalSystem I_CABillgPlnTP LogicalSystem Logical System
CAApplicationArea I_CABillgPlnTP CAApplicationArea ApplicationArea
CAInvcgMasterDataType I_CABillgPlnTP CAInvcgMasterDataType MasterData Type
CASubApplication I_CABillgPlnTP CASubApplication Subapplication
CAMasterAgreement I_CABillgPlnTP CAMasterAgreement Master Agrmt
CAInvcgOffsettingReferenceKey I_CABillgPlnTP CAInvcgOffsettingReferenceKey Offsetting Ref.
CABillgPlnCreationMode I_CABillgPlnTP CABillgPlnCreationMode Creation Mode
CABillgPlnNumberBllbleItm I_CABillgPlnTP CABillgPlnNumberBllbleItm Number of Items
CABillgPlnNumberRef I_CABillgPlnTP CABillgPlnNumberRef
CABillgPlnIsTemplate I_CABillgPlnTP CABillgPlnIsTemplate Template
CABillgPlnNumberTemplate I_CABillgPlnTP CABillgPlnNumberTemplate
CABillgPlnVersion I_CABillgPlnTP CABillgPlnVersion Version
CABillgPlnCategoryText
CABillgPlnStatusText
CABillgPlnTypeText
CABillgPlnCreationModeText
CAInvcgMasterDataTypeText
CASubApplicationText
_CABillgPlnItem _CABillgPlnItem
_CABillgPlnStatus _CABillgPlnStatus
_CASubApplication _CASubApplication
_CABillgPlnType _CABillgPlnType
_CABillgPlnCategory _CABillgPlnCategory
_CABillgPlnRef _CABillgPlnRef
_CABillgPlnCreationMode _CABillgPlnCreationMode
_CABillgPlnBllbleItm _CABillgPlnBllbleItm
_CAInvcgMasterDataType _CAInvcgMasterDataType
_CABillgReqBPAddress _CABillgReqBPAddress
_ContractAccountPartner _ContractAccountPartner
_ContractAccount _ContractAccount
_BusinessPartner _BusinessPartner
_CABillgPlnCreatedByUser _CABillgPlnCreatedByUser
_CABillgPlnChangedByUser _CABillgPlnChangedByUser

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_CABillgPln.
-- 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 C_CABillgPln AS
SELECT
  _CABillgPlnTP.CABillgPlnNumber AS CABillgPlnNumber,
  _CABillgPlnTP.CABillgPlnName AS CABillgPlnName,
  _CABillgPlnTP.CABillgPlnStatus AS CABillgPlnStatus,
  _CABillgPlnTP.CABillgPlnType AS CABillgPlnType,
  _CABillgPlnTP.CABillgPlnTypeDisplay AS CABillgPlnTypeDisplay,
  _CABillgPlnTP.CABillgPlnDescription AS CABillgPlnDescription,
  _CABillgPlnTP.BusinessPartner AS BusinessPartner,
  _CABillgPlnTP._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CABillgPlnTP._BusinessPartner.FirstName AS FirstName,
  _CABillgPlnTP._BusinessPartner.LastName AS LastName,
  _CABillgReqBPAddress.StreetName AS StreetName,
  _CABillgReqBPAddress.AddressCityName AS AddressCityName,
  _CABillgReqBPAddress.Country AS Country,
  _CABillgReqBPAddress.CountryName AS CountryName,
  _CABillgPlnTP.ContractAccount AS ContractAccount,
  _CABillgPlnTP._ContractAccount.ContractAccountName AS ContractAccountName,
  _CABillgPlnTP.CAContract AS CAContract,
  cast ( '' as vtref_semobj_kk ) AS CAContractSemanticObject,
  _CABillgPlnTP.CAProviderContractItemUUID AS CAProviderContractItemUUID,
  _CABillgPlnTP.CABillgPlnStartDate AS CABillgPlnStartDate,
  _CABillgPlnTP.CABillgPlnEndDate AS CABillgPlnEndDate,
  _CABillgPlnTP.CABillgPlnNextRequestDate AS CABillgPlnNextRequestDate,
  _CABillgPlnTP.CABillgPlnExternalReference AS CABillgPlnExternalReference,
  _CABillgPlnTP.CABillgPlnLastRequestDate AS CABillgPlnLastRequestDate,
  _CABillgPlnTP.CABillgPlnCreationDate AS CABillgPlnCreationDate,
  _CABillgPlnTP.CABillgPlnCreationTime AS CABillgPlnCreationTime,
  cast(0 as crtimestamp_kk) AS CABillgPlnCreationDateTime,
  _CABillgPlnTP.CABillgPlnCreatedByUser AS CABillgPlnCreatedByUser,
  _CABillgPlnCreatedByUser.UserDescription AS CABillgPlnCreatedByUserName,
  _CABillgPlnTP.CABillgPlnChangeDate AS CABillgPlnChangeDate,
  _CABillgPlnTP.CABillgPlnChangeTime AS CABillgPlnChangeTime,
  cast(0 as changetimestamp_kk) AS CABillgPlnChangeDateTime,
  _CABillgPlnTP.CABillgPlnChangedByUser AS CABillgPlnChangedByUser,
  _CABillgPlnChangedByUser.UserDescription AS CABillgPlnChangedByUserName,
  _CABillgPlnTP.LastChangeDateTime AS LastChangeDateTime,
  _CABillgPlnTP.CABillgPlnCompletionDate AS CABillgPlnCompletionDate,
  _CABillgPlnTP.CABillgPlnCategory AS CABillgPlnCategory,
  _CABillgPlnTP.LogicalSystem AS LogicalSystem,
  _CABillgPlnTP.CAApplicationArea AS CAApplicationArea,
  _CABillgPlnTP.CAInvcgMasterDataType AS CAInvcgMasterDataType,
  _CABillgPlnTP.CASubApplication AS CASubApplication,
  _CABillgPlnTP.CAMasterAgreement AS CAMasterAgreement,
  _CABillgPlnTP.CAInvcgOffsettingReferenceKey AS CAInvcgOffsettingReferenceKey,
  _CABillgPlnTP.CABillgPlnCreationMode AS CABillgPlnCreationMode,
  _CABillgPlnTP.CABillgPlnNumberBllbleItm AS CABillgPlnNumberBllbleItm,
  _CABillgPlnTP.CABillgPlnNumberRef AS CABillgPlnNumberRef,
  _CABillgPlnTP.CABillgPlnIsTemplate AS CABillgPlnIsTemplate,
  _CABillgPlnTP.CABillgPlnNumberTemplate AS CABillgPlnNumberTemplate,
  _CABillgPlnTP.CABillgPlnVersion AS CABillgPlnVersion,
  _CABillgPlnCategory._CABillgPlnCategoryText[1: Language=$session.system_language].CABillgPlnCategoryText AS CABillgPlnCategoryText,
  _CABillgPlnStatus._CABillgPlnStatusText[1: Language=$session.system_language].CABillgPlnStatusText AS CABillgPlnStatusText,
  _CABillgPlnType._CABillgPlnTypeText[1: Language=$session.system_language].CABillgPlnTypeText AS CABillgPlnTypeText,
  _CABillgPlnCreationMode._CABillgPlnCreationModeText[1: Language=$session.system_language].CABillgPlnCreationModeText AS CABillgPlnCreationModeText,
  _CAInvcgMasterDataType._CAInvcgMasterDataTypeText[1: Language=$session.system_language].CAInvcgMasterDataTypeText AS CAInvcgMasterDataTypeText,
  _CASubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText AS CASubApplicationText
FROM I_CABillgPlnTP AS _CABillgPlnTP
LEFT OUTER JOIN C_CABillgPlnItem AS _CABillgPlnItem ON CABillgPlnNumber = _CABillgPlnItem.CABillgPlnNumber  -- association [0..*]
LEFT OUTER JOIN C_CABillgPlnRef AS _CABillgPlnRef ON CABillgPlnNumber = _CABillgPlnRef.CABillgPlnNumber  -- association [0..*]
LEFT OUTER JOIN C_CABillgPlnBllbleItm AS _CABillgPlnBllbleItm ON CABillgPlnNumber = _CABillgPlnBllbleItm.CABillgPlnNumber  -- association [0..*]
LEFT OUTER JOIN C_CABillgReqBPAddress AS _CABillgReqBPAddress ON BusinessPartner = _CABillgReqBPAddress.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_User AS _CABillgPlnCreatedByUser ON CABillgPlnCreatedByUser = _CABillgPlnCreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CABillgPlnChangedByUser ON CABillgPlnChangedByUser = _CABillgPlnChangedByUser.UserID  -- association [0..1]
;

Learn More