C_WrittenOffPrjBlgElmEntrDets

DDL: C_WRITTENOFFPRJBLGELMENTRDETS SQL: CWRITOFFPRJDET Type: view CONSUMPTION
25 Fields 1 Data Sources 5 Associations

Details for Written off itmes

C_WrittenOffPrjBlgElmEntrDets is a Consumption CDS View that provides data about "Details for Written off itmes" in SAP S/4HANA. It reads from 1 data source (I_WrittenOffPrjBlgElmEntrDets) and exposes 25 fields with key field ProjBillgElmntEntrItmUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_WrittenOffPrjBlgElmEntrDets WrittenOffPrjBlgElmEntrDets from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_CustomerMaterial_2 _CustomerMaterial _SalesDocument.SalesOrganization = _CustomerMaterial.SalesOrganization and _SalesDocument.DistributionChannel = _CustomerMaterial.DistributionChannel and _SalesDocument.SoldToParty = _CustomerMaterial.Customer and WrittenOffPrjBlgElmEntrDets.Material = _CustomerMaterial.Product
[0..1] I_WorkForcePersonMappings _WorkForcePerson WrittenOffPrjBlgElmEntrDets.PersonnelNumber = _WorkForcePerson.WorkforceAssignment
[0..1] I_UserContactCard _UserContactCard $projection.BusinessPartnerUUID = _UserContactCard.BusinessPartnerUUID and _UserContactCard.Person <> ''
[1..1] I_BllbleCtrlBillgCtrlCatAssgmt _BillableControl $projection.BillableControl = _BillableControl.BillableControl
[0..1] I_BillingControlCategoryText _BillgControlCategoryTxtBllble _BillgControlCategoryTxtBllble.BillingControlCategory = 'BILLABLE' and _BillgControlCategoryTxtBllble.Language = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CWRITOFFPRJDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Details for Written off itmes view
Search.searchable true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ProjBillgElmntEntrItmUUID I_WrittenOffPrjBlgElmEntrDets ProjBillgElmntEntrItmUUID PBE Entry UUID
ProjectBillingRequestUUID I_WrittenOffPrjBlgElmEntrDets ProjectBillingRequestUUID Proj Billg Req UUID
MaterialGroupName Material Group Name
MaterialName Expense Type / Activity Type
OpenAmountInTransCrcy Original Cost
WBSElement Work Package
WBSDescription Work Package Name
AccountingDocument Journal Entry/Item/Fiscal Year
LedgerGLLineItem Journal Entry Item
FiscalYear
DocumentCurrency I_WrittenOffPrjBlgElmEntrDets DocumentCurrency Document Currency
PersonFullName _WorkForcePerson PersonFullName Performed By
ServicesRenderedDate Service Date
WrittenOffQuantity I_WrittenOffPrjBlgElmEntrDets WrittenOffQuantity Written Off Quantity
WrittenOffAmtInTransacCrcy I_WrittenOffPrjBlgElmEntrDets WrittenOffAmtInTransacCrcy Written Off Cost
WrittenOffRevenueAmtInDocCrcy I_WrittenOffPrjBlgElmEntrDets WrittenOffRevenueAmtInDocCrcy Written Off Amount
TransactionCurrency I_WrittenOffPrjBlgElmEntrDets TransactionCurrency Transaction Currency
QuantityUnit I_WrittenOffPrjBlgElmEntrDets QuantityUnit Unit of measure
BusinessPartnerUUID
BillableControl I_WrittenOffPrjBlgElmEntrDets BillableControl Billable Control
ProjectInternalID I_WrittenOffPrjBlgElmEntrDets ProjectInternalID Project Def.
MaterialByCustomer _CustomerMaterial MaterialByCustomer Customer Material
MaterialDescriptionByCustomer _CustomerMaterial MaterialDescriptionByCustomer Customer Material Description
_UserContactCard _UserContactCard
_EnterpriseProject I_WrittenOffPrjBlgElmEntrDets _EnterpriseProject

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_WrittenOffPrjBlgElmEntrDets.
-- 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.
-- SQL view name: CWRITOFFPRJDET

