I_SLSDOCCHGDOCUMENTITEMBASIC

CDS View

Change Document Item for Sales Document

I_SLSDOCCHGDOCUMENTITEMBASIC is a CDS View in S/4HANA. Change Document Item for Sales Document. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SlsDocChangeDocumentItem view_entity from COMPOSITE Change Document Item for Sales Document

Fields (26)

KeyField CDS FieldsUsed in Views
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField 1
KEY ChangeDocItemChangeType ChangeDocItemChangeType 1
KEY ChangeDocTableKey ChangeDocTableKey 1
KEY ChangeDocument ChangeDocument 1
KEY DatabaseTable DatabaseTable 1
KEY SalesDocument SalesDocument 1
BusinessSolutionOrder BusinessSolutionOrder 1
ChangeDocNewCurrency ChangeDocNewCurrency 1
ChangeDocNewFieldValue ChangeDocNewFieldValue 1
ChangeDocNewUnit ChangeDocNewUnit 1
ChangeDocObjectClass ChangeDocObjectClass 1
ChangeDocPreviousCurrency ChangeDocPreviousCurrency 1
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue 1
ChangeDocPreviousUnit ChangeDocPreviousUnit 1
ConditionType ConditionType 1
DistributionChannel DistributionChannel 1
OrganizationDivision OrganizationDivision 1
PartnerFunction PartnerFunction 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
SalesDocumentItem SalesDocumentItem 1
SalesDocumentType SalesDocumentType 1
SalesOrganization SalesOrganization 1
ScheduleLine ScheduleLine 1
SDDocumentCategory SDDocumentCategory 1
SDPricingProcedure SDPricingProcedure 1
SoldToParty SoldToParty 1

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.

-- Change Document Item for Sales Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SLSDOCCHGDOCUMENTITEMBASIC (
    CHANGEDOCDATABASETABLEFIELD,
    CHANGEDOCITEMCHANGETYPE,
    CHANGEDOCTABLEKEY,
    CHANGEDOCUMENT,
    DATABASETABLE,
    SALESDOCUMENT,
    BUSINESSSOLUTIONORDER,
    CHANGEDOCNEWCURRENCY,
    CHANGEDOCNEWFIELDVALUE,
    CHANGEDOCNEWUNIT,
    CHANGEDOCOBJECTCLASS,
    CHANGEDOCPREVIOUSCURRENCY,
    CHANGEDOCPREVIOUSFIELDVALUE,
    CHANGEDOCPREVIOUSUNIT,
    CONDITIONTYPE,
    DISTRIBUTIONCHANNEL,
    ORGANIZATIONDIVISION,
    PARTNERFUNCTION,
    PURCHASEORDERBYCUSTOMER,
    SALESDOCUMENTITEM,
    SALESDOCUMENTTYPE,
    SALESORGANIZATION,
    SCHEDULELINE,
    SDDOCUMENTCATEGORY,
    SDPRICINGPROCEDURE,
    SOLDTOPARTY,
    PRIMARY KEY (CHANGEDOCDATABASETABLEFIELD, CHANGEDOCITEMCHANGETYPE, CHANGEDOCTABLEKEY, CHANGEDOCUMENT, DATABASETABLE, SALESDOCUMENT)
);