R_TrdgDocItemBasic

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_TrdgDocItemBasic.
-- 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_TrdgDocItemBasic AS
SELECT
  tkonn AS TradingDocument,
  tposn AS TradingDocumentItem,
  hkpstp AS TrdgDocItemCategory,
  cast( matnr as wb2_product preserving type ) AS Product,
  arktx AS TrdgDocItemText,
  cast( matkl as wb2_product_group preserving type ) AS ProductGroup,
  bwtar AS TrdgDocReltdDocItmValnType,
  werks AS Plant,
  lgort AS StorageLocation,
  charg AS Batch,
  spart AS OrganizationDivision,
  gsber AS BusinessArea,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  cast( erzet as wb2_created_at preserving type ) AS CreationTime,
  menge AS TrdgDocPurgQuantity,
  meins AS TrdgDocPurgQuantityUnit,
  kwmeng AS TrdgDocSalesQuantity,
  vrkme AS TrdgDocSlsQuantityUnit,
  umvkz AS TrdgDocSlsToBaseQtyNmrtr,
  cast( umvkn as wb2_sls_base_uom_dnmntr preserving type ) AS TrdgDocSlsToBaseQtyDnmntr,
  basis_meins AS BaseUnit,
  umrez_mm AS TrdgDocPurgToBaseQtyNmrtr,
  cast( umren_mm as wb2_purg_base_uom_dnmntr preserving type ) AS TrdgDocPurgToBaseQtyDnmntr,
  cast( bpumz_mm as wb2_purg_to_ordrqty_nmrtr preserving type ) AS TrdgDocPurgToOrdQtyNmrtr,
  cast( bpumn_mm as wb2_purg_to_ordrqty_dnmntr preserving type ) AS TrdgDocPurgToOrdQtyDnmntr,
  cast( bpumz_sd as wb2_sls_to_ordrqty_nmrtr preserving type ) AS TrdgDocSlsToOrdQtyNmrtr,
  cast( bpumn_sd as wb2_sls_to_ordrqty_dnmntr preserving type ) AS TrdgDocSlsToOrdQtyDnmntr,
  waers_mm AS TrdgDocPurgCurrency,
  sdwrs AS TrdgDocSalesCurrency,
  gewei AS TrdgDocSlsWeightUnit,
  cast( brgew as wb2_sls_gross_weight preserving type ) AS TrdgDocSlsGrossWeight,
  cast( ntgew as wb2_sls_net_weight preserving type ) AS TrdgDocSlsNetWeight,
  voleh AS TrdgDocSlsVolumeUnit,
  cast( volum as wb2_sales_item_volume preserving type ) AS TrdgDocSlsVolume,
  cast( brgew_mm as wb2_purg_gross_weight preserving type ) AS TrdgDocPurgGrossWeight,
  cast( ntgew_mm as wb2_purg_net_weight preserving type ) AS TrdgDocPurgNetWeight,
  cast( volum_mm as wb2_purg_volume preserving type ) AS TrdgDocPurgVolume,
  cast( kmein_sd as wb2_sls_price_unit preserving type ) AS TrdgDocSlsPriceUnit,
  bprme_mm AS TrdgDocPurgPriceUnit,
  peinh_mm AS TrdgDocPurgNetPriceQuantity,
  cast( kpein_sd as wb2_sls_net_price_qty preserving type ) AS TrdgDocSlsNetPriceQuantity,
  netpr_sd AS TrdgDocSalesNetPriceAmount,
  netpr_mm AS TrdgDocPurgNetPriceAmount,
  netwrt_sd AS TrdgDocSlsItemNetAmount,
  netwrt_mm AS TrdgDocPurgItemNetAmount,
  cast( netwrt_in_sdwrs as wb2_sls_netwrt preserving type ) AS TrdgDocSlsItmNetAmtInSlsCrcy,
  netwrt_in_waers AS TrdgDocPurgItmNetAmtInPOCrcy,
  cast( kzwi1 as wb2_purg_subtotal1_amt preserving type ) AS TrdgDocPurgSubtotal1Amount,
  cast( kzwi2 as wb2_purg_subtotal2_amt preserving type ) AS TrdgDocPurgSubtotal2Amount,
  cast( kzwi3 as wb2_purg_subtotal3_amt preserving type ) AS TrdgDocPurgSubtotal3Amount,
  cast( kzwi4 as wb2_purg_subtotal4_amt preserving type ) AS TrdgDocPurgSubtotal4Amount,
  cast( kzwi5 as wb2_purg_subtotal5_amt preserving type ) AS TrdgDocPurgSubtotal5Amount,
  cast( kzwi6 as wb2_purg_subtotal6_amt preserving type ) AS TrdgDocPurgSubtotal6Amount,
  cast( kzwi1d as wb2_sls_subtotal1_amt preserving type ) AS TrdgDocSlsSubtotal1Amount,
  cast( kzwi2d as wb2_sls_subtotal2_amt preserving type ) AS TrdgDocSlsSubtotal2Amount,
  cast( kzwi3d as wb2_sls_subtotal3_amt preserving type ) AS TrdgDocSlsSubtotal3Amount,
  cast( kzwi4d as wb2_sls_subtotal4_amt preserving type ) AS TrdgDocSlsSubtotal4Amount,
  cast( kzwi5d as wb2_sls_subtotal5_amt preserving type ) AS TrdgDocSlsSubtotal5Amount,
  cast( kzwi6d as wb2_sls_subtotal6_amt preserving type ) AS TrdgDocSlsSubtotal6Amount,
  cast( uebtk_sd as wb2_sls_unlmtd_allwd preserving type ) AS SlsUnlmtdOvrdelivIsAllwd,
  cast( uebto_sd as wb2_sls_ovrdeliv_tol preserving type ) AS SlsOvrdelivTolLmtRatioInPct,
  untto_sd AS SlsUndrdelivTolLmtRatioInPct,
  cast( uebtk_mm as wb2_purg_unlmtd_allwd preserving type ) AS PurgUnlmtdOvrdelivIsAllwd,
  cast( uebto_mm as wb2_purg_ovrdeliv_tol preserving type ) AS PurgOvrdelivTolLmtRatioInPct,
  cast( untto_mm as wb2_purg_undrdeliv_tol preserving type ) AS PurgUndrdelivTolLmtRatioInPct,
  abgru AS SalesDocumentRjcnReason,
  prodh AS ProductHierarchyNode,
  cast( kdmat as wb2_product_cust preserving type ) AS ProductUsedByCustomer,
  cast( taxm1 as wb2_product_tax_classfctn_1 preserving type ) AS ProductTaxClassification1,
  cast( taxm2 as wb2_product_tax_classfctn_2 preserving type ) AS ProductTaxClassification2,
  cast( taxm3 as wb2_product_tax_classfctn_3 preserving type ) AS ProductTaxClassification3,
  cast( taxm4 as wb2_product_tax_classfctn_4 preserving type ) AS ProductTaxClassification4,
  cast( taxm5 as wb2_product_tax_classfctn_5 preserving type ) AS ProductTaxClassification5,
  cast( taxm6 as wb2_product_tax_classfctn_6 preserving type ) AS ProductTaxClassification6,
  cast( taxm7 as wb2_product_tax_classfctn_7 preserving type ) AS ProductTaxClassification7,
  cast( taxm8 as wb2_product_tax_classfctn_8 preserving type ) AS ProductTaxClassification8,
  cast( taxm9 as wb2_product_tax_classfctn_9 preserving type ) AS ProductTaxClassification9,
  ean11 AS InternationalArticleNumber,
  prctr AS ProfitCenter,
  kostl AS CostCenter,
  cast( mvgr1 as wb2_sales_product_group1 preserving type ) AS SalesSpcfcProductGroup1,
  cast( mvgr2 as wb2_sales_product_group2 preserving type ) AS SalesSpcfcProductGroup2,
  cast( mvgr3 as wb2_sales_product_group3 preserving type ) AS SalesSpcfcProductGroup3,
  cast( mvgr4 as wb2_sales_product_group4 preserving type ) AS SalesSpcfcProductGroup4,
  cast( mvgr5 as wb2_sales_product_group5 preserving type ) AS SalesSpcfcProductGroup5,
  faksp_sd AS ItemBillingBlockReason,
  antlf_sd AS MaxNmbrOfPartialDelivery,
  kztlf_sd AS PartialDeliveryIsAllowed,
  cast( vstel_sd as wb2_sls_shipg_point preserving type ) AS TrdgDocSlsShippingPoint,
  cast( route_mm as wb2_purg_route preserving type ) AS TradingDocumentPurchasingRoute,
  cast( route_sd as wb2_route_sd preserving type ) AS TradingDocumentSalesRoute,
  cast( vsbed_mm as wb2_purg_shipg_cndn preserving type ) AS TrdgDocPurgShippingCondition,
  cast( vstel_mm as wb2_purg_shipg_point preserving type ) AS TrdgDocPurgShippingPoint,
  mwskz_mm AS TrdgDocPurgTaxCode,
  bwtty_mm AS ValuationCategory,
  cast( pstyp_mm as wb2_purg_doc_itm_cat preserving type ) AS PurchasingDocumentItemCategory,
  knttp_mm AS AccountAssignmentCategory,
  lewed_mm AS GoodsReceiptLatestCreationDate,
  cuobj_ch AS BatchClassification,
  cast( wbhd_tposn as wb2_bus_data_item preserving type ) AS TradingDocumentBusinessItem,
  dummy_wbhi_incl_eew_ps AS TrdgDocItemIsExtended,
  loekz AS TrdgDocItemIsDeleted,
  cast( portfolio as wb2_internal_portfolio_no preserving type ) AS TrdgPortfolioInternalID,
  portfolio_date AS TrdgDocItmPrtfloDetnDate,
  tkonn_from AS TrdgDocRefDocument,
  tposn_from AS TrdgDocRefDocItem,
  cast(tctyp_from as wb2_ref_doc_type preserving type ) AS TrdgDocReferenceDocumentType,
  tkonn_from_2 AS TrdgDocAddlRefDocument,
  tposn_from_2 AS TrdgDocAddlRefDocItem,
  cast( tctyp_from_2 as wb2_addl_ref_doc_type preserving type ) AS TrdgDocAddlRefDocumentType,
  scenario AS TrdgDocBusinessScenario,
  assoc_group AS TrdgDocAssociationGroup,
  cast( idnlf as wb2_suplr_prod preserving type ) AS SupplierProductID,
  cast( matwa as wb2_reqd_product preserving type ) AS TrdgDocOriglReqdProd,
  uepos AS TradingDocumentHigherLevelItem,
  wuvprs AS TrdgDocPrcDetnIsIncomplete,
  cast( kmpmg as wb2_purg_bom_itm_qty preserving type ) AS TrdgDocPurgBOMItmQty,
  cast( kmpmg_sd as wb2_sls_bom_itm_qty preserving type ) AS TrdgDocSlsBOMItmQty,
  fmeng AS QuantityIsFixed,
  stdat AS TrdgDocBOMKeyDate,
  stlty AS BillOfMaterialCategory,
  stkey AS BillOfMaterialVariantUsage,
  cast( pmatn as wb2_prcg_ref_product preserving type ) AS TrdgDocPrcgRefProduct,
  cast( vkaus as wb2_prod_usage_ind preserving type ) AS TrdgDocProdUsgeCat,
  cast( effwr_sd as wb2_sls_itm_effctv_amt preserving type ) AS TrdgDocSlsItmEffctvAmount,
  cast( effwr_mm as wb2_purg_itm_effctv_amt preserving type ) AS TrdgDocPurgItmEffctvAmount,
  cast( sktof_sd as wb2_sls_cash_disc preserving type ) AS TrdgDocSlsIsCshDiscGrntd,
  cast( sktof_mm as wb2_purg_cash_disc preserving type ) AS TrdgDocPurgIsCshDiscGrntd,
  pred_number AS TrdgDocPredecessorDocument,
  pred_item_number AS TrdgDocPredecessorItem,
  cast( pred_doc_type as wb2_precdg_doc_type preserving type ) AS TrdgDocPrdcssrDocumentType,
  cast( mwsbp_mm as wb2_purg_tax_amt preserving type ) AS TrdgDocPurgTaxAmount,
  cast( mwsbp_sd as wb2_sls_tax_amt preserving type ) AS TrdgDocSlsTaxAmount,
  hedging_relevant AS TrdgDocHdggRlvt,
  cast(cond_con_alg as wb2_cndn_cnsldtn_cat preserving type) AS TrdgDocCndnCnsldtnCat,
  consolidated AS TrdgDocCndnIsCnsldtd,
  ccomp AS TrdgDocSTOPostingLogic,
  sett_mode AS TrdgDocSettlementMode,
  reslo AS IssuingStorageLocation,
  cast( txjcd_mm as wb2_purg_tax_jx preserving type ) AS TrdgDocPurgTaxJurisdiction,
  abfor AS PaymentGuaranteeForm,
  dpamt_item AS DownPaymentAmount,
  brtwr_mm AS SupplierTotalGrossAmount,
  bom_profile AS TrdgDocBOMProfile,
  alt_bom AS AlternativeBillOfMaterial,
  cast( trmrisk_rel_mm as wb2_purg_rsk_relevancy preserving type ) AS TrdgDocPurgRiskRelevancy,
  cast( trmrisk_rel_sd as wb2_sls_rsk_relevancy preserving type ) AS TrdgDocSlsRiskRelevancy,
  cuobj_sd AS TrdgDocSlsClfnObjInternalID,
  cuobj_mm AS TrdgDocPurgClfnObjInternalID,
  groes AS TrdgDocProdSizeOrDimnDesc,
  cast( complete as wb2_document_complete preserving type ) AS TrdgDocItemIsComplete,
  cast( aufnr as wb2_internal_order preserving type ) AS TradingDocumentInternalOrder,
  block_code AS TrdgDocItemBlockCode,
  cast( tax_country_mm as wb2_purg_tax_ctryreg preserving type ) AS TrdgDocPurgTaxCountry,
  cast( txdat_mm as wb2_purg_tax_date preserving type ) AS TrdgDocPurgTaxDate,
  cast( waers_purch as wb2_purg_currency_key preserving type ) AS TrdgDocCurrency,
  _TrdgDocRefDocument.ControllingArea AS ControllingArea,
  cast( stlnr as wb2_bill_of_material preserving type) AS TrdgDocBillOfMaterial,
  cast( posex as wb2_purchase_order_item preserving type) AS TrdgDocPurchaseOrderItem,
  cast( commodity as wb2_commodity_definition preserving type) AS TrdgDocCommodityDefinition,
  cast( item_relevancy as wb2_is_item_relevant preserving type) AS TrdgDocIsItemRelevant
