I_WhereUsdPrftCtrSlsOrdCat

DDL: I_WHEREUSDPRFTCTRSLSORDCAT SQL: IWUPFSOC2 Type: view BASIC
2 Fields 1 Data Sources

Where-Used Profit Center: SO Category

I_WhereUsdPrftCtrSlsOrdCat is a Basic CDS View that provides data about "Where-Used Profit Center: SO Category" in SAP S/4HANA. It reads from 1 data source (tvak) and exposes 2 fields with key field SalesDocumentType.

Data Sources (1)

SourceAliasJoin Type
tvak tvak from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IWUPFSOC2 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
EndUserText.label Where-Used Profit Center: SO Category view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY SalesDocumentType auart Sales Doc. Type
SDDocumentCategory vbtyp TSW Det.Doc typ

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 I_WhereUsdPrftCtrSlsOrdCat.
-- 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: IWUPFSOC2

CREATE VIEW I_WhereUsdPrftCtrSlsOrdCat AS
SELECT
  auart AS SalesDocumentType,
  vbtyp AS SDDocumentCategory
FROM tvak
;

Learn More