_SOURCINGPROJECT

20 Fields

_SOURCINGPROJECT is an SAP database table in S/4HANA. It contains 20 fields.

Fields (20)

KeyField CDS FieldsUsed in Views
KEY SourcingProject SourcingProject,SrcgProjItemProcFlowDocument 18
_DocumentCurrency _DocumentCurrency 1
CompanyCode CompanyCode 7
DocumentCurrency DocumentCurrency 13
ExchangeRateType ExchangeRateType 4
ExternalSourcingProjectRef ExternalSourcingProjectRef 1
MaterialGroup MaterialGroup 7
PurchaserResponsiblePerson PPSPurchaserResponsiblePerson 1
PurchasingCategory PurchasingCategory 2
PurchasingGroup PurchasingGroup 7
PurchasingOrganization PurchasingOrganization 7
QtnLatestSubmissionDateTime QtnLatestSubmissionDateTime 5
SourcingProjectIsTemplate SourcingProjectIsTemplate 3
SourcingProjectName SourcingProjectName 9
SourcingProjectType SourcingProjectType 24
SourcingProjectUUID SourcingProjectUUID 2
SourcingProjectVersion SourcingProjectVersion 12
SrcgProjLifecycleStatus PurchasingDocumentStatus,SrcgProjLifecycleStatus 10
SrcgProjPubgDteTme SrcgProjPubgDteTme 1
SrcgProjTotalTargetAmount SrcgProjTotalTargetAmount 3

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 _SOURCINGPROJECT (
    SOURCINGPROJECT,
    _DOCUMENTCURRENCY,
    COMPANYCODE,
    DOCUMENTCURRENCY,
    EXCHANGERATETYPE,
    EXTERNALSOURCINGPROJECTREF,
    MATERIALGROUP,
    PURCHASERRESPONSIBLEPERSON,
    PURCHASINGCATEGORY,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    QTNLATESTSUBMISSIONDATETIME,
    SOURCINGPROJECTISTEMPLATE,
    SOURCINGPROJECTNAME,
    SOURCINGPROJECTTYPE,
    SOURCINGPROJECTUUID,
    SOURCINGPROJECTVERSION,
    SRCGPROJLIFECYCLESTATUS,
    SRCGPROJPUBGDTETME,
    SRCGPROJTOTALTARGETAMOUNT,
    PRIMARY KEY (SOURCINGPROJECT)
);

Learn More