C_Customer360ApprovalBusDoc

DDL: C_CUSTOMER360APPROVALBUSDOC SQL: CUST360BDAPRVL Type: view_entity CONSUMPTION
19 Fields 2 Data Sources

Customer 360 business doc approvals

C_Customer360ApprovalBusDoc is a Consumption CDS View that provides data about "Customer 360 business doc approvals" in SAP S/4HANA. It reads from 2 data sources (I_Customer360BusDocSetting, I_SalesDocument) and exposes 19 fields with key fields SoldToParty, SalesDocument, SalesDocumentType.

Data Sources (2)

SourceAliasJoin Type
I_Customer360BusDocSetting Customer360BusDocSetting inner
I_SalesDocument SalesDocument from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Customer 360 business doc approvals view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SoldToParty I_SalesDocument SoldToParty Sold-to Party
KEY SalesDocument I_SalesDocument SalesDocument SD Document
KEY SalesDocumentType I_SalesDocument SalesDocumentType Sales Doc. Type
CustomerName
SDDocumentCategory I_SalesDocument SDDocumentCategory Document Cat.
SalesDocApprovalStatus I_SalesDocument SalesDocApprovalStatus
TotalNetAmount I_SalesDocument TotalNetAmount Total Net Amount
TransactionCurrency I_SalesDocument TransactionCurrency Transaction Currency
CreationDate I_SalesDocument CreationDate Time Stamp
int1asSalesDocApprovalStsCriticality
SDDocumentCategoryName
SalesDocApprovalStatusDesc
SalesDocumentTypeName
_SalesDocApprovalStatus I_SalesDocument _SalesDocApprovalStatus
_SalesDocumentType I_SalesDocument _SalesDocumentType
SalesOrganization I_SalesDocument SalesOrganization Sales Organization
OrganizationDivision I_SalesDocument OrganizationDivision Org. Division
DistributionChannel I_SalesDocument DistributionChannel RefDistCh-Cust/Mat.
_SDDocumentCategory I_SalesDocument _SDDocumentCategory

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 C_Customer360ApprovalBusDoc.
-- 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: CUST360BDAPRVL

CREATE VIEW C_Customer360ApprovalBusDoc AS
SELECT
  SalesDocument.SoldToParty AS SoldToParty,
  SalesDocument.SalesDocument AS SalesDocument,
  SalesDocument.SalesDocumentType AS SalesDocumentType,
  SalesDocument._SoldToParty.CustomerName AS CustomerName,
  SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  SalesDocument.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  SalesDocument.TotalNetAmount AS TotalNetAmount,
  SalesDocument.TransactionCurrency AS TransactionCurrency,
  SalesDocument.CreationDate AS CreationDate,
  cast( case SalesDocument.SalesDocApprovalStatus when 'D' then 2 when 'A' then 0 end as abap.int1 ) as SalesDocApprovalStsCriticality AS int1asSalesDocApprovalStsCriticality,
  SalesDocument._SDDocumentCategory._Text[1:Language = $session.system_language].SDDocumentCategoryName AS SDDocumentCategoryName,
  SalesDocument._SalesDocApprovalStatus._Text[1:Language = $session.system_language].SalesDocApprovalStatusDesc AS SalesDocApprovalStatusDesc,
  SalesDocument._SalesDocumentType._Text[1:Language = $session.system_language].SalesDocumentTypeName AS SalesDocumentTypeName,
  SalesDocument._SalesDocApprovalStatus AS _SalesDocApprovalStatus,
  SalesDocument._SalesDocumentType AS _SalesDocumentType,
  SalesDocument.SalesOrganization AS SalesOrganization,
  SalesDocument.OrganizationDivision AS OrganizationDivision,
  SalesDocument.DistributionChannel AS DistributionChannel,
  SalesDocument._SDDocumentCategory AS _SDDocumentCategory
FROM I_SalesDocument AS SalesDocument
INNER JOIN I_Customer360BusDocSetting AS Customer360BusDocSetting ON /* join condition not captured in parsed metadata */
;

Learn More