I_ALLPRODALLOCATIONSQNCASSGMT

CDS View
12 Fields 1 CDS Views

All Product Allocation Sequence Assignment

I_ALLPRODALLOCATIONSQNCASSGMT is a CDS View in S/4HANA. All Product Allocation Sequence Assignment. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdAllocationSqncAssgmtChg view_entity from COMPOSITE Product Allocation Sequence Assignment Change

Fields (12)

KeyField CDS FieldsUsed in Views
KEY DeletedChangeDocument DeletedChangeDocument 1
KEY ProdAllocSqncAssignmentUUID ProdAllocSqncAssignmentUUID 1
IsDeleted IsDeleted 1
Material Material 1
Plant Plant 1
ProdAllocHeaderBasicSearch ProdAllocHeaderBasicSearch 1
ProdAllocMaterialBasicSearch ProdAllocMaterialBasicSearch 1
ProdAllocPlantBasicSearch ProdAllocPlantBasicSearch 1
ProductAllocationSequence ProductAllocationSequence 1
ProductAllocationSequenceUUID ProductAllocationSequenceUUID 1
ValidityEndUTCDateTime ValidityEndUTCDateTime 1
ValidityStartUTCDateTime ValidityStartUTCDateTime 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.

-- All Product Allocation Sequence Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ALLPRODALLOCATIONSQNCASSGMT (
    DELETEDCHANGEDOCUMENT,
    PRODALLOCSQNCASSIGNMENTUUID,
    ISDELETED,
    MATERIAL,
    PLANT,
    PRODALLOCHEADERBASICSEARCH,
    PRODALLOCMATERIALBASICSEARCH,
    PRODALLOCPLANTBASICSEARCH,
    PRODUCTALLOCATIONSEQUENCE,
    PRODUCTALLOCATIONSEQUENCEUUID,
    VALIDITYENDUTCDATETIME,
    VALIDITYSTARTUTCDATETIME,
    PRIMARY KEY (DELETEDCHANGEDOCUMENT, PRODALLOCSQNCASSIGNMENTUUID)
);

Learn More