I_SalesOrderInInvcgNotTransfd

DDL: I_SALESORDERININVCGNOTTRANSFD SQL: ISOFISSUEIN01 Type: view COMPOSITE
16 Fields 1 Data Sources

SOFM Not Transferred Sales Orders In Invoice

I_SalesOrderInInvcgNotTransfd is a Composite CDS View that provides data about "SOFM Not Transferred Sales Orders In Invoice" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentBasic) and exposes 16 fields with key fields SalesOrder, BillingDocument.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentBasic SOH inner

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label SOFM Not Transferred Sales Orders In Invoice view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISOFISSUEIN01 view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder
KEY BillingDocument bdi BillingDocument SD Document
SalesOrganization I_SalesDocumentBasic SalesOrganization Sales Organization
DistributionChannel I_SalesDocumentBasic DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_SalesDocumentBasic OrganizationDivision Org. Division
RequestedDeliveryDate I_SalesDocumentBasic RequestedDeliveryDate Requested Delivery Date
OverallSDProcessStatus I_SalesDocumentBasic OverallSDProcessStatus
SalesDocumentDate I_SalesDocumentBasic SalesDocumentDate Document Date
SalesGroup I_SalesDocumentBasic SalesGroup Sales Group
SalesOffice I_SalesDocumentBasic SalesOffice Sales Office
SoldToParty I_SalesDocumentBasic SoldToParty Sold-to Party
PurchaseOrderByCustomer
SalesOrderType I_SalesDocumentBasic SalesDocumentType Sales Doc. Type
AccountingPostingStatus
Issue
IssueCategory

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_SalesOrderInInvcgNotTransfd.
-- 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: ISOFISSUEIN01

CREATE VIEW I_SalesOrderInInvcgNotTransfd AS
SELECT
  cast(SOH.SalesDocument as vdm_sales_order) AS SalesOrder,
  bdi.BillingDocument AS BillingDocument,
  SOH.SalesOrganization AS SalesOrganization,
  SOH.DistributionChannel AS DistributionChannel,
  SOH.OrganizationDivision AS OrganizationDivision,
  SOH.RequestedDeliveryDate AS RequestedDeliveryDate,
  SOH.OverallSDProcessStatus AS OverallSDProcessStatus,
  SOH.SalesDocumentDate AS SalesDocumentDate,
  SOH.SalesGroup AS SalesGroup,
  SOH.SalesOffice AS SalesOffice,
  SOH.SoldToParty AS SoldToParty,
  SOH.SalesDocumentType AS SalesOrderType,
  cast('IN01'as issue_sof) AS Issue,
  cast('30_IN' as issue_cat) AS IssueCategory
INNER JOIN I_SalesDocumentBasic AS SOH ON /* join condition not captured in parsed metadata */
;

Learn More