SP

12 Fields

SP is an SAP database table in S/4HANA. It contains 12 fields.

Fields (12)

KeyField CDS FieldsUsed in Views
KEY SalesPlanUUID SalesPlanUUID 3
AssignedTeamID AssignedTeamID 1
CompanyCode CompanyCode 1
CreatedByUser CreatedByUser 2
MaterialGroup MaterialGroup 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
SalesPlan SalesPlan 2
SalesPlanDescription SalesPlanDescription 1
SalesPlanPurpose SalesPlanPurpose 1
SalesPlanVersion SalesPlanVersion 2
SourcingProjectType SourcingProjectType 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SP (
    SALESPLANUUID,
    ASSIGNEDTEAMID,
    COMPANYCODE,
    CREATEDBYUSER,
    MATERIALGROUP,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SALESPLAN,
    SALESPLANDESCRIPTION,
    SALESPLANPURPOSE,
    SALESPLANVERSION,
    SOURCINGPROJECTTYPE,
    PRIMARY KEY (SALESPLANUUID)
);

Learn More