_SUBCTR

_SUBCTR is an SAP database table in S/4HANA. It contains 35 fields.

Fields (35)

KeyField CDS FieldsUsed in Views
KEY SuplrMatlPlnt SuplrMatlPlnt 1
AssemblyName AssemblyName 1
AuthorizationGroup AuthorizationGroup 1
Batch BatchFilterAnlytlMod 1
CompanyCode CompanyCode 1
DeliveryType SubcontrgOrdsNodeDeliveryType 1
FormattedPurchaseOrderItem FormattedPurchaseOrderItem 1
HierarchyNodeLevel HierarchyNodeLevel 1
LoadingGroup SubcontrgOrdsNodeLoadingGroup 1
MaterialComponentName MaterialComponentName 1
MaterialGroup MatlGrpFilterAnlytlMod 1
MaterialGroupName MaterialGroupName 1
ParentNode ParentNode 1
Plant PlntFilterAnlytlMod 1
PlantName PlantName 1
ProdPlntSupplierConcatenatedID ProdPlntSupplierConcatenatedID 1
ProposedShippingPoint SubcontrgOrdsNodePrpsdShipgPt 1
PurchaseOrderItem PurchasingDocumentItem 1
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 1
PurchasingDocumentType PurgDocTypeFilterAnlytlMod 1
PurchasingDocumentTypeName PurchasingDocumentTypeName 1
PurchasingGroupName PurchasingGroupName 1
PurchasingOrganizationName PurchasingOrganizationName 1
RequiredQuantity RequiredQuantity 1
ScheduleLineDeliveryDate SubcontrgDeliveryDate 1
ShippingStatusText ShippingStatusText 1
StillToBeDeliveredQuantity StillToBeDeliveredQuantity 1
StockBalanceQuantityUnit StockBalanceQuantityUnit 1
StockUnit StockUnit 1
StorageLocation SubcontrgOrdsNodeStorLocation 1
StorageLocationName StorageLocationName 1
Subcontractor SuplrFilterAnlytlMod 1
SupplierAccountGroup SupplierAccountGroup 1
SupplierName SupplierName 1
SupplyingPlantName SupplyingPlantName 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 _SUBCTR (
    SUPLRMATLPLNT,
    ASSEMBLYNAME,
    AUTHORIZATIONGROUP,
    BATCH,
    COMPANYCODE,
    DELIVERYTYPE,
    FORMATTEDPURCHASEORDERITEM,
    HIERARCHYNODELEVEL,
    LOADINGGROUP,
    MATERIALCOMPONENTNAME,
    MATERIALGROUP,
    MATERIALGROUPNAME,
    PARENTNODE,
    PLANT,
    PLANTNAME,
    PRODPLNTSUPPLIERCONCATENATEDID,
    PROPOSEDSHIPPINGPOINT,
    PURCHASEORDERITEM,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGDOCUMENTTYPENAME,
    PURCHASINGGROUPNAME,
    PURCHASINGORGANIZATIONNAME,
    REQUIREDQUANTITY,
    SCHEDULELINEDELIVERYDATE,
    SHIPPINGSTATUSTEXT,
    STILLTOBEDELIVEREDQUANTITY,
    STOCKBALANCEQUANTITYUNIT,
    STOCKUNIT,
    STORAGELOCATION,
    STORAGELOCATIONNAME,
    SUBCONTRACTOR,
    SUPPLIERACCOUNTGROUP,
    SUPPLIERNAME,
    SUPPLYINGPLANTNAME,
    PRIMARY KEY (SUPLRMATLPLNT)
);