R_TRDGCONTR

@AccessControl: {
    authorizationCheck: #MANDATORY,
    personalData.blocking: #('TRANSACTIONAL_DATA')
    }
@ObjectModel: {
   compositionRoot: false,
   representativeKey: 'TradingContract',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   }
}
@VDM: {
    viewType: #COMPOSITE,
    lifecycle.contract.type: #SAP_INTERNAL_API
    }
@Metadata: {
  ignorePropagatedAnnotations: true,
  allowExtensions: false
}
@EndUserText.label: 'Trading Contract'
@ObjectModel.semanticKey: ['TradingContract']

/* BO Layer */
define view entity R_TrdgContr
  as select from R_TrdgDoc as TradingDocument

  association [0..*] to R_TrdgContrPartner       as _TradingContractPartner on $projection.TradingContract = _TradingContractPartner.TradingContract
  association [0..*] to R_TrdgContrSlsPrcgElmnt  as _TrdgContrSlsPrcgElmnt  on $projection.TradingContract = _TrdgContrSlsPrcgElmnt.TradingContract
  association [0..*] to R_TrdgContrPurgPrcgElmnt as _TrdgContrPurgPrcgElmnt on $projection.TradingContract = _TrdgContrPurgPrcgElmnt.TradingContract
  association [0..*] to R_TrdgContrItem          as _TradingContractItem    on $projection.TradingContract = _TradingContractItem.TradingContract

