BDEF_CDS_SUB_FOR_TEST

DDL: BDEF_CDS_SUB_FOR_TEST SQL: BDEFTEST Type: view Package: SWB_RAP_TEST_OBJ
40 Fields 1 Data Sources

The object used in tests

BDEF_CDS_SUB_FOR_TEST is a CDS View that provides data about "The object used in tests" in SAP S/4HANA. It reads from 1 data source (SEPM_I_SalesOrder) and exposes 40 fields with key field SalesOrderUUID. Part of development package SWB_RAP_TEST_OBJ.

Data Sources (1)

SourceAliasJoin Type
SEPM_I_SalesOrder SalesOrder from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName BDEFTEST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label The object used in tests view
AbapCatalog.preserveKey true view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderUUID SalesOrderUUID
SOooooooooo SalesOrder SD Document
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedDateTime LastChangedDateTime Time Stamp
IsCreatedByBusinessPartner IsCreatedByBusinessPartner Value
IsLastChangedByBusinessPartner IsLastChangedByBusinessPartner Value
ShortTextGroupUUID ShortTextGroupUUID Node Key
CustomerUUID CustomerUUID NodeID
TransactionCurrency TransactionCurrency Transaction Currency
GrossAmountInTransacCurrency GrossAmountInTransacCurrency Tax-Inclusive Amount
NetAmountInTransactionCurrency NetAmountInTransactionCurrency Tax-Exclusive Amount
TaxAmountInTransactionCurrency TaxAmountInTransactionCurrency VAT Amount Type
SalesOrderLifeCycleStatus SalesOrderLifeCycleStatus Status
SalesOrderBillingStatus SalesOrderBillingStatus SO Confirmation
SalesOrderDeliveryStatus SalesOrderDeliveryStatus SO Ordering
SalesOrderOverallStatus SalesOrderOverallStatus Overall Sts
Opportunity Opportunity Opportunity ID
CustomerContactUUID CustomerContactUUID Customer Contact Key
ShipToPartyAddressUUID ShipToPartyAddressUUID Node Key
BillToPartyAddressUUID BillToPartyAddressUUID Node Key
SalesOrderPaymentMethod SalesOrderPaymentMethod Pymt Meth.
SalesOrderPaymentTerms SalesOrderPaymentTerms Terms of Paymnt
_BillingStatus _BillingStatus
_BillToPartyAddress _BillToPartyAddress
_CreatedByUser _CreatedByUser
_Customer _Customer
_CustomerContact _CustomerContact
_CustomerV2 _CustomerV2
_DeliveryStatus _DeliveryStatus
_Item _Item
_LastChangedByUser _LastChangedByUser
_LifeCycleStatus _LifeCycleStatus
_OverallStatus _OverallStatus
_PaymentMethod _PaymentMethod
_PaymentTerms _PaymentTerms
_ShipToPartyAddress _ShipToPartyAddress
_ShortTextGroup _ShortTextGroup
_TransactionCurrency _TransactionCurrency

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 BDEF_CDS_SUB_FOR_TEST.
-- 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: BDEFTEST

CREATE VIEW BDEF_CDS_SUB_FOR_TEST AS
SELECT
  SalesOrderUUID,
  SalesOrder AS SOooooooooo,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangedDateTime,
  IsCreatedByBusinessPartner,
  IsLastChangedByBusinessPartner,
  ShortTextGroupUUID,
  CustomerUUID,
  TransactionCurrency,
  GrossAmountInTransacCurrency,
  NetAmountInTransactionCurrency,
  TaxAmountInTransactionCurrency,
  SalesOrderLifeCycleStatus,
  SalesOrderBillingStatus,
  SalesOrderDeliveryStatus,
  SalesOrderOverallStatus,
  Opportunity,
  CustomerContactUUID,
  ShipToPartyAddressUUID,
  BillToPartyAddressUUID,
  SalesOrderPaymentMethod,
  SalesOrderPaymentTerms
FROM SEPM_I_SalesOrder AS SalesOrder
;

Learn More