P_SrvcTmplProdSlsArea

DDL: P_SRVCTMPLPRODSLSAREA SQL: PTMPLPRODSLSAREA Type: view CONSUMPTION
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.

Associations (1)

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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PTMPLPRODSLSAREA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK 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
ClientHandling.algorithm #SESSION_VARIABLE 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 _ParentServiceDocItem ServiceDocumentItem Service Document
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.
-- SQL view name: PTMPLPRODSLSAREA

CREATE VIEW P_SrvcTmplProdSlsArea AS
SELECT
  ServiceObjectType,
  ServiceDocument,
  ServiceDocumentItem,
  _ProdSalesArea.SalesOrganization AS SalesOrganization,
  _ProdSalesArea.DistributionChannel AS DistributionChannel,
  ServiceDocumentType,
  OriginallyRequestedProduct,
  ServiceDocumentItemQuantity,
  ServiceDocItemQuantityUnit,
  BillableControl,
  ServiceDocItemCategory,
  _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