sadl_v_exp_draft

DDL: SADL_V_EXP_DRAFT SQL: SADL_V_DRFT Type: view

CDS view for draft

sadl_v_exp_draft is a CDS View that provides data about "CDS view for draft" in SAP S/4HANA. It reads from 1 data source (snwd_so) and exposes 15 fields with key field node_key.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
snwd_so snwd_so from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SADL_V_DRFT view
EndUserText.label CDS view for draft view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence SADL_SNWD_SO_D view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY node_key node_key
so_id so_id
created_by created_by
created_at created_at
changed_by changed_by
changed_at changed_at
note_guid note_guid
buyer_guid buyer_guid
gross_amount gross_amount
net_amount net_amount
tax_amount tax_amount
op_id op_id
dummy dummy
NodeKeyForEdit
SoIdForEdit 
@AbapCatalog.sqlViewName: 'SADL_V_DRFT'
@EndUserText.label: 'CDS view for draft'

@ObjectModel.semanticKey:  [ 'so_id' ]

@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.draftEnabled: true
@ObjectModel.compositionRoot: true

@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true

@ObjectModel.writeDraftPersistence: 'SADL_SNWD_SO_D'

define view sadl_v_exp_draft
as select from snwd_so {
  @ObjectModel.readOnly: true
  key node_key, 
  so_id, 
  created_by, 
  created_at, 
  changed_by, 
  changed_at, 
  created_by_bp, 
  changed_by_bp, 
  note_guid, 
  buyer_guid, 
  currency_code, 
  gross_amount, 
  net_amount, 
  tax_amount, 
  lifecycle_status, 
  billing_status, 
  delivery_status, 
  op_id, 
  dummy, 
  overall_status, 
  buy_contact_guid, 
  ship_to_adr_guid, 
  bill_to_adr_guid, 
  payment_method, 
  payment_terms,
  
  @ObjectModel.editableFieldFor: 'node_key'
  'nodekey' as NodeKeyForEdit,
  
  @ObjectModel.editableFieldFor: 'so_id'
  @ObjectModel.readOnly: true
  'so_id'   as SoIdForEdit
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SNWD_SO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More