R_ActgActAlcPrftbltySgmtDraft

DDL: R_ACTGACTALCPRFTBLTYSGMTDRAFT Type: view_entity BASIC Package: ODATA_MANAGE_DRCT_ACTY_ALLOC_2
48 Fields 1 Data Sources 1 Associations

Direct Activity Allocation PS - Draft

R_ActgActAlcPrftbltySgmtDraft is a Basic CDS View that provides data about "Direct Activity Allocation PS - Draft" in SAP S/4HANA. It reads from 1 data source (drctactyitmps_d) and exposes 48 fields with key fields FiscalYear, ReferenceDocument, ControllingArea, ReferenceDocumentItem, LedgerGLLineItem. It has 1 association to related views. Part of development package ODATA_MANAGE_DRCT_ACTY_ALLOC_2.

Data Sources (1)

SourceAliasJoin Type
drctactyitmps_d _ActgActAlcPrftbltySgmtDraft from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_ActgActAlcPrftbltySgmtDraft _Extension $projection.FiscalYear = _Extension.FiscalYear and $projection.ReferenceDocument = _Extension.ReferenceDocument and $projection.ControllingArea = _Extension.ControllingArea and $projection.ReferenceDocumentItem = _Extension.ReferenceDocumentItem and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem and $projection.ReferenceDocumentType = _Extension.ReferenceDocumentType and $projection.ReferenceDocumentContext = _Extension.ReferenceDocumentContext and $projection.AccountingDocument = _Extension.AccountingDocument and $projection.DraftUUID = _Extension.DraftUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Direct Activity Allocation PS - Draft view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY FiscalYear fiscalyear G/L Fiscal Year
KEY ReferenceDocument referencedocument Reference Document
KEY ControllingArea controllingarea Controlling Area
KEY ReferenceDocumentItem referencedocumentitem Reference item
KEY LedgerGLLineItem ledgergllineitem Journal Entry Item
KEY ReferenceDocumentType referencedocumenttype Reference Document Type
KEY ReferenceDocumentContext referencedocumentcontext Reference Document Context
KEY AccountingDocument accountingdocument Journal Entry
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
ActyAllocationDraftUUID actyallocationdraftuuid Draft Document ID
CompanyCode companycode Receiver Company Code
TransactionSubitem transactionsubitem Sub Transaction
ControllingDocumentItem controllingdocumentitem Controlling Doc Item
SourceLedger sourceledger Source Ledger
Customer customer Sold-to Party
CustomerGroup customergroup Customer Group
CustomerSupplierIndustry customersupplierindustry Industry
CustomerSupplierCountry customersuppliercountry Customer or Supplier Country/Region
SalesDistrict salesdistrict Sales District
SoldProduct soldproduct Product Sold
SoldProductGroup soldproductgroup Product Sold Group
SalesOrganization salesorganization Sales Organization
DistributionChannel distributionchannel RefDistCh-Cust/Mat.
OrganizationDivision organizationdivision Org. Division
BillToParty billtoparty Inv. Recipient
ShipToParty shiptoparty Ship-To Party (obsolete)
WBSElementInternalID wbselementinternalid WBS Internal ID
WBSElementExternalID wbselementexternalid WBS Element External ID
ServiceDocumentType servicedocumenttype Transaction Type
ServiceDocument servicedocument Transaction ID
ServiceDocumentItem servicedocumentitem Service Document
SalesDocument salesdocument SD Document
SalesDocumentItem salesdocumentitem Sales Document Item
ProfitCenter profitcenter Profit Center
PartnerProfitCenter partnerprofitcenter Profit Center
FunctionalArea functionalarea Sendr Fctl Area
PartnerCompanyCode partnercompanycode Partner Company Code
ControllingBusTransacType controllingbustransactype CO Bus. Transaction
BusinessTransactionCategory businesstransactioncategory Business Transaction Category
OriginCtrlgDebitCreditCode originctrlgdebitcreditcode Debit/CreditInd
DebitCreditCode debitcreditcode Single-Character Flag
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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 R_ActgActAlcPrftbltySgmtDraft.
-- 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.

CREATE VIEW R_ActgActAlcPrftbltySgmtDraft AS
SELECT
  FiscalYear,
  ReferenceDocument,
  ControllingArea,
  ReferenceDocumentItem,
  LedgerGLLineItem,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  AccountingDocument,
  DraftUUID,
  ParentDraftUUID,
  ActyAllocationDraftUUID,
  CompanyCode,
  TransactionSubitem,
  ControllingDocumentItem,
  SourceLedger,
  Customer,
  CustomerGroup,
  CustomerSupplierIndustry,
  CustomerSupplierCountry,
  SalesDistrict,
  SoldProduct,
  SoldProductGroup,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  BillToParty,
  ShipToParty,
  WBSElementInternalID,
  WBSElementExternalID,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  SalesDocument,
  SalesDocumentItem,
  ProfitCenter,
  PartnerProfitCenter,
  FunctionalArea,
  PartnerCompanyCode,
  ControllingBusTransacType,
  BusinessTransactionCategory,
  OriginCtrlgDebitCreditCode,
  DebitCreditCode,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM drctactyitmps_d AS _ActgActAlcPrftbltySgmtDraft
LEFT OUTER JOIN E_ActgActAlcPrftbltySgmtDraft AS _Extension ON FiscalYear = _Extension.FiscalYear AND ReferenceDocument = _Extension.ReferenceDocument AND ControllingArea = _Extension.ControllingArea AND ReferenceDocumentItem = _Extension.ReferenceDocumentItem AND LedgerGLLineItem = _Extension.LedgerGLLineItem AND ReferenceDocumentType = _Extension.ReferenceDocumentType AND ReferenceDocumentContext = _Extension.ReferenceDocumentContext AND AccountingDocument = _Extension.AccountingDocument AND DraftUUID = _Extension.DraftUUID  -- association [1..1]
;

Learn More