R_SOURCINGPROJECTTP

CDS View
56 Fields 5 CDS Views

Sourcing Project - TP

R_SOURCINGPROJECTTP is a CDS View in S/4HANA. Sourcing Project - TP. It contains 56 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
A_SourcingProject view_entity projection CONSUMPTION Sourcing Project
C_SourcingProjectTP view_entity projection CONSUMPTION Sourcing Project - TP
C_SourcingProjectTP_F7757 view_entity from CONSUMPTION Sourcing Project - TP
ESH_N_SOURCINGPROJECT view from
I_SourcingProjectTP view_entity projection TRANSACTIONAL Sourcing Project - TP

Fields (56)

KeyField CDS FieldsUsed in Views
KEY SourcingProjectUUID SourcingProjectUUID 1
_ChangedByUser _ChangedByUser 1
_CreatedByUser _CreatedByUser 1
_DocumentCurrency _DocumentCurrency 1
_SourcingProjectType _SourcingProjectType 1
CashDiscount1Days CashDiscount1Days 1
CashDiscount1Percent CashDiscount1Percent 1
CashDiscount2Days CashDiscount2Days 1
CashDiscount2Percent CashDiscount2Percent 1
CentralPurchaseContract CentralPurchaseContract 1
CompanyCode CompanyCode 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
DocumentCurrency DocumentCurrency 1
ExternalSourcingProjectRef ExternalSourcingProjectRef 1
IncotermsClassification IncotermsClassification 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsTransferLocation IncotermsTransferLocation 1
IncotermsVersion IncotermsVersion 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
MaterialGroup MaterialGroup 1
NetPaymentDays NetPaymentDays 1
PaymentTerms PaymentTerms 1
ProcurementPlanningBundleUUID ProcurementPlanningBundleUUID 1
PurchaserRespWorkAgreement PurchaserRespWorkAgreement 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
PurContrValidityEndDate PurContrValidityEndDate 1
PurContrValidityStartDate PurContrValidityStartDate 1
QtnLatestSubmissionDateTime QtnLatestSubmissionDateTime 1
ShippingInstruction ShippingInstruction 1
SourceSourcingProjectUUID SourceSourcingProjectUUID 1
SourcingOrigin SourcingOrigin 1
SourcingProject SourcingProject 1
SourcingProjectName SourcingProjectName 1
SourcingProjectPhase SourcingProjectPhase 1
SourcingProjectType SourcingProjectType 1
SourcingProjectUniqueID SourcingProjectUniqueID 1
SourcingProjectVersion SourcingProjectVersion 1
SourcingProjectVersioningRsn SourcingProjectVersioningRsn 1
SourcingScenario SourcingScenario 1
SourcingSupplierListUUID SourcingSupplierListUUID 1
SrcgProjApprovalStatus SrcgProjApprovalStatus 1
SrcgProjAttchsAreForbidden SrcgProjAttchsAreForbidden 1
SrcgProjCancDteTme SrcgProjCancDteTme 1
SrcgProjCancellationRsn SrcgProjCancellationRsn 1
SrcgProjEarliestCndnSelDate SrcgProjEarliestCndnSelDate 1
SrcgProjFollowOnDocumentCat SrcgProjFollowOnDocumentCat 1
SrcgProjFollowOnDocumentType SrcgProjFollowOnDocumentType 1
SrcgProjHasBeenActivated SrcgProjHasBeenActivated 1
SrcgProjLifecycleStatus SrcgProjLifecycleStatus 1
SrcgProjNotesAreForbidden SrcgProjNotesAreForbidden 1
SrcgProjPaymentTermIsManual SrcgProjPaymentTermIsManual 1
SrcgProjPubgDteTme SrcgProjPubgDteTme 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.

-- Sourcing Project - TP
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_SOURCINGPROJECTTP (
    SOURCINGPROJECTUUID,
    _CHANGEDBYUSER,
    _CREATEDBYUSER,
    _DOCUMENTCURRENCY,
    _SOURCINGPROJECTTYPE,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    CENTRALPURCHASECONTRACT,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    DOCUMENTCURRENCY,
    EXTERNALSOURCINGPROJECTREF,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIALGROUP,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PROCUREMENTPLANNINGBUNDLEUUID,
    PURCHASERRESPWORKAGREEMENT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCONTRVALIDITYENDDATE,
    PURCONTRVALIDITYSTARTDATE,
    QTNLATESTSUBMISSIONDATETIME,
    SHIPPINGINSTRUCTION,
    SOURCESOURCINGPROJECTUUID,
    SOURCINGORIGIN,
    SOURCINGPROJECT,
    SOURCINGPROJECTNAME,
    SOURCINGPROJECTPHASE,
    SOURCINGPROJECTTYPE,
    SOURCINGPROJECTUNIQUEID,
    SOURCINGPROJECTVERSION,
    SOURCINGPROJECTVERSIONINGRSN,
    SOURCINGSCENARIO,
    SOURCINGSUPPLIERLISTUUID,
    SRCGPROJAPPROVALSTATUS,
    SRCGPROJATTCHSAREFORBIDDEN,
    SRCGPROJCANCDTETME,
    SRCGPROJCANCELLATIONRSN,
    SRCGPROJEARLIESTCNDNSELDATE,
    SRCGPROJFOLLOWONDOCUMENTCAT,
    SRCGPROJFOLLOWONDOCUMENTTYPE,
    SRCGPROJHASBEENACTIVATED,
    SRCGPROJLIFECYCLESTATUS,
    SRCGPROJNOTESAREFORBIDDEN,
    SRCGPROJPAYMENTTERMISMANUAL,
    SRCGPROJPUBGDTETME,
    PRIMARY KEY (SOURCINGPROJECTUUID)
);

Learn More