C_LegalTransactionEntity

DDL: C_LEGALTRANSACTIONENTITY SQL: CLEGTRANSENT Type: view CONSUMPTION

Legal Transaction Entity (Draft disabled)

C_LegalTransactionEntity is a Consumption CDS View that provides data about "Legal Transaction Entity (Draft disabled)" in SAP S/4HANA. It reads from 1 data source (I_LegalTransactionEntity) and exposes 25 fields with key field LegalTransactionEntityUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LegalTransactionEntity I_LegalTransactionEntity from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_LegalTrEntityAggr _LegalTREntityAggr $projection.LegalTransactionEntityUUID = _LegalTREntityAggr.LegalTransactionEntityUUID
[0..1] C_LCMEntityTypeValueHelp _LglCntntMEntityTypeValueHelp $projection.LglCntntMEntityType = _LglCntntMEntityTypeValueHelp.LglCntntMEntityType
[0..1] C_LCMCompanyCodeValueHelp _CompanyCodeValueHelp $projection.LglCntntMEntityCoCode = _CompanyCodeValueHelp.CompanyCode
[0..1] C_LCMPurchasingOrgValueHelp _PurchasingOrgValueHelp $projection.LglCntntMEntityPurOrg = _PurchasingOrgValueHelp.PurchasingOrganization
[0..1] C_LCMSalesOrganizationVH _SalesOrganizationVH $projection.LglCntntMEntitySlsOrg = _SalesOrganizationVH.SalesOrganization

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CLEGTRANSENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.semanticKey LglCntntMEntityName view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Legal Transaction Entity (Draft disabled) view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionEntityUUID LegalTransactionEntityUUID
LglCntntMRank I_LegalTransactionEntity LglCntntMRank Rank
LglCntntMEntityType I_LegalTransactionEntity LglCntntMEntityType Entity Type
LglCntntMEntityTypeName
LglCntntMEntity LglCntntMEntity
LglCntntMEntitySupplier LglCntntMEntity Name
LglCntntMEntityCustomer LglCntntMEntity Name
LglCntntMEntityCoCode LglCntntMEntity Name
LglCntntMEntitySlsOrg LglCntntMEntity Name
LglCntntMEntityPurOrg LglCntntMEntity Name
LglCntntMEntityBusinessPartner LglCntntMEntity Name
LglCntntMEntityName _LegalTREntityAggr LglCntntMEntityName
LegalTransactionUUID LegalTransactionUUID
LglCntntMTechEntityType LglCntntMTechEntityType
LegalTransactionMandatoryFlag LegalTransactionMandatoryFlag
LglCntntMIsMandatory Required
LglCntntMIsMainEntity LglCntntMIsMainEntity Main Entity
_LglCntntMEntityTypeValueHelp _LglCntntMEntityTypeValueHelp
_CompanyCodeValueHelp _CompanyCodeValueHelp
_PurchasingOrgValueHelp _PurchasingOrgValueHelp
_SalesOrganizationVH _SalesOrganizationVH
_LegalTransaction _LegalTransaction
_Supplier _Supplier
_Customer _Customer
_BusinessPartner _BusinessPartner
@AbapCatalog.sqlViewName: 'CLEGTRANSENT'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: { createEnabled,
                updateEnabled,
                deleteEnabled,
                semanticKey: 'LglCntntMEntityName',
                usageType.dataClass: #MIXED,
                usageType.serviceQuality: #C,
                usageType.sizeCategory: #L
                }

@VDM.viewType: #CONSUMPTION

@Metadata.ignorePropagatedAnnotations: true

