C_ServiceEntrySheetItemWD

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_ServiceEntrySheetItemWD.
-- 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: CSRVCENTRSH000WD

CREATE VIEW C_ServiceEntrySheetItemWD AS
SELECT
  Document.ServiceEntrySheet AS ServiceEntrySheet,
  Document.ServiceEntrySheetItem AS ServiceEntrySheetItem,
  Document.PurchaseOrder AS PurchaseOrder,
  Document.PurchaseOrderItem AS PurchaseOrderItem,
  Document.IsDeleted AS IsDeleted,
  Document.Service AS Service,
  Document.ServiceEntrySheetItemDesc AS ServiceEntrySheetItemDesc,
  Document.ServicePerformer AS ServicePerformer,
  Document.ServicePerformerName AS ServicePerformerName,
  cast('' as contactcardformattedaddress) AS FormattedAddress,
  cast('' as ad_addrnum ) AS AddressID,
  Document.InternationalPhoneNumber AS InternationalPhoneNumber,
  Document.MobilePhoneNumber AS MobilePhoneNumber,
  Document.EmailAddress AS EmailAddress,
  Document.AccountAssignmentCategory AS AccountAssignmentCategory,
  Document.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  Document.WorkItem AS WorkItem,
  Document.ConfirmedQuantity AS ConfirmedQuantity,
  Document.QuantityUnit AS QuantityUnit,
  Document.ServicePerformanceDate AS ServicePerformanceDate,
  Document.ServicePerformanceEndDate AS ServicePerformanceEndDate,
  Document.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  Document.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  Document.OriginObject AS OriginObject,
  Document.Currency AS Currency,
  Document.OrderPriceUnit AS OrderPriceUnit,
  Document.NetPriceAmount AS NetPriceAmount,
  Document.NetPriceQuantity AS NetPriceQuantity,
  Document.MaterialGroup AS MaterialGroup,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  Document.CreationDateTime AS CreationDateTime,
  Document.CreatedByUser AS CreatedByUser,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.LastChangeUser AS LastChangeUser,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.Supplier AS Supplier,
  Document.PurchaseOrderItemMaterialGroup AS PurchaseOrderItemMaterialGroup,
  Document.PurchaseOrderItemQuantity AS PurchaseOrderItemQuantity,
  Document.PurchaseOrderItemQuantityUnit AS PurchaseOrderItemQuantityUnit,
  Document.PurchaseOrderItemNetAmount AS PurchaseOrderItemNetAmount,
  Document.PurchaseOrderCurrency AS PurchaseOrderCurrency,
  Document.Plant AS Plant,
  Document.PurchaseContract AS PurchaseContract,
  Document.PurchaseContractItem AS PurchaseContractItem,
  Document.PurchaseOrderItemCompanyCode AS PurchaseOrderItemCompanyCode,
  Document.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  Document.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  PurgDocExternalItemCategory,
  Document.PurchaseOrderItemCategoryName AS PurchaseOrderItemCategoryName,
  Document.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  Document.TotalConfirmedQuantity AS TotalConfirmedQuantity,
  Document.OpenQuantity AS OpenQuantity,
  Document.NetAmount AS NetAmount,
  Document.OpenAmountInPurchaseOrderCrcy AS OpenAmountInPurchaseOrderCrcy,
  Document.SESNetAmountInclSalesTax AS SESNetAmountInclSalesTax,
  Document.OpenAmountInTransCrcy AS OpenAmountInTransCrcy,
  Document.PurgDocPriceDate AS PurgDocPriceDate,
  Document.SESItemIsFinalEntry AS SESItemIsFinalEntry,
  Document.MaterialType AS MaterialType,
  Document.ConsumptionPosting AS ConsumptionPosting,
  Document.InventorySpecialStockType AS InventorySpecialStockType,
  Document.ProductType AS ProductType,
  Document.ProductTypeName AS ProductTypeName,
  Document.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  Document.TaxCode AS TaxCode,
  Document.TaxJurisdiction AS TaxJurisdiction,
  Document.TaxDeterminationDate AS TaxDeterminationDate,
  Document.TaxCountry AS TaxCountry,
  Document.TaxCalculationProcedure AS TaxCalculationProcedure,
  Document._Material AS _Material,
  Document._MaterialText AS _MaterialText,
  Document._MaterialGroupText AS _MaterialGroupText,
  Document._AccountAssignmentCategory AS _AccountAssignmentCategory,
  Document._AcctAssignmentCategoryText AS _AcctAssignmentCategoryText,
  Document._SrvcEntrShtAcctAssgmtCat AS _SrvcEntrShtAcctAssgmtCat,
  Document._DocumentCurrency AS _DocumentCurrency,
  Document._UnitValueHelp AS _UnitValueHelp,
  Document._UnitText AS _UnitText,
  Document._PurOrdUnitOfMsrValHelp AS _PurOrdUnitOfMsrValHelp,
  Document._PurOrdUnitOfMsrTxt AS _PurOrdUnitOfMsrTxt,
  Document._ServicePerformerValueHelp AS _ServicePerformerValueHelp,
  Document._PurchaseOrderItemVH AS _PurchaseOrderItemVH,
  Document._WorkItemText AS _WorkItemText,
  Document._MltplAcctAssgmtDistr AS _MltplAcctAssgmtDistr,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  cast( '' as abap.char( 1 ) ) AS PriceChangeInSESIsAllowed,
  Document.PricingDocument AS PricingDocument
FROM I_ServiceEntrySheetItemTP AS Document
LEFT OUTER JOIN C_ServiceEntrySheetWD AS _ServiceEntrySheet ON _ServiceEntrySheet.ServiceEntrySheet = ServiceEntrySheet  -- association [1..1]
LEFT OUTER JOIN C_SESAccountAssignmentWD AS _AccountAssignment ON _AccountAssignment.ServiceEntrySheet = ServiceEntrySheet AND _AccountAssignment.ServiceEntrySheetItem = ServiceEntrySheetItem  -- association [1..*]
LEFT OUTER JOIN C_SESPricingElementTP AS _SESPricingElementTP ON _SESPricingElementTP.ServiceEntrySheet = ServiceEntrySheet AND _SESPricingElementTP.ServiceEntrySheetItem = ServiceEntrySheetItem  -- association [1..*]
LEFT OUTER JOIN C_MM_TaxCodeValueHelp AS _TaxCode ON _TaxCode.TaxCode = TaxCode AND _TaxCode.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN C_SESTaxJurisdictionValueHelp AS _TaxJurisdictionValueHelp ON _TaxJurisdictionValueHelp.TaxJurisdiction = TaxJurisdiction AND _TaxJurisdictionValueHelp.CompanyCode = PurchaseOrderItemCompanyCode  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _CountryText ON _CountryText.Country = TaxCountry AND _CountryText.Language = $session.system_language  -- association [0..1]
;