P_SrvcTmplProdSlsArea

DDL: P_SRVCTMPLPRODSLSAREA Type: view_entity CONSUMPTION Package: CRMS4_SERV_FIORI_UI
21 Fields 1 Associations

Sales Areas For Products in Service Order Template

P_SrvcTmplProdSlsArea is a Consumption CDS View that provides data about "Sales Areas For Products in Service Order Template" in SAP S/4HANA. It has 1 association to related views. Part of development package CRMS4_SERV_FIORI_UI.

Associations (1)

CardinalityTargetAliasCondition
[1..*] P_SrvcProdComDistrChnl _ProdSalesArea $projection.Product = _ProdSalesArea.Product

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Sales Areas For Products in Service Order Template view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceDocument ServiceDocument Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Service Document
KEY SalesOrganization _ProdSalesArea SalesOrganization Sales Organization
KEY DistributionChannel _ProdSalesArea DistributionChannel RefDistCh-Cust/Mat.
ServiceDocumentType ServiceDocumentType Transaction Type
OriginallyRequestedProduct OriginallyRequestedProduct
ServiceDocumentItemQuantity ServiceDocumentItemQuantity
ServiceDocItemQuantityUnit ServiceDocItemQuantityUnit
BillableControl BillableControl Billable Control
ServiceDocItemCategory ServiceDocItemCategory
ParentServiceDocumentItem
Product I_ServiceDocumentItemEnhcd Product Product Sold
ResponsibleEmployee ResponsibleEmployee Employee Resp.
ServiceOrganization ServiceOrganization
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID

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 P_SrvcTmplProdSlsArea.
-- 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 P_SrvcTmplProdSlsArea AS
SELECT
  ServiceObjectType,
  ServiceDocument,
  ServiceDocumentItem,
  _ProdSalesArea.SalesOrganization AS SalesOrganization,
  _ProdSalesArea.DistributionChannel AS DistributionChannel,
  ServiceDocumentType,
  OriginallyRequestedProduct,
  ServiceDocumentItemQuantity,
  ServiceDocItemQuantityUnit,
  BillableControl,
  ServiceDocItemCategory,
  I_ServiceDocumentItemEnhcd._ParentServiceDocItem.ServiceDocumentItem AS ParentServiceDocumentItem,
  I_ServiceDocumentItemEnhcd.Product AS Product,
  ResponsibleEmployee,
  ServiceOrganization,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID
LEFT OUTER JOIN P_SrvcProdComDistrChnl AS _ProdSalesArea ON Product = _ProdSalesArea.Product  -- association [1..*]
;

Learn More