I_ACMPrepaymentAssignedDoc

DDL: I_ACMPREPAYMENTASSIGNEDDOC Type: view_entity COMPOSITE
64 Fields 3 Data Sources

Interface for Prepay Agmt Asgd Docs

I_ACMPrepaymentAssignedDoc is a Composite CDS View that provides data about "Interface for Prepay Agmt Asgd Docs" in SAP S/4HANA. It reads from 3 data sources (I_ACMApplicationData, I_AssignmentData, P_PrepaymentAssignedDocument) and exposes 64 fields with key fields ContractApplicationUUID, ContractApplicationVersion, ReferenceApplicationDocument, ReferenceApplicationItem, ACMDocumentSide.

Data Sources (3)

SourceAliasJoin Type
I_ACMApplicationData AppData inner
I_AssignmentData AssignmentData inner
P_PrepaymentAssignedDocument PrepayAgrAsgndoc from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Interface for Prepay Agmt Asgd Docs view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY ContractApplicationUUID I_ACMApplicationData ContractApplicationUUID GUID (Hex) Specified by the Application
KEY ContractApplicationVersion I_ACMApplicationData ContractApplicationVersion Application Version
KEY ReferenceApplicationDocument I_ACMApplicationData ReferenceApplicationDocument Ref Preceeding Doc
KEY ReferenceApplicationItem I_ACMApplicationData ReferenceApplicationItem Ref. Doc. Item
KEY ACMDocumentSide I_ACMApplicationData ReferenceDocumentSide Side
KEY ApplicationDocumentSubItem I_ACMApplicationData ApplicationDocumentSubItem
KEY PrepaymentAssignedDocumentUUID P_PrepaymentAssignedDocument PrepaymentAssignedDocumentUUID Key
DocumentFrom I_AssignmentData DocumentFrom Document Type
ACMFromDocumentNumber I_AssignmentData ACMFromDocumentNumber DocNum
ACMFromDocumentItemNumber I_AssignmentData ACMFromDocumentItemNumber Item Number
TradingContractNumber I_AssignmentData ContractNum Trading Contract
TradingContractItem I_AssignmentData ContractItem Purchase Contract Item
ContractCommodityItem I_AssignmentData ContractCommodityItem Com. item num.
ReturnApplicationDocType I_ACMApplicationData ReturnApplicationDocType Document Type
ACMApplicationStatus I_ACMApplicationData ACMApplicationStatus
TrdgContractApplUnitOfMeasure I_ACMApplicationData TrdgContractApplUnitOfMeasure UoM: Conv. to
ContrItmProvisionalOverFillQty I_ACMApplicationData ContrItmProvisionalOverFillQty Overfill Quantity
ACMContrItmPrvsnlUnderFillQty I_ACMApplicationData ACMContrItmPrvsnlUnderFillQty Underfill Qty
TrdgContrItemOverFillQuantity I_ACMApplicationData TrdgContrItemOverFillQuantity Overfill Quantity
TrdgContrItemUnderFillQuantity I_ACMApplicationData TrdgContrItemUnderFillQuantity Underfill Qty
TrdgContrItemApplicationQty I_ACMApplicationData TrdgContrItemApplicationQty Applied Quantity
TrdgContrItemReturnQuantity I_ACMApplicationData TrdgContrItemReturnQuantity Return Qty
ContractApplStatusObject I_ACMApplicationData ContractApplStatusObject
TrdgContrCommoditySubitem I_ACMApplicationData TrdgContrCommoditySubitem Subitem
ContractApplicationType I_ACMApplicationData ContractApplicationType System Type
OverfillID I_ACMApplicationData OverfillID Overfill ID
ACMTrdgContrUnderFillID I_ACMApplicationData ACMTrdgContrUnderFillID Underfill ID
ACMAssignmentUUID I_ACMApplicationData ACMAssignmentUUID Assignment GUID
ContractItemAssignmentUUID I_AssignmentData ContractItemAssignmentUUID Assignment GUID
AssignmentQuantity I_AssignmentData AssignmentQuantity AssignedQuanOrig
TrdgContractItemUnitOfMeasure I_AssignmentData TrdgContractItemUnitOfMeasure Assigned UoM
PrepaymentConsumptionDocUUID P_PrepaymentAssignedDocument PrepaymentConsumptionDocUUID Key
SAPBusinessObjectTypeCode P_PrepaymentAssignedDocument SAPBusinessObjectTypeCode SAP Obj Rep
DocumentItemNumber P_PrepaymentAssignedDocument DocumentItemNumber Item
PrepaymentAgreement P_PrepaymentAssignedDocument PrepaymentAgreement Renegotiation PPA
PrepaymentAgrmtLinkType P_PrepaymentAssignedDocument PrepaymentAgrmtLinkType Link Type
PrepaymentStopIntrstDateType P_PrepaymentAssignedDocument PrepaymentStopIntrstDateType Int. Stop Date Type
ReferenceSettlementUUID P_PrepaymentAssignedDocument ReferenceSettlementUUID UUID
PrepaymentAgreementIsActive P_PrepaymentAssignedDocument PrepaymentAgreementIsActive Active
PrepaymentAgrmtRefLink P_PrepaymentAssignedDocument PrepaymentAgrmtRefLink Reference Link
PrepaymentAgrmtRefLinkUUID P_PrepaymentAssignedDocument PrepaymentAgrmtRefLinkUUID Key
PrepaymentAgrmtRefBusObject P_PrepaymentAssignedDocument PrepaymentAgrmtRefBusObject Business Object Type
PrepaymentAgrmtRefDocumentType P_PrepaymentAssignedDocument PrepaymentAgrmtRefDocumentType Document Type
SDDocumentCategory P_PrepaymentAssignedDocument SDDocumentCategory Document Cat.
PrepaymentAgrmtRefDocItem P_PrepaymentAssignedDocument PrepaymentAgrmtRefDocItem Linking Docu No. Itm
PrepaymentAgrmtRefDocYear P_PrepaymentAssignedDocument PrepaymentAgrmtRefDocYear Reference Doc Year
PrepaymentAgrmtRefDocAmount P_PrepaymentAssignedDocument PrepayAgrmtRefDocAmount Linking Document Amt
PrepaymentAgrmtLinkAmount
PrepaymentAgreementCurrency P_PrepaymentAssignedDocument PrepaymentAgreementCurrency Currency
PrepaymentAgrmtActualEventAmt P_PrepaymentAssignedDocument PrepaymentAgrmtActualEventAmt Pre Agrm Event Amt
PrepaymentAgrmtActualEventCrcy P_PrepaymentAssignedDocument PrepaymentAgrmtActualEventCrcy Currency
SettlementNetAmount P_PrepaymentAssignedDocument SettlementNetAmount
PrepaymentAgrmtConsumedAmount P_PrepaymentAssignedDocument PrepaymentAgrmtConsumedAmount
PrepayAgrmtAccrInterestAmount P_PrepaymentAssignedDocument PrepayAgrmtAccrInterestAmount Accrual Inter. Amt
PrepayAgrmtAccrInterestCrcy P_PrepaymentAssignedDocument PrepayAgrmtAccrInterestCrcy Accrual Inter. Curr
PrepayAgrmtValidFromDateTime P_PrepaymentAssignedDocument PrepayAgrmtValidFromDateTime Valid From Date Time
PrepayAgrmtValidToDateTime P_PrepaymentAssignedDocument PrepayAgrmtValidToDateTime Valid To Date Time
PrepaymentAgrmtUnlinkReason P_PrepaymentAssignedDocument PrepaymentAgrmtUnlinkReason
CreatedByUser P_PrepaymentAssignedDocument CreatedByUser User Name
CreationDateTime P_PrepaymentAssignedDocument CreationDateTime Timestamp
LastChangedByUser P_PrepaymentAssignedDocument LastChangedByUser User Name
LastChangeDateTime P_PrepaymentAssignedDocument LastChangeDateTime Timestamp
PrepaymentIsAssignedViaEconGrp P_PrepaymentAssignedDocument PrepaymentIsAssignedViaEconGrp
PrepaymentEconomicGroup P_PrepaymentAssignedDocument PrepaymentEconomicGroup Economic Group

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 I_ACMPrepaymentAssignedDoc.
-- 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 I_ACMPrepaymentAssignedDoc AS
SELECT
  AppData.ContractApplicationUUID AS ContractApplicationUUID,
  AppData.ContractApplicationVersion AS ContractApplicationVersion,
  AppData.ReferenceApplicationDocument AS ReferenceApplicationDocument,
  AppData.ReferenceApplicationItem AS ReferenceApplicationItem,
  AppData.ReferenceDocumentSide AS ACMDocumentSide,
  AppData.ApplicationDocumentSubItem AS ApplicationDocumentSubItem,
  PrepayAgrAsgndoc.PrepaymentAssignedDocumentUUID AS PrepaymentAssignedDocumentUUID,
  AssignmentData.DocumentFrom AS DocumentFrom,
  AssignmentData.ACMFromDocumentNumber AS ACMFromDocumentNumber,
  AssignmentData.ACMFromDocumentItemNumber AS ACMFromDocumentItemNumber,
  AssignmentData.ContractNum AS TradingContractNumber,
  AssignmentData.ContractItem AS TradingContractItem,
  AssignmentData.ContractCommodityItem AS ContractCommodityItem,
  AppData.ReturnApplicationDocType AS ReturnApplicationDocType,
  AppData.ACMApplicationStatus AS ACMApplicationStatus,
  AppData.TrdgContractApplUnitOfMeasure AS TrdgContractApplUnitOfMeasure,
  AppData.ContrItmProvisionalOverFillQty AS ContrItmProvisionalOverFillQty,
  AppData.ACMContrItmPrvsnlUnderFillQty AS ACMContrItmPrvsnlUnderFillQty,
  AppData.TrdgContrItemOverFillQuantity AS TrdgContrItemOverFillQuantity,
  AppData.TrdgContrItemUnderFillQuantity AS TrdgContrItemUnderFillQuantity,
  AppData.TrdgContrItemApplicationQty AS TrdgContrItemApplicationQty,
  AppData.TrdgContrItemReturnQuantity AS TrdgContrItemReturnQuantity,
  AppData.ContractApplStatusObject AS ContractApplStatusObject,
  AppData.TrdgContrCommoditySubitem AS TrdgContrCommoditySubitem,
  AppData.ContractApplicationType AS ContractApplicationType,
  AppData.OverfillID AS OverfillID,
  AppData.ACMTrdgContrUnderFillID AS ACMTrdgContrUnderFillID,
  AppData.ACMAssignmentUUID AS ACMAssignmentUUID,
  AssignmentData.ContractItemAssignmentUUID AS ContractItemAssignmentUUID,
  AssignmentData.AssignmentQuantity AS AssignmentQuantity,
  AssignmentData.TrdgContractItemUnitOfMeasure AS TrdgContractItemUnitOfMeasure,
  PrepayAgrAsgndoc.PrepaymentConsumptionDocUUID AS PrepaymentConsumptionDocUUID,
  PrepayAgrAsgndoc.SAPBusinessObjectTypeCode AS SAPBusinessObjectTypeCode,
  PrepayAgrAsgndoc.DocumentItemNumber AS DocumentItemNumber,
  PrepayAgrAsgndoc.PrepaymentAgreement AS PrepaymentAgreement,
  PrepayAgrAsgndoc.PrepaymentAgrmtLinkType AS PrepaymentAgrmtLinkType,
  PrepayAgrAsgndoc.PrepaymentStopIntrstDateType AS PrepaymentStopIntrstDateType,
  PrepayAgrAsgndoc.ReferenceSettlementUUID AS ReferenceSettlementUUID,
  PrepayAgrAsgndoc.PrepaymentAgreementIsActive AS PrepaymentAgreementIsActive,
  PrepayAgrAsgndoc.PrepaymentAgrmtRefLink AS PrepaymentAgrmtRefLink,
  PrepayAgrAsgndoc.PrepaymentAgrmtRefLinkUUID AS PrepaymentAgrmtRefLinkUUID,
  PrepayAgrAsgndoc.PrepaymentAgrmtRefBusObject AS PrepaymentAgrmtRefBusObject,
  PrepayAgrAsgndoc.PrepaymentAgrmtRefDocumentType AS PrepaymentAgrmtRefDocumentType,
  PrepayAgrAsgndoc.SDDocumentCategory AS SDDocumentCategory,
  PrepayAgrAsgndoc.PrepaymentAgrmtRefDocItem AS PrepaymentAgrmtRefDocItem,
  PrepayAgrAsgndoc.PrepaymentAgrmtRefDocYear AS PrepaymentAgrmtRefDocYear,
  PrepayAgrAsgndoc.PrepayAgrmtRefDocAmount AS PrepaymentAgrmtRefDocAmount,
  PrepayAgrAsgndoc.PrepaymentAgreementCurrency AS PrepaymentAgreementCurrency,
  PrepayAgrAsgndoc.PrepaymentAgrmtActualEventAmt AS PrepaymentAgrmtActualEventAmt,
  PrepayAgrAsgndoc.PrepaymentAgrmtActualEventCrcy AS PrepaymentAgrmtActualEventCrcy,
  PrepayAgrAsgndoc.SettlementNetAmount AS SettlementNetAmount,
  PrepayAgrAsgndoc.PrepaymentAgrmtConsumedAmount AS PrepaymentAgrmtConsumedAmount,
  PrepayAgrAsgndoc.PrepayAgrmtAccrInterestAmount AS PrepayAgrmtAccrInterestAmount,
  PrepayAgrAsgndoc.PrepayAgrmtAccrInterestCrcy AS PrepayAgrmtAccrInterestCrcy,
  PrepayAgrAsgndoc.PrepayAgrmtValidFromDateTime AS PrepayAgrmtValidFromDateTime,
  PrepayAgrAsgndoc.PrepayAgrmtValidToDateTime AS PrepayAgrmtValidToDateTime,
  PrepayAgrAsgndoc.PrepaymentAgrmtUnlinkReason AS PrepaymentAgrmtUnlinkReason,
  PrepayAgrAsgndoc.CreatedByUser AS CreatedByUser,
  PrepayAgrAsgndoc.CreationDateTime AS CreationDateTime,
  PrepayAgrAsgndoc.LastChangedByUser AS LastChangedByUser,
  PrepayAgrAsgndoc.LastChangeDateTime AS LastChangeDateTime,
  PrepayAgrAsgndoc.PrepaymentIsAssignedViaEconGrp AS PrepaymentIsAssignedViaEconGrp,
  PrepayAgrAsgndoc.PrepaymentEconomicGroup AS PrepaymentEconomicGroup
FROM P_PrepaymentAssignedDocument AS PrepayAgrAsgndoc
INNER JOIN I_AssignmentData AS AssignmentData ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMApplicationData AS AppData ON /* join condition not captured in parsed metadata */
;

Learn More