P_AutomXtrctnSalesOrderType

DDL: P_AUTOMXTRCTNSALESORDERTYPE Type: view COMPOSITE
10 Fields 1 Data Sources 1 Associations

P_AutomXtrctnSalesOrderType is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentType) and exposes 10 fields with key field SalesOrderType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentType I_SalesDocumentType from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SalesDocumentTypeText _Text $projection.SalesOrderType = _Text.SalesDocumentType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PAXTSLSORTY view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #S view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderType Sales Doc. Type
SDDocumentCategory SDDocumentCategory Document Cat.
SalesDocumentProcessingType SalesDocumentProcessingType Indicator
NumberRangeForIntIDAssignment NumberRangeForIntIDAssignment Number Range
NumberRangeForExtIDAssignment NumberRangeForExtIDAssignment Number Range
MandatoryReferenceSDDocCat MandatoryReferenceSDDocCat Reference Mand.
IsLocked IsLocked Posting Block
RetsMgmtIsActive RetsMgmtIsActive Adv. Returns
TradeComplianceIsActive TradeComplianceIsActive Trade Compliance
_Text _Text

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_AutomXtrctnSalesOrderType.
-- 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_AutomXtrctnSalesOrderType AS
SELECT
  cast( SalesDocumentType as sales_order_type preserving type ) AS SalesOrderType,
  SDDocumentCategory,
  SalesDocumentProcessingType,
  NumberRangeForIntIDAssignment,
  NumberRangeForExtIDAssignment,
  MandatoryReferenceSDDocCat,
  IsLocked,
  RetsMgmtIsActive,
  TradeComplianceIsActive
FROM I_SalesDocumentType
LEFT OUTER JOIN I_SalesDocumentTypeText AS _Text ON SalesOrderType = _Text.SalesDocumentType  -- association [0..*]
;

Learn More