{
  key TradingDocument                           as TradingContract,
      TradingDocumentType                       as TradingContractType,
      TradingDocument.TrdgDocCategory           as TradingContractCategory,
      TradingDocument.TrdgDocBusProcessCategory as TrdgContrBusProcessCategory,
      TradingDocument.TrdgDocPurpose            as TradingContractPurpose,
      TrdgDocApplicationStatus                  as TrdgContrApplicationStatus,
      SalesDocumentType,
      SalesDocumentCondition,
      CreatedByUser,
      LastChangedByUser,
      TrdgDocPersonResponsible                  as TrdgContrPersonResponsible,
      CreationDate,
      CreationTime,
      LastChangeDate,
      LastChangeTime,
      TrdgDocDate                               as TrdgContrDate,
      SalesOrganization,
      DistributionChannel,
      OrganizationDivision,
      SalesGroup,
      SalesOffice,
      SoldToParty,
      AdditionalCustomerGroup1,
      AdditionalCustomerGroup2,
      AdditionalCustomerGroup3,
      AdditionalCustomerGroup4,
      AdditionalCustomerGroup5,
      CreditControlArea,
      SDDocumentCategory,
      SalesDocumentDate,
      SalesOrderReason,
      SDDocumentCollectiveNumber,
      CustomerPurchaseOrderType,
      CustomerPurchaseOrderSuplmnt,
      BindingPeriodValidityStartDate,
      BindingPeriodValidityEndDate,
      TrdgDocSlsValidityStartDate               as TrdgContrSlsValidityStartDate,
      TrdgDocSlsValidityEndDate                 as TrdgContrSlsValidityEndDate,
      TrdgDocProdUsgeCat                        as TrdgContrProdUsgeCat,
      ForeignTrade,
      TrdgDocSlsPersonName                      as TrdgContrSlsPersonName,
      PhoneNumber1,
      TrdgDocSlsNrOfFollowUps                   as TrdgContrSlsNrOfFollowUps,
      DocumentReferenceID,
      @ObjectModel.foreignKey.association: '_TradingContractCurrency'
      TrdgDocCurrency                           as TradingContractCurrency,
      @Semantics.amount.currencyCode: 'TradingContractCurrency'
      TrdgDocTotalNetAmount                     as TrdgContrTotalNetAmount,
      TrdgDocExchangeRate                       as TradingContractExchangeRate,
      TrdgDocExchangeRateType                   as TrdgContrExchangeRateType,
      TrdgDocExchangeRateDate                   as TrdgContrExchangeRateDate,
      TrdgDocSalesCurrency                      as TradingContractSalesCurrency,
      TrdgDocSalesExchangeRate                  as TrdgContrSalesExchangeRate,
      TrdgDocSalesExchangeRateType              as TrdgContrSalesExchangeRateType,
      TrdgDocSalesPricingDate                   as TrdgContrSalesPricingDate,
      TrdgDocSalesPricingProcedure              as TrdgContrSalesPricingProcedure,
      CustomerTaxClassification1,
      CustomerTaxClassification2,
      CustomerTaxClassification3,
      CustomerTaxClassification4,
      CustomerTaxClassification5,
      CustomerTaxClassification6,
      CustomerTaxClassification7,
      CustomerTaxClassification8,
      CustomerTaxClassification9,
      TaxDepartureCountry,
      VATRegistrationCountry,
      ShippingCondition,
      CompleteDeliveryIsDefined,
      DeliveryBlockReason,
      CompanyCode,
      HeaderBillingBlockReason,
      ControllingArea,
      CustomerCreditAccount,
      CustomerCreditGroup,
      CreditRepresentativeGroup,
      CustomerRiskCategory,
      ControllingAreaCurrency,
      CreditBlockReleaseDate,
      NextCreditCheckDate,
      NextShippingDate,
      @Semantics.amount.currencyCode: 'ControllingAreaCurrency'
      ReleasedCreditAmount,
      TrdgDocSuplrBillgBlkRsn                   as TrdgContrSuplrBillgBlkRsn,

      AccountingExchangeRate,
      TrdgDocSlsExternalReference               as TrdgContrSlsExternalReference,
      TrdgDocIsComplete                         as TradingContractIsComplete,
      LastCustomerContactDate,
      TrdgDocQuantityIsComplete                 as TrdgContrQuantityIsComplete,
      TrdgDocReleaseStatus                      as TradingContractReleaseStatus,
      TrdgDocExternalIdentifier                 as TradingContractExtID,
      TrdgDocSrceDocType                        as TrdgContrSrceDocType,
      TradingDocumentGoodsReceiver              as TradingContractGoodsReceiver,
      IsEUTriangularDeal,
      @Semantics.booleanIndicator:true
      TrdgDocHdrIsExtended                      as TrdgContrHdrIsExtended,
      TrdgDocSuccessorArchived                  as TrdgContrSuccessorArchived,
      @Semantics.booleanIndicator:true
      TrdgDocHasCnsldtdItem                     as TrdgContrHasCnsldtdItem,
      TrdgDocVarContrSettlmt                    as TrdgContrVarContrSettlmt,
      TrdgDocIsInApproval                       as TradingContractIsInApproval,
      TrdgDocBatDetnProcedure                   as TrdgContrBatDetnProcedure,
      TrdgDocProcgStatus                        as TrdgContrProcessingStatus,
      TrdgDocProcessingLastAction               as TrdgContrProcessingLastAction,
      TrdgDocProcgLastSequence                  as TrdgContrProcgLastSequence,
      TradingProcessVariantType,
      WBSElementInternalID,
      TrdgDocPricingType                        as TrdgContrPricingType,
      TrdgDocLastChangedCategory                as TrdgContrLastChangedCategory,
      Supplier,
      PurchasingOrganization,
      PurchasingGroup,
      PurchasingDocumentOrderDate,
      TrdgDocPurgReqdDeliveryDate               as TrdgContrPurgReqdDeliveryDate,
      TrdgDocPurgDeliveryDateType               as TrdgContrPurgDeliveryDateType,
      TrdgDocSlsReqdDeliveryDate                as TrdgContrSlsReqdDeliveryDate,
      TrdgDocSlsDeliveryDateType                as TrdgContrSlsDeliveryDateType,
      TrdgDocPurgCurrency                       as TrdgContrPurgCurrency,
      TrdgDocPurgExchangeRate                   as TrdgContrPurgExchangeRate,
      TrdgDocPurgExchangeRateType               as TrdgContrPurgExchangeRateType,
      TrdgDocPurgPaymentTerms                   as TrdgContrPurgPaymentTerms,
      TrdgDocSalesPaymentTerms                  as TrdgContrSalesPaymentTerms,
      TrdgDocSalesFixedValueDate                as TrdgContrSalesFixedValueDate,
      TrdgDocPurgFixedValueDate                 as TrdgContrPurgFixedValueDate,
      TrdgDocPurgPricingDate                    as TrdgContrPurgPricingDate,
      SupplyingPlant,
      TrdgDocPurgIncotermsVersion               as TrdgContrPurgIncotermsVersion,
      TrdgDocPurgIncotermsLoc1Text              as TrdgContrPurgIncotermsLoc1Text,
      TrdgDocPurgIncotermsLoc2Text              as TrdgContrPurgIncotermsLoc2Text,
      TrdgDocSalesIncotermsVersion              as TrdgContrSalesIncotermsVersion,
      TrdgDocSlsIncotermsLoc1Text               as TrdgContrSlsIncotermsLoc1Text,
      TrdgDocSlsIncotermsLoc2Text               as TrdgContrSlsIncotermsLoc2Text,
      QuotationSubmissionDate,
      TrdgDocSalesPaymentMethod                 as TrdgContrSalesPaymentMethod,
      TrdgDocPurgValidityStartDate              as TrdgContrPurgValidityStartDate,
      TrdgDocPurgValidityEndDate                as TrdgContrPurgValidityEndDate,
      SupplierQuotationExternalID,
      SupplierRespSalesPersonName,
      SupplierPhoneNumber,
      CorrespncInternalReference,
      TrdgDocPurgDocExtReference                as TrdgContrPurgDocExtReference,
      InternalFinancialDocument,
      DepreciationPercentage,
      FixedExchangeRateIsUsed,
      TrdgDocPurgDocCat                         as TrdgContrPurgDocCat,
      PurchasingDocumentType,
      ShippingType,
      _TradingProcessVariantType,
      PurchaseOrderByCustomer,
      CustomerPurchaseOrderDate,
      TrdgDocPurgPricingProcedure               as TrdgContrPurgPricingProcedure,
      DownPaymentType,
      DownPaymentPercentageOfTotAmt,
      @Semantics.amount.currencyCode: 'TrdgContrPurgCurrency'
      DownPaymentAmount,
      DownPaymentDueDate,
      TrdgDocPurgDocCndn                        as TrdgContrPurgDocCndn,
      SlsIncotermsClassification,
      PurgIncotermsClassification,
      TrdgDocPurgDelivAddrCat                   as TrdgContrPurgDelivAddrCat,
      PaymentGuaranteeProcedure,
      TrdgDocPOByCustomer                       as TrdgContrPOByCustomer,
      PaymentTermsName,
      PurgIncotermsTransferLocation,
      SlsIncotermsTransferLocation,
      PurchaseOrderByShipToParty,
      CreationDateTime,
      LastChangeDateTime,
      TrdgDocRelStsCritlty                      as TrdgContrRelStsCritlty,
      CustomerName,
      TrdgDocPurgShipgInstrn                    as TrdgContrPurgShipgInstrn,
      SupplierConfirmationControlKey,
      TrdgDocMnlPOSplit                         as TrdgContrMnlPOSplit,
      UnderlyingPurchaseOrderItem,




      /* Associations */
      _AdditionalCustomerGroup1,
      _AdditionalCustomerGroup2,
      _AdditionalCustomerGroup3,
      _AdditionalCustomerGroup4,
      _AdditionalCustomerGroup5,
      _CompanyCode,
      _ControllingArea,
      _ControllingAreaCurrency,
      _CreatedByUser,
      _CreditControlArea,
      _Currency,
      _CustomerCreditAccount,
      _CustomerPurchaseOrderType,
      _CustomerSalesArea,
      _DeliveryBlockReason,
      _DistributionChannel,
      _HeaderBillingBlockReason,
      _LastChangedByUser,
      _OrganizationDivision,
      _PaymentGuaranteeProcedure,
      _PurchasingGroup,
      _PurchasingOrganization,
      _PurgIncotermsClassification,
      _SalesArea,
      _SalesDocumentType,
      _SalesGroup,
      _SalesOffice,
      _SalesOrderReason,
      _SalesOrganization,
      _SalesPricingElement,
      _SDDocumentCategory,
      _ShippingCondition,
      _ShippingType,
      _SlsIncotermsClassification,
      _SoldToParty,
      _Supplier,
      _SupplyingPlant,
      _TradingDocumentType                      as _TradingContractType,
      _TrdgDocApplStatus                        as _TrdgContrApplStatus,
      _TrdgDocBusProcCategory                   as _TrdgContrBusProcCategory,
      _TrdgDocCategory                          as _TrdgContrCategory,
      _TrdgDocCurrency                          as _TradingContractCurrency,
      _TrdgDocExchangeRateType                  as _TrdgContrExchangeRateType,
      _TrdgDocHasCnsldtdItem                    as _TrdgContrHasCnsldtdItem,
      _TrdgDocIsComplete                        as _TrdgContrIsComplete,
      _TrdgDocItem                              as _TrdgContrItem,
      _TrdgDocLastChgdCat                       as _TrdgContrLastChgdCat,
      _TrdgDocPartner                           as _TrdgContrPartner,
      _TrdgDocPricingType                       as _TrdgContrPricingType,
      _TrdgDocProcgStatus                       as _TrdgContrProcgStatus,
      _TrdgDocPurgDelivAddrCat                  as _TrdgContrPurgDelivAddrCat,
      _TrdgDocPurgDocCat                        as _TrdgContrPurgDocCat,
      _TrdgDocPurgExchangeRateType              as _TrdgContrPurgExchangeRateType,
      _TrdgDocPurgIncotermsVersion              as _TrdgContrPurgIncotermsVersion,
      _TrdgDocPurgPaymentTerms                  as _TrdgContrPurgPaymentTerms,
      _TrdgDocPurpose                           as _TradingContractPurpose,
      _TrdgDocReleaseStatus                     as _TrdgContrReleaseStatus,
      _TrdgDocSalesCurrency                     as _TrdgContrSalesCurrency,
      _TrdgDocSalesPaymentTerms                 as _TrdgContrSalesPaymentTerms,
      _TrdgDocSlsExchangeRateType               as _TrdgContrSlsExchangeRateType,
      _TrdgDocSlsIncotermsVersion               as _TrdgContrSlsIncotermsVersion,
      _TrdgDocSlsPricingProcedure               as _TrdgContrSlsPricingProcedure,
      _TrdgDocSrceDocType                       as _TrdgContrSrceDocType,
      _TrdgDocSuccssrArchived                   as _TrdgContrSuccssrArchived,
      _TrdgDocVarContrSettlmt                   as _TrdgContrVarContrSettlmt,
      _WBSElementInternalID,

      /* Exposed Associations */
      _TradingContractItem,
      _TradingContractPartner,
      _TrdgContrSlsPrcgElmnt,
      _TrdgContrPurgPrcgElmnt,
      _SalesOrderType,
      _MatlUsageIndicator,
      _TaxDepartureCountry,
      _VATRegistrationCountry,
      _TrdgDocSuplrBillgBlkRsn                  as _TrdgContrSuplrBillgBlkRsn
}