FROM wbhi
LEFT OUTER JOIN R_TrdgDocItemCategory AS _TrdgDocItemCategory ON TrdgDocItemCategory = _TrdgDocItemCategory.TrdgDocItemCategory  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Plant = _Batch.Plant AND Product = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TrdgDocPurgQuantityUnit ON TrdgDocPurgQuantityUnit = _TrdgDocPurgQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TrdgDocSlsQuantityUnit ON TrdgDocSlsQuantityUnit = _TrdgDocSlsQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TrdgDocSlsWeightUnit ON TrdgDocSlsWeightUnit = _TrdgDocSlsWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TrdgDocSlsVolumeUnit ON TrdgDocSlsVolumeUnit = _TrdgDocSlsVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON OrganizationDivision = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _ProductGroup ON ProductGroup = _ProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _SalesDocumentRjcnReason ON SalesDocumentRjcnReason = _SalesDocumentRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN I_ProductHierarchyNode AS _ProductHierarchyNode ON ProductHierarchyNode = _ProductHierarchyNode.ProductHierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_SalesSpcfcProductGroup1 AS _SalesSpcfcProductGroup1 ON SalesSpcfcProductGroup1 = _SalesSpcfcProductGroup1.SalesSpcfcProductGroup1  -- association [0..1]
LEFT OUTER JOIN I_SalesSpcfcProductGroup2 AS _SalesSpcfcProductGroup2 ON SalesSpcfcProductGroup2 = _SalesSpcfcProductGroup2.SalesSpcfcProductGroup2  -- association [0..1]
LEFT OUTER JOIN I_SalesSpcfcProductGroup3 AS _SalesSpcfcProductGroup3 ON SalesSpcfcProductGroup3 = _SalesSpcfcProductGroup3.SalesSpcfcProductGroup3  -- association [0..1]
LEFT OUTER JOIN I_SalesSpcfcProductGroup4 AS _SalesSpcfcProductGroup4 ON SalesSpcfcProductGroup4 = _SalesSpcfcProductGroup4.SalesSpcfcProductGroup4  -- association [0..1]
LEFT OUTER JOIN I_SalesSpcfcProductGroup5 AS _SalesSpcfcProductGroup5 ON SalesSpcfcProductGroup5 = _SalesSpcfcProductGroup5.SalesSpcfcProductGroup5  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _ItemBillingBlockReason ON ItemBillingBlockReason = _ItemBillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _TrdgDocSlsShippingPoint ON TrdgDocSlsShippingPoint = _TrdgDocSlsShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_Route AS _TradingDocumentSalesRoute ON TradingDocumentSalesRoute = _TradingDocumentSalesRoute.Route  -- association [0..1]
LEFT OUTER JOIN I_ShippingCondition AS _TrdgDocPurgShipgCondition ON TrdgDocPurgShippingCondition = _TrdgDocPurgShipgCondition.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _TrdgDocPurgShippingPoint ON TrdgDocPurgShippingPoint = _TrdgDocPurgShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchasingDocumentItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocHeaderBasic AS _TrdgDocRefDocument ON TrdgDocRefDocument = _TrdgDocRefDocument.TradingDocument  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocHeaderBasic AS _TrdgDocAddlRefDocument ON TrdgDocAddlRefDocument = _TrdgDocAddlRefDocument.TradingDocument  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocItemBasic AS _TrdgDocRefDocItem ON TrdgDocRefDocument = _TrdgDocRefDocItem.TradingDocument AND TrdgDocRefDocItem = _TrdgDocRefDocItem.TradingDocumentItem  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocItemBasic AS _TrdgDocAddlRefDocItem ON TrdgDocAddlRefDocument = _TrdgDocAddlRefDocItem.TradingDocument AND TrdgDocAddlRefDocItem = _TrdgDocAddlRefDocItem.TradingDocumentItem  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocType AS _TrdgDocRefDocumentType ON TrdgDocReferenceDocumentType = _TrdgDocRefDocumentType.TradingDocumentType  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocType AS _TrdgDocAddlRefDocumentType ON TrdgDocAddlRefDocumentType = _TrdgDocAddlRefDocumentType.TradingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Product AS _OriginallyRequestedProduct ON TrdgDocOriglReqdProd = _OriginallyRequestedProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TrdgDocPurgCurrency ON TrdgDocPurgCurrency = _TrdgDocPurgCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocCndnCnsldtnCat AS _TrdgDocCndnCnsldtnCat ON TrdgDocCndnCnsldtnCat = _TrdgDocCndnCnsldtnCat.TrdgDocCndnCnsldtnCat  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocIsHdggRlvt AS _TrdgDocIsHdggRlvt ON TrdgDocHdggRlvt = _TrdgDocIsHdggRlvt.TrdgDocIsHdggRlvt  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocPrcDetnIsIncmplt AS _TrdgDocPrcDetnIsIncmplt ON TrdgDocPrcDetnIsIncomplete = _TrdgDocPrcDetnIsIncmplt.TrdgDocPrcDetnIsIncomplete  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocItemBlockCode AS _TrdgDocItemBlockCode ON TrdgDocItemBlockCode = _TrdgDocItemBlockCode.TrdgDocItemBlockCode  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocPurgRskRelevancy AS _TrdgDocPurgRskRelevancy ON TrdgDocPurgRiskRelevancy = _TrdgDocPurgRskRelevancy.TrdgDocPurgRiskRelevancy  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocSettlementMode AS _TrdgDocSettlementMode ON TrdgDocSettlementMode = _TrdgDocSettlementMode.TrdgDocSettlementMode  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocPrdcssrDocType AS _TrdgDocPrdcssrDocType ON TrdgDocPrdcssrDocumentType = _TrdgDocPrdcssrDocType.TrdgDocPrdcssrDocumentType  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocIsComplete AS _TrdgDocItemIsComplete ON TrdgDocItemIsComplete = _TrdgDocItemIsComplete.TrdgDocIsComplete  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND CreationDate <= _CostCenter.ValidityEndDate  -- association [0..1]
;