@AccessControl: { authorizationCheck:    #MANDATORY,
                  personalData.blocking: #NOT_REQUIRED }

@EndUserText.label: 'Legal Transaction Entity (Draft disabled)'
define view C_LegalTransactionEntity
  as select from I_LegalTransactionEntity


  // Aggregation

  association [0..1] to I_LegalTrEntityAggr         as _LegalTREntityAggr            on $projection.LegalTransactionEntityUUID = _LegalTREntityAggr.LegalTransactionEntityUUID

  //Value Helps

  association [0..1] to C_LCMEntityTypeValueHelp    as _LglCntntMEntityTypeValueHelp on $projection.LglCntntMEntityType = _LglCntntMEntityTypeValueHelp.LglCntntMEntityType

  //  association [0..*] to C_LCMSupplierValueHelp      as _SupplierValueHelp            on $projection.LglCntntMEntitySupplier = _SupplierValueHelp.Supplier


  //  association [0..*] to C_LCMContactsOrgValueHelp   as _CustomerContactsValueHelp    on $projection.LglCntntMEntityCustomer = _CustomerContactsValueHelp.Customer


  association [0..1] to C_LCMCompanyCodeValueHelp   as _CompanyCodeValueHelp         on $projection.LglCntntMEntityCoCode = _CompanyCodeValueHelp.CompanyCode

  association [0..1] to C_LCMPurchasingOrgValueHelp as _PurchasingOrgValueHelp       on $projection.LglCntntMEntityPurOrg = _PurchasingOrgValueHelp.PurchasingOrganization

  association [0..1] to C_LCMSalesOrganizationVH    as _SalesOrganizationVH          on $projection.LglCntntMEntitySlsOrg = _SalesOrganizationVH.SalesOrganization

  //  association [0..*] to C_LglCntntMBusinessPartnerVH as _LglCntntMBusinessPartnerVH   on $projection.LglCntntMEntityBusinessPartner = _LglCntntMBusinessPartnerVH.BusinessPartner


{

      @UI.hidden: true
  key LegalTransactionEntityUUID,

      @UI.identification: { position: 10, importance: #HIGH }
      @EndUserText.label: 'Rank'
      @EndUserText.quickInfo: 'Rank'
      I_LegalTransactionEntity.LglCntntMRank,

      @UI.identification: { position: 15, importance: #HIGH }
      @ObjectModel: { foreignKey.association:  '_LglCntntMEntityTypeValueHelp', text.element: 'LglCntntMEntityTypeName' }
      @UI.textArrangement: #TEXT_ONLY
      @EndUserText.label: 'Entity Type'
      @ObjectModel.mandatory: true
      I_LegalTransactionEntity.LglCntntMEntityType,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      @Semantics.text: true
      _EntityTypeText[1: Language = $session.system_language].LglCntntMEntityTypeName,
      //      _LglCntntMEntityTypeValueHelp.LglCntntMEntityTypeName,


      @UI.hidden: true
      LglCntntMEntity                                 as LglCntntMEntity,

      @ObjectModel.text.element:   'LglCntntMEntityName'
      //      @Consumption.valueHelp: '_SupplierValueHelp'

      @Consumption.valueHelpDefinition: [
            {
                entity: {
                    name: 'C_LCMSupplierValueHelp',
                    element: 'Supplier'
                }
                }
                ]
      @Consumption.semanticObject: 'Supplier'
      @UI.textArrangement: #TEXT_FIRST
      @EndUserText.label: 'Name'
      LglCntntMEntity                                 as LglCntntMEntitySupplier,

      @ObjectModel.text.element:   'LglCntntMEntityName'
      //      @Consumption.valueHelpDefinition: [

      //       {

      //           entity: {

      //               name: 'C_LCMContactsOrgValueHelp',

      //               element: 'Customer'

      //           }

      //           }

      //           ]

      //      @Consumption.valueHelpDefinition: [{ entity: { name: 'D_LglCntntMContactsOrgCVH',

      //                                        element: 'Customer' }

      //                             } ]


      @Consumption: {
       valueHelpDefinition: [
            { entity: { name : 'C_LCMContactsOrgValueHelp', element: 'Customer' },
              label: 'Customers by Standard Address'},
            { entity: { name: 'C_BPCustomerMultiAddrVH', element: 'Customer'},
              qualifier: 'CustMultiAddr',
              label: 'Customers by All Addresses' }
           ],
            semanticObject                  : 'Customer',
            semanticObjectMapping.element   : 'LglCntntMEntityCustomer'
        }
      @UI.textArrangement: #TEXT_FIRST
      @EndUserText.label: 'Name'
      LglCntntMEntity                                 as LglCntntMEntityCustomer,

      @ObjectModel.text.element:   'LglCntntMEntityName'
      @Consumption.valueHelp: '_CompanyCodeValueHelp'
      @UI.textArrangement: #TEXT_FIRST
      @EndUserText.label: 'Name'
      LglCntntMEntity                                 as LglCntntMEntityCoCode,

      @ObjectModel.text.element:   'LglCntntMEntityName'
      @Consumption.valueHelp: '_SalesOrganizationVH'
      @UI.textArrangement: #TEXT_FIRST
      @EndUserText.label: 'Name'
      LglCntntMEntity                                 as LglCntntMEntitySlsOrg,

      @ObjectModel.text.element:   'LglCntntMEntityName'
      @Consumption.valueHelp: '_PurchasingOrgValueHelp'
      @UI.textArrangement: #TEXT_FIRST
      @EndUserText.label: 'Name'
      LglCntntMEntity                                 as LglCntntMEntityPurOrg,

      @ObjectModel.text.element:   'LglCntntMEntityName'
      @Consumption.valueHelpDefinition: [
        {
            entity: {
                name: 'C_LglCntntMBusinessPartnerVH',
                element: 'BusinessPartner'
            },

            additionalBinding: [{ localElement: 'LglCntntMEntityType',
                                  element: 'LglCntntMEntityType'
                                  }]
        }
      ]
      @UI.textArrangement: #TEXT_FIRST
      @Consumption.semanticObject: 'BusinessPartner'
      @EndUserText.label: 'Name'
      LglCntntMEntity                                 as LglCntntMEntityBusinessPartner,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      @Semantics.text: true
      _LegalTREntityAggr.LglCntntMEntityName,

      @UI.hidden: true
      LegalTransactionUUID,

      @ObjectModel.readOnly: true
      LglCntntMTechEntityType,

      @UI.hidden: true
      LegalTransactionMandatoryFlag,

      @UI.identification: { position: 25, importance: #HIGH }
      @EndUserText.label: 'Required'
      //cast( LegalTransactionMandatoryFlag as lcm_lt_mandatory_ctrl_to_bool preserving type ) as LglCntntMIsMandatory,

      cast ( '' as lcm_is_mandatory preserving type ) as LglCntntMIsMandatory,

      @UI.identification: { position: 30, importance: #HIGH }
      @ObjectModel.readOnly: true
      @EndUserText.label: 'Main Entity'
      LglCntntMIsMainEntity,

      // Value Helps

      _LglCntntMEntityTypeValueHelp,
      //      _SupplierValueHelp,

      //      _CustomerContactsValueHelp,

      _CompanyCodeValueHelp,
      _PurchasingOrgValueHelp,
      _SalesOrganizationVH,
      //      _LglCntntMBusinessPartnerVH,

      _LegalTransaction,

      @Consumption.filter.hidden: true
      _Supplier,
      @Consumption.filter.hidden: true
      _Customer,
      @Consumption.filter.hidden: true
      _BusinessPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LCMENTITYTYPETEXT",
"I_LEGALTRANSACTIONENTITY",
"I_LEGALTRENTITYAGGR"
],
"ASSOCIATED":
[
"C_LCMCOMPANYCODEVALUEHELP",
"C_LCMENTITYTYPEVALUEHELP",
"C_LCMPURCHASINGORGVALUEHELP",
"C_LCMSALESORGANIZATIONVH",
"I_BUSINESSPARTNER",
"I_CUSTOMER",
"I_LEGALTRANSACTION",
"I_LEGALTRENTITYAGGR",
"I_SUPPLIER"
],
"BASE":
[
"I_LEGALTRANSACTIONENTITY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/