I_ACMAPPLDAPPLDOCDATA

CDS View
19 Fields 5 CDS Views

Application Document Item

I_ACMAPPLDAPPLDOCDATA is a CDS View in S/4HANA. Application Document Item. It contains 19 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
P_ACMAppliedApplicationData view from COMPOSITE
P_ACMAppliedApplicationsData view_entity from COMPOSITE
P_ACMAppliedApplLatestVerion view from COMPOSITE
P_AppliedApplicationData view from COMPOSITE
P_AppliedApplicationData view left_outer COMPOSITE

Fields (19)

KeyField CDS FieldsUsed in Views
KEY ApplicationVersion ApplicationVersion,ContractApplicationVersion 2
KEY ApplUniversallyUniIdentifier ApplUniversallyUniIdentifier,ContractApplicationUUID 2
ApplicationItemChangedOnDate ApplicationItemChangedOnDate 1
ApplicationItemCreatedOnDate ApplicationItemCreatedOnDate 1
ApplicationStatus ApplicationStatus,ContractApplicationStatus 2
ApplItemChangedOnDateTime ApplItemChangedOnDateTime 1
ApplItemCreatedOnDateTime ApplItemCreatedOnDateTime 1
BaseUnitofMeasure BaseUnitofMeasure 1
CommodityQuantityInBaseUnit CommodityQuantityInBaseUnit 1
ContractNum ContractNum,TradingContractNumber 3
PrecedingDocument PrecedingDocument,PredecessorDocumentNumber 2
PrecedingDocumentItem PrecedingDocumentItem,PredecessorDocumentItem 2
PrecedingDocumentVersion PrecedingDocumentVersion 1
ReferenceDocumentItem ApplicationDocumentItem,ReferenceDocumentItem 2
ReferenceDocumentNumber ReferenceDocumentNumber 1
ReferenceDocumentSide ReferenceDocumentSide 1
ReferenceDocumentType ReferenceDocumetType 1
SourceReferenceDocSubitem RefernceDocumentSubItem 1
TradingContractItem TradingContractItem 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Application Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACMAPPLDAPPLDOCDATA (
    APPLICATIONVERSION,
    APPLUNIVERSALLYUNIIDENTIFIER,
    APPLICATIONITEMCHANGEDONDATE,
    APPLICATIONITEMCREATEDONDATE,
    APPLICATIONSTATUS,
    APPLITEMCHANGEDONDATETIME,
    APPLITEMCREATEDONDATETIME,
    BASEUNITOFMEASURE,
    COMMODITYQUANTITYINBASEUNIT,
    CONTRACTNUM,
    PRECEDINGDOCUMENT,
    PRECEDINGDOCUMENTITEM,
    PRECEDINGDOCUMENTVERSION,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTNUMBER,
    REFERENCEDOCUMENTSIDE,
    REFERENCEDOCUMENTTYPE,
    SOURCEREFERENCEDOCSUBITEM,
    TRADINGCONTRACTITEM,
    PRIMARY KEY (APPLICATIONVERSION, APPLUNIVERSALLYUNIIDENTIFIER)
);

Learn More