CREATE VIEW C_WrittenOffPrjBlgElmEntrDets AS
SELECT
  WrittenOffPrjBlgElmEntrDets.ProjBillgElmntEntrItmUUID AS ProjBillgElmntEntrItmUUID,
  WrittenOffPrjBlgElmEntrDets.ProjectBillingRequestUUID AS ProjectBillingRequestUUID,
  WrittenOffPrjBlgElmEntrDets._ProjBillElementEntry._Material._MaterialGroup._Text[1:Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  WrittenOffPrjBlgElmEntrDets._ProjBillElementEntry._Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  WrittenOffPrjBlgElmEntrDets._ProjBillElementEntry.OriginalAmountInTransacCrcy AS OpenAmountInTransCrcy,
  WrittenOffPrjBlgElmEntrDets._ProjBillElementEntry._WBSElement.WBSElementExternalID AS WBSElement,
  WrittenOffPrjBlgElmEntrDets._ProjBillElementEntry._WBSElement.WBSDescription AS WBSDescription,
  WrittenOffPrjBlgElmEntrDets._PrjBlgElmEntrJrnlEntrLink.AccountingDocument AS AccountingDocument,
  WrittenOffPrjBlgElmEntrDets._PrjBlgElmEntrJrnlEntrLink.LedgerGLLineItem AS LedgerGLLineItem,
  WrittenOffPrjBlgElmEntrDets._PrjBlgElmEntrJrnlEntrLink.FiscalYear AS FiscalYear,
  WrittenOffPrjBlgElmEntrDets.DocumentCurrency AS DocumentCurrency,
  _WorkForcePerson.PersonFullName AS PersonFullName,
  WrittenOffPrjBlgElmEntrDets._ProjBillElementEntry.ServicesRenderedDate AS ServicesRenderedDate,
  WrittenOffPrjBlgElmEntrDets.WrittenOffQuantity AS WrittenOffQuantity,
  WrittenOffPrjBlgElmEntrDets.WrittenOffAmtInTransacCrcy AS WrittenOffAmtInTransacCrcy,
  WrittenOffPrjBlgElmEntrDets.WrittenOffRevenueAmtInDocCrcy AS WrittenOffRevenueAmtInDocCrcy,
  WrittenOffPrjBlgElmEntrDets.TransactionCurrency AS TransactionCurrency,
  WrittenOffPrjBlgElmEntrDets.QuantityUnit AS QuantityUnit,
  _WorkForcePerson._WorkForcePersonBPDetails.BusinessPartnerUUID AS BusinessPartnerUUID,
  WrittenOffPrjBlgElmEntrDets.BillableControl AS BillableControl,
  WrittenOffPrjBlgElmEntrDets.ProjectInternalID AS ProjectInternalID,
  _CustomerMaterial.MaterialByCustomer AS MaterialByCustomer,
  _CustomerMaterial.MaterialDescriptionByCustomer AS MaterialDescriptionByCustomer,
  WrittenOffPrjBlgElmEntrDets._EnterpriseProject AS _EnterpriseProject
FROM I_WrittenOffPrjBlgElmEntrDets AS WrittenOffPrjBlgElmEntrDets
LEFT OUTER JOIN I_CustomerMaterial_2 AS _CustomerMaterial ON _SalesDocument.SalesOrganization = _CustomerMaterial.SalesOrganization AND _SalesDocument.DistributionChannel = _CustomerMaterial.DistributionChannel AND _SalesDocument.SoldToParty = _CustomerMaterial.Customer AND WrittenOffPrjBlgElmEntrDets.Material = _CustomerMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_WorkForcePersonMappings AS _WorkForcePerson ON WrittenOffPrjBlgElmEntrDets.PersonnelNumber = _WorkForcePerson.WorkforceAssignment  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON BusinessPartnerUUID = _UserContactCard.BusinessPartnerUUID AND _UserContactCard.Person <> ''  -- association [0..1]
LEFT OUTER JOIN I_BllbleCtrlBillgCtrlCatAssgmt AS _BillableControl ON BillableControl = _BillableControl.BillableControl  -- association [1..1]
LEFT OUTER JOIN I_BillingControlCategoryText AS _BillgControlCategoryTxtBllble ON _BillgControlCategoryTxtBllble.BillingControlCategory = 'BILLABLE' AND _BillgControlCategoryTxtBllble.Language = $session.system_language  -- association [0..1]
;

Learn More