I_BPCustSalesTextGeneralProc

DDL: I_BPCUSTSALESTEXTGENERALPROC Type: view_entity BASIC
18 Fields 1 Data Sources 2 Associations

BP Customer Sales Desc General Proc Data

I_BPCustSalesTextGeneralProc is a Basic CDS View that provides data about "BP Customer Sales Desc General Proc Data" in SAP S/4HANA. It reads from 1 data source (knvv_stxh_prc) and exposes 18 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, ApplicationTextObjectType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
knvv_stxh_prc knvv_stxh_prc from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BPCustomerProcess _Customer knvv_stxh_prc.process_id = _Customer.MasterDataChangeProcess and knvv_stxh_prc.process_step_no = _Customer.MDChgProcessStep and knvv_stxh_prc.source_system = _Customer.MDChgProcessSrceSystem and knvv_stxh_prc.source_id = _Customer.MDChgProcessSrceObject
[0..1] I_BPCustomerSalesAreaProcess _CustomerSales $projection.MasterDataChangeProcess = _CustomerSales.MasterDataChangeProcess and $projection.MDChgProcessStep = _CustomerSales.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _CustomerSales.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _CustomerSales.MDChgProcessSrceObject and $projection.BPAssignmentID = _CustomerSales.BPAssignmentID and $projection.SalesOrganization = _CustomerSales.SalesOrganization and $projection.DistributionChannel = _CustomerSales.DistributionChannel and $projection.Division = _CustomerSales.Division

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Sales Desc General Proc Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess process_id Process Instance ID
KEY MDChgProcessStep process_step_no Step Number
KEY MDChgProcessSrceSystem source_system Source System
KEY MDChgProcessSrceObject source_id UUID
KEY ApplicationTextObjectType tdobject Text object
KEY TextObjectKey tdname Text Name
KEY LongTextID tdid Text ID Header
KEY Language tdspras Language
KEY SalesOrganization vkorg SD Sales Org.
KEY DistributionChannel vtweg RefDistCh-Cust/Mat.
KEY Division spart Source supplier
BPAssignmentID assignment_id Assignment ID
Customer kunnr Stock customer
MDChgProcessSourceModified source_modified Modified
MDChgProcessSourceModifBinary source_modification_blip Modification
MDChgProcSrceLastChgdDateTime source_recency Last Changed On
_Customer _Customer
_CustomerSales _CustomerSales

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_BPCustSalesTextGeneralProc.
-- 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 I_BPCustSalesTextGeneralProc AS
SELECT
  process_id AS MasterDataChangeProcess,
  process_step_no AS MDChgProcessStep,
  source_system AS MDChgProcessSrceSystem,
  source_id AS MDChgProcessSrceObject,
  tdobject AS ApplicationTextObjectType,
  tdname AS TextObjectKey,
  tdid AS LongTextID,
  tdspras AS Language,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  assignment_id AS BPAssignmentID,
  kunnr AS Customer,
  source_modified AS MDChgProcessSourceModified,
  source_modification_blip AS MDChgProcessSourceModifBinary,
  source_recency AS MDChgProcSrceLastChgdDateTime
FROM knvv_stxh_prc
LEFT OUTER JOIN I_BPCustomerProcess AS _Customer ON knvv_stxh_prc.process_id = _Customer.MasterDataChangeProcess AND knvv_stxh_prc.process_step_no = _Customer.MDChgProcessStep AND knvv_stxh_prc.source_system = _Customer.MDChgProcessSrceSystem AND knvv_stxh_prc.source_id = _Customer.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN I_BPCustomerSalesAreaProcess AS _CustomerSales ON MasterDataChangeProcess = _CustomerSales.MasterDataChangeProcess AND MDChgProcessStep = _CustomerSales.MDChgProcessStep AND MDChgProcessSrceSystem = _CustomerSales.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _CustomerSales.MDChgProcessSrceObject AND BPAssignmentID = _CustomerSales.BPAssignmentID AND SalesOrganization = _CustomerSales.SalesOrganization AND DistributionChannel = _CustomerSales.DistributionChannel AND Division = _CustomerSales.Division  -- association [0..1]
;

Learn More