where
      TradingDocument.TrdgDocCategory           = ''
  and TradingDocument.TrdgDocBusProcessCategory = ''
  and TradingDocument.TrdgDocPurpose            = '';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_TRDGDOC"
],
"ASSOCIATED":
[
"I_ADDITIONALCUSTOMERGROUP1",
"I_ADDITIONALCUSTOMERGROUP2",
"I_ADDITIONALCUSTOMERGROUP3",
"I_ADDITIONALCUSTOMERGROUP4",
"I_ADDITIONALCUSTOMERGROUP5",
"I_BILLINGBLOCKREASON",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COUNTRY",
"I_CREDITCONTROLAREA",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERPURCHASEORDERTYPE",
"I_CUSTOMERSALESAREA",
"I_DELIVERYBLOCKREASON",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_EXCHANGERATETYPE",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSVERSION",
"I_MATLUSAGEINDICATOR",
"I_PAYMENTGUARANTEEPROCEDURE",
"I_PAYMENTTERMS",
"I_PLANT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_SALESAREA",
"I_SALESDOCUMENTTYPE",
"I_SALESGROUP",
"I_SALESOFFICE",
"I_SALESORDERTYPE",
"I_SALESORGANIZATION",
"I_SDDOCUMENTCATEGORY",
"I_SDDOCUMENTREASON",
"I_SHIPPINGCONDITION",
"I_SHIPPINGTYPE",
"I_SLSPRICINGPROCEDURE",
"I_SUPPLIER",
"I_TRDGDOCSUPLRBILLGBLKRSN",
"I_USER",
"I_WBSELEMENTBASICDATA",
"R_TRDGCONTRITEM",
"R_TRDGCONTRPARTNER",
"R_TRDGCONTRPURGPRCGELMNT",
"R_TRDGCONTRSLSPRCGELMNT",
"R_TRDGDOCAPPLICATIONSTATUS",
"R_TRDGDOCBUSPROCCATEGORY",
"R_TRDGDOCCATEGORY",
"R_TRDGDOCHASCNSLDTDITEM",
"R_TRDGDOCISCOMPLETE",
"R_TRDGDOCITEM",
"R_TRDGDOCLASTCHGDCAT",
"R_TRDGDOCPARTNER",
"R_TRDGDOCPRICINGTYPE",
"R_TRDGDOCPROCGSTATUS",
"R_TRDGDOCPURGDELIVADDRCAT",
"R_TRDGDOCPURGDOCCAT",
"R_TRDGDOCPURPOSE",
"R_TRDGDOCRELEASESTATUS",
"R_TRDGDOCSLSPRCGELMNT",
"R_TRDGDOCSRCEDOCTYPE",
"R_TRDGDOCSUCCSSRARCHIVED",
"R_TRDGDOCTYPE",
"R_TRDGDOCVARCONTRSETTLMT",
"R_TRDGPROCESSVARIANTTYPE"
],
"BASE":
[
"R_TRDGDOC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/