I_CUSTOMERPROJECT

CDS View
19 Fields 6 CDS Views

Customer Project

I_CUSTOMERPROJECT is a CDS View in S/4HANA. Customer Project. It contains 19 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_CustomerProjectBilling view inner CONSUMPTION Customer Project Billing Document
C_CustomerProjectDetails view from CONSUMPTION Customer Project Details
C_CustomerProjectVH view from CONSUMPTION Customer Project Value Help
C_Custprojcustomercontact view from CONSUMPTION Customer contact details for Customer Projects
I_CustomerProjectPlanData view left_outer COMPOSITE Customer Project Planning Data
I_CustomerProjectVH view from BASIC Customer Project Value Help

Fields (19)

KeyField CDS FieldsUsed in Views
KEY Customer Customer 2
KEY CustomerProject CustomerProject 6
KEY CustomerProjectUUID CustomerProjectUUID 3
CostCenter CostCenter,EngagementProjectCostCenter 3
Currency Currency 1
CustomerProjectEndDate CustomerProjectEndDate 1
CustomerProjectName CustomerProjectName 3
CustomerProjectServiceOrg CustomerProjectServiceOrg 5
CustomerProjectStage CustomerProjectStage 1
CustomerProjectStartDate CustomerProjectStartDate 1
CustomerProjectType CustomerProjectType 4
CustomerProjectVisibility CustomerProjectVisibility 3
CustProjFinancialPlanUUID CustProjFinancialPlanUUID 1
CustProjMgrPersonnelNumber CustProjMgrPersonnelNumber,EmploymentInternalID 2
EngmntProjectHeaderCompanyCode EngmntProjectHeaderCompanyCode 2
LastChangeDateTime LastChangeDateTime 1
ProfitCenter ProfitCenter 3
ProjectProfileCode ProjectProfileCode 2
ProjectType EngagementProjectCategory 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.

-- Customer Project
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CUSTOMERPROJECT (
    CUSTOMER,
    CUSTOMERPROJECT,
    CUSTOMERPROJECTUUID,
    COSTCENTER,
    CURRENCY,
    CUSTOMERPROJECTENDDATE,
    CUSTOMERPROJECTNAME,
    CUSTOMERPROJECTSERVICEORG,
    CUSTOMERPROJECTSTAGE,
    CUSTOMERPROJECTSTARTDATE,
    CUSTOMERPROJECTTYPE,
    CUSTOMERPROJECTVISIBILITY,
    CUSTPROJFINANCIALPLANUUID,
    CUSTPROJMGRPERSONNELNUMBER,
    ENGMNTPROJECTHEADERCOMPANYCODE,
    LASTCHANGEDATETIME,
    PROFITCENTER,
    PROJECTPROFILECODE,
    PROJECTTYPE,
    PRIMARY KEY (CUSTOMER, CUSTOMERPROJECT, CUSTOMERPROJECTUUID)
);

Learn More